Thanks for info Nick.. On Mon, Feb 1, 2016 at 1:14 PM, Nick <[email protected]> wrote:
> 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 -- > > > > > > > > > >
