The aim of this article is to configure Microsoft System Centre Configureation Manager 2007 SP1 or R2 to report on the locally installed printers, this in my case is very useful for reporting on printers installed and shared on our Print Server.
The fields we will report on are Netbios name of the computer, ShareName, Driver Name, Location, Port Name and Print processor but there are several other fields you can add.
This article assumes you already have SCCM up and running
Step1: Modify SMS_Def.mof on the Server
The SMS_Def.mof file basically details what hardware information stored in WMI you want to inventory from the clients.
SMS_Def.mof can be expanded to add new reported information but in the case of local printers the SMS_Def.mof file has all the configuration we need we just need to to tell SCCM that we want to report on "Printer Devices"
Open the SMS_Def.mof file on your server normally under \\severname\sms_sitecode\inboxes\cliefiles.src\hiv
Find the SMS Group "Printer Device"
Set the SMS_Report field just above to TRUE and set each of the feild below that you want to report on to TRUE
My SMS_Def.mof looks like the below
Save the file.
You will be unable to report on the new fields util clients get the new policy and start sending up data, to speed things up you can one one of the Clients that has the agent installed go into Control Pannel => Configuration Manager =>Actions Tab => Select Machine Policy Retrivel => Initiate Action
Step 2: Creating the Report
Within the SCCM console Site Database => Computer Managment => Reporting
Right-client Reports => New Report
Give it a name and select a category
Select Edit SQL Statement
My SQL statement is as below
However some people have reported problem with this SQL and instead have found the below works better