How to identify Users and Primary Devices using SCCM Report

Benoit LecoursSCCM4 Comments

Assigning your users to their primary machines in SCCM is a common task. It permits to identify the primary machine of a specific user and opens the possibility to install software only on primary machines. Once your associations are created, there are multiple ways to see the associations. This blog post will detail the various way to identify your user and primary machines and we also provide a free SCCM primary device report that you could use to easily find an association.

Identifying using User Collection

The most simple way to identify a primary machine for a user is to use the console. This method is simple but you will need to do that for each user which is not really productive.

  • In the SCCM Console
  • Go to Assets and Compliance \ Users
  • Right-click a user and select Edit Primary Devices
SCCM Primary User Device report
  • In the Primary Machine Window, you can see all Machines associated to this user
SCCM Primary User Device report

You can also click Primary Device in the related objects in the bottom right pane

Identifying using Device Collection

Since SCCM 1802 version, the console now includes a column for primary users.

SCCM Primary User Device report

If you’re not running the latest version :

  • Go to Assets and Compliance \ Devices
  • Right-click a user and select Edit Primary Users
SCCM Primary User Device report
  • In the Primary User Window, you can see all user associated with this machine
SCCM Primary User Device report

You can also click Primary Users in the related objects in the bottom right pane

Using SCCM Built-in report

There is a built-in report User device affinity associations per collection but the report is not giving you the option to search for a specific machine or user.

SCCM Primary User Device report

SCD – SCCM Primary User Device Report

Our free SCCM Primary User Device report list all users and their associated machine or device. You can easily search for a specific user or machine. The report will list all machines associated with a specific user. It can also be scoped by collections.

You can download this free SCCM Primary User Device report by visiting our product page. The Configuration Manager – Users and Primary Devices report is available in the Report / Configuration Manager Section.

SCCM Primary User Device report
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Share this Post

4 Comments on “How to identify Users and Primary Devices using SCCM Report”

  1. The only data that is populating for me is the primary machine name – all other fields are blank or N/A. AD User Discovery is enabled and several attributes loaded.

    Primary devices show up properly when I access a user object directly and vice-versa. Am I missing something? Thanks in advance.

  2. Hello, I have this query for obtain all machines that have primary users. my problem is in sql because appear one row for every primary users that machines has. How can obtain all the primary users in the same column separate for commas. Thanks.

    SELECT distinct TOP (100) PERCENT SYS.Name0 AS [Computer Name], SYS.User_Domain0 AS [Computer Domain], SYS.AD_Site_Name0 AS [Active Directory Site] , dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 AS [Chassis Types],
    dbo.v_GS_SYSTEM_ENCLOSURE.SMBIOSAssetTag0 AS [BIOS Asset Tag], dbo.v_GS_SYSTEM_ENCLOSURE.SerialNumber0 AS [Serial] , dbo.v_GS_SYSTEM_ENCLOSURE.Manufacturer0 AS [Manufacturer],
    dbo.v_GS_COMPUTER_SYSTEM.Model0 AS [Model], dbo.v_GS_PHYSICAL_MEMORY.Capacity0 [Memory in MB], dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [OS Version],
    dbo.v_GS_OPERATING_SYSTEM.OSArchitecture0 AS [OS Architecture], dbo.v_GS_OPERATING_SYSTEM.BuildNumber0 AS [OS Build], dbo.v_GS_COMPUTER_SYSTEM.UserName0 AS [Last Logged User Domain],
    USR.Full_User_Name0 AS [User CN], USR.Mail0 AS [User Mail], USR.SID0, USR.Distinguished_Name0 AS [User DN], USR.Unique_User_Name0 AS [ Primary User Name], SYS.Last_Logon_Timestamp0 AS [Last Logon Time]
    FROM dbo.v_GS_OPERATING_SYSTEM INNER JOIN
    dbo.v_R_System AS SYS ON dbo.v_GS_OPERATING_SYSTEM.ResourceID = SYS.ResourceID INNER JOIN
    dbo.v_GS_SYSTEM_ENCLOSURE ON SYS.ResourceID = dbo.v_GS_SYSTEM_ENCLOSURE.ResourceID INNER JOIN
    dbo.v_GS_COMPUTER_SYSTEM ON SYS.ResourceID = dbo.v_GS_COMPUTER_SYSTEM.ResourceID INNER JOIN
    dbo.v_GS_PHYSICAL_MEMORY ON SYS.ResourceID = dbo.v_GS_PHYSICAL_MEMORY.ResourceID LEFT OUTER JOIN
    dbo.v_UsersPrimaryMachines AS upm LEFT OUTER JOIN
    dbo.v_R_User AS USR ON upm.UserResourceID = USR.ResourceID ON SYS.ResourceID = upm.MachineID

    WHERE dbo.v_GS_OPERATING_SYSTEM.Caption0 NOT LIKE ‘%Server%’ and dbo.v_GS_PHYSICAL_MEMORY.Capacity0 > 4

    ORDER BY USR.Full_User_Name0

  3. The item ‘/Dashboard – Device’ cannot be found. (rsItemNotFound)

    Looks like it’s dependant on a paid dashboard?

Leave a Reply

Your email address will not be published. Required fields are marked *