>

Collect the Monitor Serial Numbers for your CMDB Part2

Create a Report for looking the Clients Monitors insert this: SELECT DISTINCT v_r_system.netbios_name0 AS “Computer Name”, v_gs_system_enclosure.serialnumber0 AS “Serial Number”, v_GS_PC_BIOS.serialnumber0 AS “PC Bios Serial Number”, v_gs_computer_system.manufacturer0 AS “Computer Manufacturer”, v_gs_custominventoryinfo.model0 AS “Monitor Model”, v_gs_custominventoryinfo.SerialNumber0 AS “Monitor SN”   FROM v_gs_processor INNER JOIN v_r_system ON v_gs_processor.resourceid = v_r_system.resourceid INNER JOIN v_gs_system_enclosure ON v_gs_system_enclosure.resourceid = v_r_system.resourceid [...]

Posted on September 21, 2011 at 15:44 by mirko colemberg · Permalink · Leave a comment
In: Reporting, sccm, scripts · Tagged with: , ,

Collect the Monitor Serial Numbers for your CMDB Part1

First you have to install the WMI- Provider, written by Roger Zander Download Versions x86/x64: http://sourceforge.net/projects/wmimonitor/files/wmimonitor/V1.0.0.3/ Implement to SCCM and Push the installatio on every Client. Test it with the WMI-Command (read in Rogers Blog) Modify the sms_def.mof file on all Primary Sites. You can find the File in ‘%Program Files%\Microsoft Configuration Manager\inboxes\clifiles.src\hinv’ (copy first that [...]

Posted on September 21, 2011 at 15:18 by mirko colemberg · Permalink · 2 Comments
In: client, Discovery, sccm, scripts · Tagged with: , , ,