SMSUG.ca

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

Garth Jones

List PC with site code and site server name

SELECT CS.Name0, RA_SIS.SMS_Installed_Sites0, S.ServerName
FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_RA_System_SMSInstalledSites RA_SIS, dbo.v_Site S
WHERE CS.ResourceID = RA_SIS.ResourceID AND RA_SIS.SMS_Installed_Sites0 = S.SiteCode

Published Nov 23 2008, 09:49 PM by Garth
Filed under: , , ,

Comments

 

Query to fetch client machinenames with assigned SMS server names | keyongtech said:

Pingback from  Query to fetch client machinenames with assigned SMS server names | keyongtech

January 18, 2009 10:37 AM

This Blog

Syndication

News

Training

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