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 -- > > > >
