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

Related posts

Leave a Comment