First off lets get all the set up variables out of the way. A lot of these are the same variables I use in every script and I just copy them in each time so you may not want to use them all.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[cc lang="powershell"]$Transpath = $env:LOCALAPPDATA + "\Cloudwyse\Logs\scheduled_task_Report_" + $(get-date –Format ddMMyy_HHmmss) + ".log" Start-Transcript –Path $TransPath –NoClobber $DateTime = (Get-Date).ToString('ddMMyy_HHmmss') $ResultsPath = "C:\Cloudwyse\Scripts\Output\Scheduled_Task_Test_Output_" + $DateTime + ".csv" $Date = Get-Date –Format "dd-MM-yyyy" $Pass = cat C:\mysecurestring.txt | convertto-securestring $Cred = new-object –typename System.Management.Automation.PSCredential –argumentlist "CONTOSO\rick.sanchez",$Pass $DC = "DC01.contoso.com" $TaskReport = @() $TestedServers = 0 $OutputPath = "C:\Cloudwyse\Scripts\Output" $SplitSeparator = "" $SplitOption = [System.StringSplitOptions]::RemoveEmptyEntries[/cc] |
I like to use Write-Output to add the actions to the logfile (transcript) started in the previous section. I use this instead of comments as it does the same job but also makes reading the logs easier. I also prefer it to Write-Host since the latter is considered bad practise.
First we’re just going to make sure that the folder required for the logs already exists, and create it if not.
|
1 2 3 4 5 6 7 8 |
[cc lang="powershell"]Write-Output "Script started at $DateTime" Write-Output "Checking whether report destination path exists…" if (!(Test-Path $OutputPath)) { Write-Output "$OutputPath does not exist, creating it now…" New-Item –ItemType Directory –Force –Path $OutputPath } else { Write-Output "$OutputPath already exists, continuing with script…" }[/cc] |
Next make a connection to the DC (I prefer doing this than running scripts on the DC itself. Once this is done, run the LDAP query below to get all the servers in our environment.
|
1 2 3 4 5 6 7 |
[cc lang="powershell"]Write-Output "Establishing powershell session with $DC" $TargetSession = New-PSSession –ComputerName $DC –Credential $Cred Invoke-Command $TargetSession –Scriptblock {Import-Module ActiveDirectory} Import-PSSession $TargetSession –Module ActiveDirectory | out-null $serverlist = (Get-ADComputer –LDAPFilter "(&(objectcategory=computer)(OperatingSystem=*server*))").Name Write-Output "Server list is as follows: `r $serverlist" Write-Output "Querying $($serverlist.count) servers that were found with the LDAP Query"[/cc] |
Then we get into our foreach loop that is going to check through every server in the list. I’ve added a variable I’m calling $Skip. This jut allows me to speed of the execution of the script by skipping any servers that I know are going to fail. So I use Try Catch to test that I can access the path to my scheduled tasks. I’ve already trapped the error I need for unauthorised access and have it in my catch statement. If this error is triggered then the $Skip flag will be set to avoid wasting time on that record.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
[cc lang="powershell"]foreach ($server in $serverlist) { $Skip = $False $ServerFQDN = $Server + ".contoso.com" Write-Output "Checking server $serverFQDN" $serverpath = "\\\" + $serverFQDN + "\c$\Windows\System32\Tasks" Try { Write-Output "Testing $ServerPath" $PathTest = Test-Path $ServerPath –ErrorAction Stop } Catch [System.UnauthorizedAccessException] { Write-Output "Access to $ServerPath was denied. Setting skip flag for $ServerFQDN…" $Skip = $True } if (!$Skip) { if ($PathTest –match "False") { Write-Output "Server not found, setting skip flag for $ServerFQDN…" $Skip = $True } }[/cc] |
The next step will only run if the $Skip flag is not set. A list of tasks will be pulled together from the scheduled tasks library.
|
1 2 3 4 5 6 7 |
[cc lang="powershell"]if (!$Skip) { $tasks = Get-ChildItem –Path $serverpath –File Write-Output "Tasks for $serverFQDN as follows: `r $tasks" $TestedServers = $TestedServers +1 if ($tasks) { $TestedTasks = 0 Write-Output "Script has found $($tasks.count) scheduled tasks for $serverFQDN"[/cc] |
The script now works through each task in the variable and gets the content. If the task is not a system task it will be added to the hash table I’m using to generate the final list which will be exported using export-csv. I’ve recently changed the way I build these hash tables as I realised I was using an outdated method from Powershell V1 days previously. There’s a great article on the subject here.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
[cc lang="powershell"]foreach ($task in $tasks) { $TaskPath = $serverpath + "" + $task.Name $task = [xml] (Get-Content $TaskPath) [STRING]$check = $task.Task.Principals.Principal.UserId $SplitTaskPath = $TaskPath.split($SplitSeparator,$SplitOption) if ($task.Task.Principals.Principal.UserId) { $hash = @{ Server = $ServerFQDN TaskName = $SplitTaskPath[(($SplitTaskPath.count) – 1)] Command = $Task.task.actions.exec.command Owner = $task.Task.Principals.Principal.UserId } $Build = New-Object PSObject –Property $hash Write-Output "Adding a task to the list for $serverFQDN" $TaskReport += $Build $TestedTasks = $TestedTasks +1 } Write-Output "Added $TestedTasks of $($tasks.count) tasks to list for server $serverFQDN" } } else { Write-Output "No tasks found for server $serverFQDN" } Write-Output "All tests complete for server $server. $TestedServers out of $($serverlist.count) servers tested so far…" } else { $TestedServers = $TestedServers +1 Write-Output "Skipping server $ServerFQDN. $TestedServers out of $($serverlist.count) servers tested so far…" } }[/cc] |
Finally the script exports the results to the path created earlier and cleans up after itself.
|
1 2 3 4 5 6 7 |
[cc lang="powershell"]Write-Output "Script has tested $TestedServers servers…" Write-Output "Writing results to $ResultsPath" $TaskReport | Export-CSV $ResultsPath Write-Output "Removing Powershell session for $DC" Remove-PSSession $TargetSession Write-Output "Script complete… Goodbye! :)" Stop-Transcript[/cc] |
If you found the script helpful please leave a comment below or add a link to this article. Likewise if you notice any mistakes please share your experience. The entire script is available below. Good luck!
This is exactly what I was looking for, Thank you!