SMSUG.ca

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

Garth Jones

How to find all workstations with SNMP.

For full detail please see, http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/2eb10f29-0927-4b43-a4a4-0c712793673f

Select 
    CS.Name0 as 'PC Name',
    OS.Caption0 as 'OS',
    OS.CSDVersion0 as 'SP'
From
    dbo.v_GS_COMPUTER_SYSTEM CS
    join dbo.v_GS_SERVICE S on CS.ResourceID = S.ResourceID
    join dbo.v_GS_SYSTEM SYS on CS.ResourceID = SYS.ResourceID
    join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceID
Where
    S.DisplayName0 = 'SNMP Service'
    and SYS.SystemRole0 = 'Workstation'
Published Dec 29 2012, 11:39 AM by Garth
Filed under: , , , , , , , ,

Comments

 

FIFA 15 Crack Download said:

How to find all workstations with SNMP. - Garth Jones

September 7, 2014 7:50 PM
 

FIFA 15 Crack said:

How to find all workstations with SNMP. - Garth Jones

September 21, 2014 10:20 AM

This Blog

Syndication

News

Training

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