SCCM All Computers, their OU and last Hardware Scan

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)

Continue reading “SCCM All Computers, their OU and last Hardware Scan”

SCCM Serial Numbers and Asset Tags

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.

Continue reading “SCCM Serial Numbers and Asset Tags”

Rehome FCS

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

Continue reading “Rehome FCS”