SCCM Collection displaying list of PC and thair Primary users
I'm trying to make a collection that would display All of the PC and Primary users of these PCs
I don't mean Top Console user, I mean primary user that get set by User Device Affinity.
Any help would be appreciated ?
On the side note, is there a good guide on writing these and report quires ? or maybe a wizard like UI to build queries
September 11th, 2015 12:56pm
If you want a collection that list Primary users of the device this is not possible. You can't have a collection that as device and users in it.
What you are looking for it's either a Query, SQL report or even a powershell to list all the primary users for your device.
-
Edited by
Frederick Dicaire
14 hours 30 minutes ago
September 11th, 2015 1:06pm
What i want is a list of PC that have a filed in it to indicate who is using it the most (the primary user assigned by the User Device Affinity.
and i want to be able to search/group that list.
For example i want to see if User X uses multiple PCs, how many and what PC names are they.
or group the list so it shows that User X have 4 PC's user
Y have 3 and user Z have 6
I guess Query under monitoring would work too. but what is the syntax for it ?
September 11th, 2015 1:13pm
Go here: http://www.mssccmfaq.de/2012/07/24/uda-per-sql-abfragen/
This is a SQL query that you can use. After with the report you can always export it in excel and play with it.
https://social.technet.microsoft.com/Forums/en-US/4e49152e-0973-495b-b4fd-2401c935a9d0/query-listing-primary-user-and-the-primary-device?forum=configmanagergeneral
-
Edited by
Frederick Dicaire
14 hours 18 minutes ago
September 11th, 2015 1:29pm
To add-on there is a canned report, named User device affinity associations per collection, that provides that information. If you really want to have a view in the console than you could use the ConsoleBuilder and do something like this:
http://gosc.nl/blog/technology/sccm/configmgr-2012-customization-creating-user-device-affinity-overview/
September 11th, 2015 2:00pm
If you want a collection that list Primary users of the device this is not possible. You can't have a collection that as device and users in it.
What you are looking for it's either a Query, SQL report or even a powershell to list all the primary users for your device.
-
Edited by
Frederick Dicaire
Friday, September 11, 2015 5:15 PM
September 11th, 2015 5:02pm
Go here: http://www.mssccmfaq.de/2012/07/24/uda-per-sql-abfragen/
This is a SQL query that you can use. After with the report you can always export it in excel and play with it.
https://social.technet.microsoft.com/Forums/en-US/4e49152e-0973-495b-b4fd-2401c935a9d0/query-listing-primary-user-and-the-primary-device?forum=configmanagergeneral
-
Edited by
Frederick Dicaire
Friday, September 11, 2015 5:27 PM
September 11th, 2015 5:26pm