Hi, @Bruce Meyer
Thank you for posting in Microsoft Q&A forum.
SELECT distinct
v_R_System.Name0 AS 'Name',
CASE
WHEN v_R_System.Client_Type0 = '0' THEN 'Legacy'
WHEN v_R_System.Client_Type0 = '1' THEN 'Advanced'
ELSE 'Unknown'
END AS 'Client Type',
v_UserMachineRelationship.UniqueUserName AS 'Client Primary User',
v_R_System.User_Name0 AS 'Current User',
v_FullCollectionMembership.SiteCode AS 'SiteCode',
v_R_System.Active0 AS 'Activity',
v_R_System.Client_Version0 AS 'Active Client Version',
v_R_System.AD_Site_Name0 AS 'AD Site',
v_R_System.Full_Domain_Name0 AS 'Domain',
v_GS_WORKSTATION_STATUS.LastHWScan AS 'HW Scan',
v_GS_OPERATING_SYSTEM.Caption0 AS 'Operating System',
v_GS_OPERATING_SYSTEM.BuildNumber0 AS 'OS Build',
v_GS_WORKSTATION_STATUS.LastHWScan AS 'Last Activity'
FROM v_R_System
LEFT JOIN v_UserMachineRelationship on v_UserMachineRelationship.MachineResourceID = v_R_System.ResourceID
LEFT JOIN v_R_User ON v_R_User.Unique_User_Name0 = v_UserMachineRelationship.UniqueUserName
LEFT JOIN v_GS_WORKSTATION_STATUS ON v_GS_WORKSTATION_STATUS.ResourceID = v_R_System.ResourceID
LEFT JOIN v_GS_OPERATING_SYSTEM ON v_GS_OPERATING_SYSTEM.ResourceID = v_R_System.ResourceID
LEFT JOIN v_FullCollectionMembership ON v_FullCollectionMembership.ResourceID = v_R_System.ResourceID
WHERE v_R_System.Active0 = '1'
ORDER BY v_R_System.Name0
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.