List PCs by PC Description

select
CS.Name0,
OS.Description0 
from
dbo.v_GS_OPERATING_SYSTEM OS,
dbo.v_GS_COMPUTER_SYSTEM CS
Where
CS.ResourceID = OS.ResourceID
Order by
CS.Name0

Submit a Comment

Your email address will not be published.