SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

List PCs with Type and OS Name

select
    CS.Name0,
    CS.Systemtype0,
    OS.Caption0
from
    dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceId= OS.ResourceID

Published Mar 07 2009, 11:02 AM by Garth
Filed under: , , ,

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems