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

INNER JOIN v_GS_PC_BIOS

ON v_GS_PC_BIOS.resourceid = v_r_system.resourceid

INNER JOIN v_gs_computer_system

ON v_gs_computer_system.resourceid = v_r_system.resourceid

INNER JOIN v_gs_custominventoryinfo

ON (v_gs_custominventoryinfo.resourceid = v_r_system.resourceid)

have fun, All information is provided “as is” without any warranty! Try in lab before. Handle with