SQL Query : User Machine Relationship with O/S (not server)

Really useful to report on User Device Affinity SELECT UMR.MachineResourceName ,UMR.MachineResourceID ,UMR.RelationActive ,UMR.CreationTime ,UMR.UniqueUserName ,VRS.operatingSystem0 FROM v_UserMachineRelationship UMR join v_R_System VRS on UMR.MachineResourceID = VRS.ResourceID WHERE VRS.operatingSystem0 not like ‘%server%’ order by UMR.MachineResourceName Sample OUTPUT

Read More