Computer Inventory with Monitor Reports with SQL on SCCM

We should write;

select v_R_System.Name0, v_GS_PC_BIOS.Manufacturer0, v_GS_PC_BIOS.SerialNumber0,v_GS_COMPUTER_SYSTEM.Model0, AD_Site_Name0, User_Name0

FROM v_R_System JOIN v_GS_PC_BIOS on v_R_System.ResourceID = v_GS_PC_BIOS.ResourceID JOIN v_GS_COMPUTER_SYSTEM on v_R_System.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID

if you need Computer model you should write;

SELECT Manufacturer00, model00, name00
FROM Computer_System_DATA

İf you need Monitor inventory Sql Querry you can write

select v_GS_COMPUTER_SYSTEM.[Name0] AS 'Computer Name', 
v_GS_COMPUTER_SYSTEM.[UserName0] AS 'User Name',
v_GS_COMPUTER_SYSTEM.[UserName0] AS 'User Name',
v_GS_COMPUTER_SYSTEM.[Manufacturer0] AS 'Manufacturer', 
v_GS_COMPUTER_SYSTEM.[Model0] AS 'Model', 
/* v_GS_NETWORK_ADAPTER.[Name0] AS 'Network Adapter name', 
v_GS_NETWORK_ADAPTER.[AdapterType0] AS 'Network Adapter Type', 
v_GS_NETWORK_ADAPTER.[Description0] AS 'Network Adapter Description', 
v_GS_NETWORK_ADAPTER.[Manufacturer0] AS 'Network Adapter Manufacturer', */
v_GS_SYSTEM_ENCLOSURE.[SerialNumber0] AS 'Serial Number', 
v_GS_OPERATING_SYSTEM.[Caption0] AS 'Operating System', 
/* v_GS_SoftwareProduct.[CompanyName] AS 'Software Company', 
v_GS_SoftwareProduct.[ProductName] AS 'Product Name', 
v_GS_SoftwareProduct.[ProductVersion] AS 'Product Version', */ 
v_GS_DESKTOP_MONITOR.[MonitorManufacturer0] AS 'Monitor Manufacturer', 
v_GS_DESKTOP_MONITOR.[MonitorType0] AS 'Monitor Type'
from v_GS_COMPUTER_SYSTEM 
left join v_GS_SYSTEM_ENCLOSURE on v_GS_SYSTEM_ENCLOSURE.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceId

left join v_GS_OPERATING_SYSTEM on v_GS_OPERATING_SYSTEM.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceId

left join v_GS_X86_PC_MEMORY on v_GS_X86_PC_MEMORY.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceId

left join v_GS_DESKTOP_MONITOR on v_GS_DESKTOP_MONITOR.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID

Bir Cevap Yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir