Report to list Printers

[jheideman]

I was wondering if there was a report that would allow me to see printers that are loaded on computers in our Domain.

 

I followed the instructions from (http://geekshangout.com/?q=node/41. I opened the sms_def.mof file, and set the SMS_Report to true for Printer Devices. I also went through and enabled a few of the items below it (Driver name, Location, portname, name, etc). After making these changes I created a report, but every time I run it I get the following error message (Invalid object name 'v_GS_PRINTER_DEVICE'.)

 

Any tips or advice would be greatly appreciated

[Trevor Sullivan]

You have to wait for the inventory information to come back from clients before the report will run. The SQL view you are trying to query indeed does not exist until the following happens:

 

1) Clients pickup change in SMS_DEF.mof

2) Clients run a hardware inventory cycle

3) Client sends inventory report to SCCM site server

4) Site server processes client MIF file and imports into database (creates tables / views automatically if necessary).

 

Hope this helps.

 

Cheers,

Trevor Sullivan

http://trevorsullivan.net

http://twitter.com/pcgeek86