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

Related posts

Leave a Comment