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
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
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
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
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
5 matches
Mail list logo