SMS/SCCM SQL Query Netbios Name, Model , CPU name, Memory (Ram) and Sitecode


SELECT V_R_SYSTEM.Name0,v_RA_System_SMSInstalledSites.SMS_Installed_Sites0,v_GS_PROCESSOR.Name0,v_GS_COMPUTER_SYSTEM.Manufacturer0,v_GS_COMPUTER_SYSTEM.Model0,v_GS_COMPUTER_SYSTEM.Name0,v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 from v_r_system inner join v_GS_PROCESSOR on v_R_system.ResourceID=v_GS_PROCESSOR.ResourceID inner join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID=v_r_system.ResourceID inner join v_GS_X86_PC_MEMORY on v_GS_X86_PC_MEMORY.ResourceID=v_r_system.ResourceID inner join v_RA_System_SMSInstalledSites on v_RA_System_SMSInstalledSites.ResourceID=v_r_system.ResourceID

3 comments:

Anonymous said...

Very Nice. it helped me to pull the desired Report

Anonymous said...

Exactly hat i wanted!Thank's!
Espen :-)

Vinay said...

Hi Madan,
i am looking to added following info into your exsisting report but couldnt do it, please help

v_R_SYSTEM.Name0 AS 'Computer Name',
v_R_SYSTEM.User_Name0 AS 'User Name',
v_R_User.Full_User_Name0 AS 'Full User Name',
v_R_SYSTEM.canonicalname0 AS 'Computer AD Object Path',
v_R_User.canonicalname0 AS 'User AD Object Path',
v_R_SYSTEM.AD_Site_Name0 AS 'AD Site Name',

Post a Comment