Not 100% sure what you’re looking for, but I like to rely on system console usage for marrying users and computers and use the primary relationship for application deployment type detection purposes (when to install appV or use script).
Here’s something Select * from v_usermachinerelationship join v_fullcollectionmembership on v_fullcollectionmembership.name = v_usermachinerelationship.MachineResourceName and v_fullcollectionmembership.collectionid = 'ABC00001' From: listsadmin@lists.myitforum.com [mailto:listsadmin@lists.myitforum.com] On Behalf Of Kevin Ray Sent: Monday, February 1, 2016 10:09 AM To: mssms Subject: [mssms] Specific collection membership machines with Primary users in SQL query Hi Team, I'm looking for a specific collection membership machines with Primary users in SQL query Note :----Hardware 03A - Primary Computer User -- Is showing like Primary users count then if we drill down its showing the machine names --
