SQL Query to get the assigned site code and client version

SQL Query:-

Here is the SQL Query to get assigned site code and client version.

Select vrs.Name0 'Machine Name', ss.SMS_Assigned_Sites0 'Assigned Site',vrs.Client_Version0 Version

From v_R_System vrs Join v_RA_System_SmsAssignedSites ss on vrs.ResourceID = sS.ResourceID

Join v_GS_Operating_System OS on vrs.ResourceID = OS.ResourceID

Where vrs.Client0 = 1

And vrs.Client_Type0 = 1

Order By 'Machine Name'

Output:-