Tag: Report
SCCM CDP to WMI version 0.0.0.2 out
by Ryan on Nov.01, 2011, under C++, CDP to WMI, Cisco, Coding/Scripting, Projects, SCCM SMS, Windows
After a mass of updates to the code a new version is out, this is still experimental so should only be used in a lab environment.
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.
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?
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.
Rehome FCS
by Ryan on Jul.27, 2010, under Coding/Scripting, SCCM SMS, Sys Admin, vbs, Windows
When I was building our SCCM environment I decided it would be a good time to clean up WSUS & FCS and bring them under the new system.
The problem I ran into was “How do I repoint FCS?” without having to uninstall and reinstall it on every machine.
The solution, a bit of VB script based on the information here: http://blogs.technet.com/fcsnerds/archive/2008/11/12/changing-the-management-group-to-which-an-fcs-client-reports.aspx
SCCM Dell Driver Links in report
by Ryan on Apr.07, 2010, under SCCM SMS, Sys Admin, Windows
LAST UPDATED: 2010-04-12
These 2 reports will determine the link to the dell driver page for the systems based on their OS and Architecture.
SCCM Warranty Reporting
by Ryan on Mar.31, 2010, under General, SCCM SMS, Sys Admin, Windows
IIRC I got these on “myitforum” but I can’t remember where abouts.
I have modified them a bit to restrict to just the machines I have (mainly a Dell shop) and to exclude VMs.