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

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’