Great! Then ignore what I sent you which has to do with user affinity <https://technet.microsoft.com/en-us/library/gg699365.aspx> and the “primary” user. You’re looking for probably the System Console Usage <https://msdn.microsoft.com/en-us/library/cc146052.aspx> or System Console User <https://msdn.microsoft.com/en-us/library/cc143513.aspx> classes.
From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Ray Sent: Monday, February 1, 2016 12:05 PM To: mssms Subject: Re: [mssms] Specific collection membership machines with Primary users in SQL query Thanks Sherry and Nick..yes im looking for SYSTEM_CONSOLE_USER On Mon, Feb 1, 2016 at 10:38 AM, Nick <[email protected]> wrote: 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: [email protected] [mailto:[email protected]] 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 --
