Author Archive
VMWare Reporting Powerpack for PowerGUI updated.
by Ryan on Oct.21, 2011, under General
Managed to get a few more tweaks / scripts into the pack today. You can grab the powerpack from here:
Dell & HP Warranty Info from a CSV file of Tags
by Ryan on Sep.20, 2011, under Coding/Scripting, powershell, Servers, Sys Admin, Windows
I have tweaked my powershell script for the SCCM Dell/HP tags due to popular demand so that it can be run on a single machine using a list of service tags as the source and then will output to a CSV file. The source CSV can have any number of columns however it MUST have the following three for the script to work “Name,Vendor,Tag” in its default state. You also need to edit the $infile & $outfile variables as required.
VMWare vSphere 5 License Validator
by Ryan on Jul.25, 2011, under Coding/Scripting, powercli, powershell, Servers, Sys Admin, Virtualization
Deprecated - VMWare have release an official checker and there is a better script at http://virtu-al.net
This is a script I wrote to check vSphere 5 vRAM compliance.
Site Problems
by Ryan on Jul.19, 2011, under General, Site
Sorry to all those that have tried to contact me via the contact form, for some reason hotmail has been blocking emails from anyone not in my address book for what seems to be some time. I have no idea why or when they started this. I have changed the destination address for the contact form to another of my email accounts, so hopefully this has solved the problem. If you tried to contact me in the past and I have not replied it is most likely due to this. Please try again and I will respond, if you do not get a reponse please add a comment to this post so I know you have tried to contact me.
Regards,
Ryan
Dump Variables during OSD
by Ryan on Jul.08, 2011, under Coding/Scripting, SCCM SMS, Sys Admin, vbs, Windows
A while back I had a support case open with MS about some scripting in winPE. In order to debug the problem we wanted to see what variables were declared & what their values were. The support tech came up with the attachted script, I never got round to adding it to my scripts folder, so I ran it by opening a command shell in winPE (F8) then “net use Z: \\<mycomputer>\c$\users\<username>\desktop\”. Then I ran the script with “cscript.exe SCCMVarDump.vbs” a file is created in the same location as the script.
Dell & HP Warranty Info in SCCM
by Ryan on Jul.07, 2011, under Coding/Scripting, powershell, SCCM SMS, Sys Admin, Windows
Updated: 2011-08-18
This is the next evolution in the warranty info fight, Dell keep changing their site which is rather frustrating. I have re-written the Warranty Info Scripts in powershell as in my opinion the code is a lot cleaner and more manageable, I’ve tweaked the MOF edit required to read this.
One major change to the script is that I have added support for HP systems, now I must stress I only have one or two of these, both are out of warranty and only had base warranties so something may have been missed / may not work as expected. You can either fix it and let me know the changes you make or let me know, via the contact page, the tag of one of your systems and I will look at it when I get a chance.
If you use any other version of the script from my site you will need to update sms.mof as the reports have changed.
I am quite shameless so if you find this useful feel free to click on donate and well, donate. :D
What info do you get?
Update Custom Attributes for VMhosts in vCenter
by Ryan on Jun.23, 2011, under Coding/Scripting, powercli, powershell, Servers, Sys Admin, Virtualization
Yet another role added to my Job description, Now I am managing our Virtual Servers. So true to form I’ve dived headfirst into powershell / powercli to see what I can do. Some of the posts coming up on this will likely be similar to others around the web as I reinvent the wheel while I learn. But you never know one of you might find me 1st or I might do it in a way that suits you better.
First up is a simple script to read data from an xml file and then update custom attributes on the vmhosts.
SCCM All Computers, their OU and last Hardware Scan
by Ryan on Jun.23, 2011, under Coding/Scripting, SCCM SMS, SQL, Sys Admin, Windows
A quick Report to return all of the computers, the OU they are in and the last time they had a Hardware scan.
First we create a temporary table to hold the 1st pass results, then we query that table looking for the longest OU for each computer ( this way we only get 1 record per computer returned, otherwise each level of the OU a computer is a member of will be returned)
SCCM Serial Numbers and Asset Tags
by Ryan on Apr.10, 2011, under Coding/Scripting, SCCM SMS, SQL, Sys Admin, Windows
This is just a quick one, if you have dell machines (not sure if other manufacturers do it) but one of the BIOS options is ASSET TAG. Now this does not, as you would expect, appear in Win32_BIOS, instead it appears under Win32_SystemEnclosure.
Forefont Endpoint Protection Query Details
by Ryan on Feb.07, 2011, under Coding/Scripting, SCCM SMS, SQL, Windows
Those of us that installed FEP 2010 are no doubt annoyed that we cannot see the details of the queries used by SCCM to populate the FEP created collections.
The following will require acess to the SQL instance that SCCM uses as the querys are to be executed driectly on that instance.