skip to main |
skip to sidebar
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:
Very Nice. it helped me to pull the desired Report
Exactly hat i wanted!Thank's!
Espen :-)
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