Workstation & Server Audit Script V3

Thanks for the new code Alan. Your work is greatly appreciated!

Awesome script as usual. Your contributions are appreciated.

Hi Alan

How to i make this run if my servers have different passwords? It seems to run just fine on the local box i have powercli installed on but when i add a list of stand alone windows hosts off my ESX box, it fails to run (these boxes have a different administrator password than the one i am on)

@Virtu-Al
Hi Alan,

We host development servers for a number of different teams here so the admin password is usually one of 3. We never keep it the same as our ESX password and my powercli resides on the VC host itself. It would be nice if the txt file could contain an admin password it could use (not sure about security there) or have it prompt for an Admin password and have it keep using it on each subsequent server until it requires it to be changed, then it can prompt for the new password

I can see huge value for this script because once i host the server, the developers put it on me to make sure their environment is ok and healthy. I usually have to RDP into these hosts and check logs weekly. If the script could somehow do what i’ve asked it would be pure gold. Also could it email the results as well (something like your Dailyreport does).

Keep up the fantastic job. Your scripts have made my day to day stuff go much smoother and even helped us find a problem in our VC logs we didn’t even know existed !

Thanks again Alan. A joy to see …

The ability to pass it username and password from the text file would be a GREAT feature to this script. I have used a couple other scripts that have done this. One script that i love, that would love to see your script replace is SYDI (http://sydiproject.com/) Patrick is a great guy, but he doesn’t have much time to update his script any more. I would love to see some of the same things in his script in yours. Many of the features are already there, but the ability to write out the file to a word document or generate an overview file is great in my environment.

Keep up the great work Alan.

app

Thanks for the great Script . Can we have a method where in we can have the output in a single HTML file and then mail it to a Specific EMail ID ? may be we can look at removing Error logs to reduce the size of the HTML File .

looking forward to many more great scripts from you !!

Hi Alan,

Just came across your site recently. In fact I book marked it in a blog post a few months back and then went to find it last week now that our new vsphere infrastructure is humming away. Your daily healthcheck script is awesome and I would like to thank you for that. It also showed us errors in our vSphere servers that we are now troubleshooting!

Since I’m just starting out with Powershell, VESI, I hope too that one day I can contribute a script as userfriendly and as powerful as yours! Thank you.

za_mkh

Great script Alan.
An absolutely perfect solution to WW’s latest Microsoft licence audit.
Hope all’s well.
James

You can use this with any powershell script or command.

Get-Credential |

This will prompt you for your login and then run the commandlet or script as the new login

@Omarr

It cut out the command that I had typed. It should read

Get-Credential | commandlet or script name

Wow…great script! Cant wait to dissect this and uncover all of the HTML goodness you’ve got going on here.

Hi Alan… Thanks for the great script, once again you have done yourself proud. I’ve run this again out entire server farm, 300+ boxes and will schedule it to run every week to keep it up to date. Everyone here thinks it’s awesome. Even got James using it.

Could I make a suggestion for the next version. When you run the script, could it include a switch to either run a list of servers, something like “Audit.ps1 -L serverlist.txt” and a switch to audit individual servers, something like “Audit.ps1 -S servername”. Just a thought.

@Cory
Thanks for the comment, hopefully you will find it very easy to use

@Rob P
Great idea mate, let me know if you need any more info in there too.

Hey, this is a great script! Ran it on a couple machines and really like the output/format. Did run into one small problem that I thought I should report — on certain machines I get a divide by zero error on line 296. I believe this is because of a Q: drive that is 0 bytes (it was created by the Microsoft AppV client).

Yes , Attachement as a Single HTML file also would hold good since we can schedule it as per convenience . For that i think we might need to remove the Error logs part since error logs might increase the Size of the HTML File that is being atatched and most organizations would have restrictions on the attachment size. Thanks Again for the Great Script !!
@Virtu-Al

Hi Alan, could I suggest having the Computer Description on the ‘General’ section. Would be nice for us as the computer name isn’t always very helpful.

Cheers mate.

Great script!

A couple of changes I made when I used it in my environment:

1. Started with a ping check (using Win32_PingStatus) to make sure that the target computers are online

2. Added the following code to get software inventory on Windows 2003 servers where the Win32_Product had not been installed (code goes in the Else portion of the Win32_Product check):

$colApps = @()
$hklm = 2147483650
$key = “SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall”
$wmi = [wmiclass]“\\$Target\root\default:stdRegProv”
$subkeys = $wmi.EnumKey($hklm,$key)
foreach ($subkey in $subkeys.sNames){
#Filter out hotfixes
if ($subkey -notmatch “KB*”)
{
$appName = ($wmi.GetStringValue($hklm,”$key\$subkey”,”DisplayName”)).sValue
$appVersion = ($wmi.GetStringValue($hklm,”$key\$subkey”,”DisplayVersion”)).sValue
$appVendor = ($wmi.GetStringValue($hklm,”$key\$subkey”,”Publisher”)).sValue
$appInstalldate = ($wmi.GetStringValue($hklm,”$key\$subkey”,”InstallDate”)).sValue

#Format installation date if it exists
#Set a trap to catch exceptions thrown by ParseExact if date is not in the expected format
Trap {
continue
}
if ($appInstalldate)
{
$appInstalldate = [datetime]::ParseExact($appInstallDate,’yyyyMMdd’,$null).Date.ToShortDateString()
}

$objApps = New-Object System.Object | Add-Member NoteProperty Name $appName -PassThru | Add-Member NoteProperty Version $appVersion -PassThru | Add-Member NoteProperty Vendor $appVendor -PassThru | Add-Member NoteProperty “Install Date” $appInstalldate -PassThru

$colApps += $objApps
}
}
Write-Output “..Software (via registry)”
$MyReport += Get-CustomHeader “2″ “Software”
$MyReport += Get-HTMLTable $colApps
$MyReport += Get-CustomHeaderClose

Write-Output “..Software WMI class was not installed, used registry instead.”

Hi Alan,

Could you possibly add in the OS Build number in you next release ?

Have a great Christmas. Rob…