[mssms] RE: Query for users with multiple primary devices

2017-04-03 Thread Beardsley, James
them. Because I like the report otherwise. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Heaton, Joseph@Wildlife Sent: Monday, April 03, 2017 7:20 PM To: mssms@lists.myitforum.com Subject: [mssms] RE: Query for users with multiple primary devices Why

[mssms] RE: Query for users with multiple primary devices

2017-04-03 Thread Heaton, Joseph@Wildlife
Why not just use the canned report? You can set the number of relationships to greater than 1. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Beardsley, James Sent: Thursday, March 30, 2017 10:02 AM To: mssms@lists.myitforum.com Subject: [mssms] Query

[mssms] RE: Query for users with multiple primary devices

2017-03-30 Thread Garth Jones
PM To: mssms@lists.myitforum.com Subject: [mssms] RE: Query for users with multiple primary devices You could use this and just filter excel to show the duplicates in the name field? SELECT UMR.MachineResourceID, UMR.MachineResourceName, UMR.UniqueUserName, Mail0 FROM v_R_User U J

Re: [mssms] RE: Query for users with multiple primary devices

2017-03-30 Thread Adam Juelich
Wouldn't this be a great feature? ::wink wink:: https://configurationmanager.uservoice.com/forums/300492-ideas/suggestions/15040527-option-to-specify-maximum-number-of-primary-device On Thu, Mar 30, 2017 at 2:28 PM, Enley, Carl wrote: > You could use this and just filter

[mssms] RE: Query for users with multiple primary devices

2017-03-30 Thread Enley, Carl
You could use this and just filter excel to show the duplicates in the name field? SELECT UMR.MachineResourceID, UMR.MachineResourceName, UMR.UniqueUserName, Mail0 FROM v_R_User U JOIN v_UserMachineRelationship UMR ON UMR.UniqueUserName = U.Unique_User_Name0 I also believe there is a built in