Share via

SCCM report, how to query all accounts on a specific computer

zhaob 赵标 0 Reputation points
2025-12-12T03:56:48.51+00:00

I want to use an SCCM report to find out how many accounts exist on a certain computer, including local or domain accounts. However, I haven't found a report like this in the existing report templates. I want to confirm if this query can be achieved on SCCM?

Moved from System Center Service Manager

Microsoft Security | Intune | Configuration Manager | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2025-12-12T03:56:57.93+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    In the context of SCCM (System Center Configuration Manager), there isn't a predefined report specifically designed to list all accounts (local or domain) on a specific computer. However, you can create a custom SQL query to achieve this by leveraging the SQL views available in SCCM.

    You would typically use the v_R_System view to get the computer details and join it with other relevant views that contain user account information. This would require some knowledge of SQL and the specific schema of the SCCM database.

    If you need further assistance on how to write such a query or create a custom report, you might want to refer to the documentation on creating custom reports in SCCM.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.