Scikar posted:

I might not be understanding right (I'm not great with coding jargon) but I think Get-Acl is already one step ahead of you. The object you get as output is just a copy of the ACL, if you make any changes to it then you still need to apply them to a target with Set-Acl (or equivalent) afterwards.

E: Just realised that part doesn't actually use Get-Acl, whoops! I'll see if I can't find the right script I was thinking of.

Wicaeed posted:

Quick question regarding this script (a friend wrote it and I tweaked it):

http://pastebin.com/RRxeK3CF

If I wanted to return only servers that match a certain part of the results on the 'logonserver' portion, or the 'NTP Source' result, how could I do that?

adaz posted:

The spiffy way is to re-write the thing to return you objects and filter off the objects

code:

       $computerInfo = New-Object –TypeName PSObject
       $computerInfo | Add-Member –MemberType NoteProperty –Name IPReachable –Value $reachable

adaz posted:

Each SQL query is unique? How many are there? Is there any reason why you need to exclude the leftmost column as opposed to just not querying for that data?

To get started what I'd use is a function I wrote long ago and my normal method of avoiding export-CSV's... eccentricities. Yes it would be a glorious world where we could just pipe the DataSet to export-csv and it'd handle it gracefully... unfortunately that world doesn't exist.

code:

############
# SQL Data #
############
function Get-SqlData
{
param(
[parameter(Mandatory=$true,HelpMessage="SQL Server to connect to.")]
[string]$serverName,

[parameter(mandatory=$true,HelpMessage="SQL DB")]
[string]$databaseName,

[parameter(mandatory=$true,HelpMessage="SQL Query to run.")]
[string]$query
)
    $SQLDT = New-Object "System.Data.DataTable"
    $connString = "Server=$serverName;Database=$databaseName;Integrated Security=SSPI;"
    $da = New-Object "System.Data.SqlClient.SqlDataAdapter" ($query,$connString)
    [void]$da.fill($sqlDt)
    return $sqlDt
}

So as an example for how get-SqlData works and how you'd export it to CSV

code:

# Execute our SQL Query and store the data in the $queryResults variable.
$queryResults = Get-SqlData -server sqlserver -database databasename -query "select firstname,lastname from employees where lastname like 'd%'"

# Initialize our array which we will use to store then data and then
# to pipe to Export-CSv
$exportTable = @()

# add the result sets to the array
foreach($result in $queryResults) {
   # shorthand method of creating an object with two properties called 
   # firstname, lastname.
   $OutObj = "" | select firstname,lastname
   # set the properties on each object.
   $outObj.Firstname = $result.firstname
   $outObj.lastName = $result.Lastname
   #add the Object to our array for later exporting
   $exportTable += $outObj
}
# Export out to CSV
$exportTable | export-Csv C:\blah\blah.csv -noTypeInformation

With dates and so forth look at Get-Date and system.datetime class, should have all the functions you need for formatting your date/time string however you want.

Djimi posted:

I spent about 30+ minutes on the internet and did a few searches in the cavern here for figuring out my attempt to find/replace with regex matching and using the found pattern in the replacement to create links to other files. The only matches / replacements I need are the beginning of the line in an html table page, so I should be able to anchor with ^.

I don't know powershell that well, and I'm probably worse in regex

A line in the file to find/replace would be:

code:

<tr><td>something</td>...more html...<td></td>s etc...blah blah
<tr><td>something-else</td>....blah blah blah more <td></td>s
<tr><td>SOME-OTHER-THING ....blah blah blah more <td></td>s

So I found a page that said I could basically do something like line 6 below which could be line an inline replacement like sed -i

code:

$html= (gc .\file.html)
$new_html= .\new_file.html
$open="<tr><td><a href=`""
$mid="`"</a>"
$ext="_page.log"
$close="</td>"
$link = [regex]::replace($html, "^<tr><td>(\w+)</td>", '$open $1 $mid $1 $ext $close');

Nothing is matching and if I can get it to match, I'm pretty sure I need to have an OR section for the cases where there is the hyphen(s) on the matching/replacing line.

Thanks in advance

Ithaqua posted:

For the record, parsing HTML with regexes is not recommended. Something like the HTML Agility Pack would make your life much easier.

Frag Man posted:

Pseudocode looks something like this: Backup.ps1 $Source $Destination $Reclusive? $Specifics?

My problem is how I make Powershell not confuse one parameter for another if one is left out. Like if I wrote $Reclusive and $Specifics but left out $Destination.

Frag Man posted:

Frag Man posted:

Example: PS C:\. backup.ps1 C:\folder\ C:\Backup\ -recurse Yes -specifics *.txt

AreWeDrunkYet posted:

It may be against the spirit of the assignment, but you can just take those parameters and pass them over to robocopy to avoid reinventing the wheel.

Backupscript posted:

Param ($path, $to="C:\backup\", $re = "nej", $wild="nej")

$date=get-date -format "yyyy-MM-dd_HH-mm-ss"
$TestPath=test-path -path $path

If(-not $TestPath)
{
Write-host "No sourcedirectory stated"
Break
}

$NyMapp=New-Item -path $to\"backup_$date" -itemtype directory
$to2=$NyMapp
Write-host "Directory created at $to2"


If($re -eq "ja" -and $wild -ne "nej")
{
copy-item -filter $wild -path $path -Recurse -destination $to2
}

ElseIf($re -eq "ja")
{
copy-item -path "$path" -Recurse -destination $to2
}


Elseif($Wild -ne "nej")
{
#$a=Get-ChildItem -path $path "$wild"
copy-item "$path\$wild" -destination $to2
}


Else
{
#copy-item -path $path -destination $to
#$a=get-childitem -path $path;
copy-item "$path\*" -destination $to2
}

Get-childItem -path "$to2" -Recurse | rename-item -NewName {$_.name +".bak"}
Get-ChildItem -path "$to2" -Recurse | Out-File $to\Backup_$date.log
Get-ChildItem -path "$to2" -Recurse | Out-File $Path\Backup_$date.log

Djimi posted:

And I think you mean recursive not reclusive - but maybe you do — I know some /dev/null files that never go anywhere.

Frag Man posted:

That's exactly what we aren't allowed to do. Our teacher has several times stated that some methods arent allowed, such as robocopy or using arraylists. Usually after some students have spent several hours writing functions using those methods. If someone could clarify why some methods wouldnt be allowed I'd be vary happy, cause our teacher sure as hell won't.

Dravs posted:

Ugh, I need help with a script.

Quite simply, I am trying to output a list of users who are in one group, yet not in another.

I can do Get-ADUser -Filter {(memberof -ne "group name 1")} and it will output AD accounts which are not in that group.

I then tried Get-ADUser -Filter {((memberof -ne "Group name 1") -AND (memberof -eq "group name 2"))} and it does not output anything. In fact the -eq switch does not seem to work, if I run with just that I see nothing.

Is there anyway to do what I am trying to do? I have been banging my head against this for a couple of hours and the above it the closest I have got.

Dravs posted:

My powershell knowledge is almost non-existent so I am picking this up as I go along. How do you do an LDAP query?

Son of Thunderbeast posted:

Oh yeah and another really stupid loving oversight I didn't think about until today; I've been testing this locally and apparently I have PoSh v3, and the server has PoSh v2. I'm about to test it there and see what errors I get.