That includes mobile devices. I'm trying to exclude those so it only shows me users with multiple laptops assigned.
I looked at the SQL behind the canned report to see if I could exclude mobile devices and its way too advanced for my novice SQL skills. If you have any tips, I'd love to hear 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 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> [mailto:listsad...@lists.myitforum.com] On Behalf Of Beardsley, James Sent: Thursday, March 30, 2017 10:02 AM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: [mssms] Query for users with multiple primary devices Anyone have a SQL query that'll show me all users with more than one primary device assigned to them through UDA? Thanks, James ________________________________ Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation. ________________________________ Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation.
