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.


Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
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.


Free Windows Admin Tool Kit Click here and download it now
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
September 11th, 2015 5:26pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics