SQL Query : All Systems with Make, Model, OS

Fairly straightforward query.  You can expand this to use as many columns from the v_R_System view as you need. SELECT DISTINCT dbo.v_R_System.Name0 AS MachineName, dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0 AS Make, dbo.v_GS_COMPUTER_SYSTEM.Model0 AS Model, dbo.vSMS_R_System.Operating_System_Name_and0 AS OS FROM dbo.v_R_System INNER JOIN dbo.v_GS_COMPUTER_SYSTEM ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_R_System.ResourceID INNER JOIN dbo.vSMS_R_System ON dbo.v_R_System.Name0 = dbo.vSMS_R_System.Name0 order by Name0 Sample Output

Read More