SQL Query To Retrieve Advanced Clients Assigned Site Code And Client Version

 

This SQL Query will allow you to list the assigned site code and client version numbers for your advanced client resources.

 

SQL Query:

 

Select 

SD.Name0 'Machine Name',

SC.SMS_Assigned_Sites0 'Assigned Site',

SD.Client_Version0 Version

From v_R_System SD

 

Join v_RA_System_SmsAssignedSites SC on SD.ResourceID = SC.ResourceID

Join v_GS_Operating_System OS on SD.ResourceID = OS.ResourceID

 

Where SD.Client0 = 1

And SD.Client_Type0 = 1

 

Order By 'Machine Name'

 

 

 

 

Published Sunday, August 03, 2008 3:15 PM by dhite
Filed under:

Comments

No Comments