@Zeeshan sidd Try this query: select U.Full_User_Name0 as 'Full User Name', U.Unique_User_Name0 as 'UserID', U.physicalDeliveryOfficeNam0 as 'Office', vr.Name0 as 'DeviceName' from dbo.v_R_User as u JOIN v_UsersPrimaryMachines as up on u.ResourceID = up.UserResourceID JOIN v_R_System as vr on vr.ResourceID = up.MachineID
SCCM USER DETAIL
Hi,
We need sccm report having following information;
Computer name, username, department and location.
Please share.
THANKS.
4 answers
Sort by: Most helpful
-
Abbia Zacharia 81 Reputation points Microsoft Employee
2021-05-16T16:14:10.257+00:00 -
Garth Jones 2,071 Reputation points
2021-01-25T20:21:09.81+00:00 CM does not inventory location or department by default. So....
-
Simon Ren-MSFT 30,496 Reputation points Microsoft Vendor
2021-01-26T07:57:21.2+00:00 Hi,
Thanks for posting in Microsoft MECM Q&A forum.
As Garth mentioned, CM does not inventory location or department by default. So you should enable the department and physicalDeliveryOfficeName attributes in the Active Directory, and then pull the data to SCCM report. For more detailed information, please refer to below articles:
How to Add a User’s Office Location Details to a Report
Adding the AD user department attribute to a report in SCCM
Note: They are non-Microsoft link, just for your reference.Best regards,
Simon
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. -
Simon Ren-MSFT 30,496 Reputation points Microsoft Vendor
2021-01-27T09:25:10.757+00:00 Hi,
Thanks for your reply.
The SQL Query is like below:
Select
U.Full_User_Name0 as 'Full User Name',
U.Unique_User_Name0 as 'UserID',
U.physicalDeliveryOfficeNam0 as 'Office',from
dbo.v_R_User as UOrder by
U.Full_User_Name0, U.Unique_User_Name0, U.physicalDeliveryOfficeNam0
More details in: How to Add a User’s Office Location Details to a Report
Here's an example that could get you started with:SQL Query: Find user’s primary device by Department AD attribute.
Best regards,
Simon
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.