SCCM USER DETAIL

Zeeshan sidd 1 Reputation point
2021-01-25T11:50:24.147+00:00

Hi,

We need sccm report having following information;

Computer name, username, department and location.

Please share.

THANKS.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,947 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Abbia Zacharia 81 Reputation points Microsoft Employee
    2021-05-16T16:14:10.257+00:00

    @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

    1 person found this answer helpful.
    0 comments
  2. Garth Jones 2,071 Reputation points
    2021-01-25T20:21:09.81+00:00

    CM does not inventory location or department by default. So....

  3. Simon Ren-MSFT 30,031 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.

    0 comments
  4. Simon Ren-MSFT 30,031 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 U

    Order 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.