How to identify Users and Primary Devices using SCCM Report

Benoit LecoursAugust 21 20192 Min Read

Founder of System Center Dudes. Based in Montreal, Canada, Senior Microsoft SCCM Consultant, 8 times Enterprise Mobility MVP. Working in the industry since 1999. His specialization is designing, deploying and configuring SCCM, mass deployment of Windows operating systems, Office 365 and Intune deployments.

Benoit Lecours

President

SCD Collaborators

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

In the Primary Machine Window, you can see all Machines associated to this user

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.

If you’re not running the latest version :

Go to Assets and Compliance \ Devices
Right-click a user and select Edit Primary Users

In the Primary User Window, you can see all user associated with this machine

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.

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.

Comments (5)

Pingback: https://www.bankep.com/www-sccm-report-user-login-history-com-portal-detailed-access-account-archives/

Carrie H

10.25.2019 AT 03:59 PM

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.

Hide replies

0 0

esme

10.22.2019 AT 11:40 AM

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

Adomlara

08.22.2019 AT 08:19 AM

best choice for you. We work nonstop to offer you speedy reaction and backing to get out of all hardships in a few couple of minutes. https://www.yahoo-phonenumber.org/

Jesse Bradford

08.21.2019 AT 03:40 PM

The item '/Dashboard - Device' cannot be found. (rsItemNotFound) Looks like it's dependant on a paid dashboard?

How to identify Users and Primary Devices using SCCM Report

Table of Content

Share

Identifying using User Collection

Identifying using Device Collection

Using SCCM Built-in report

SCD – SCCM Primary User Device Report

Share