SCCMTSPSI
SCCMTSPSI

Reply To: SCCM SQL query to find total number of user profiles on workstation devices

  • Topaz George

    Organizer
    21 July 2020 at 9:14 am

    Does the below SQL query help?

    select v_R_System.Name0, Count(LocalPath0) as profileTotal from v_GS_USER_PROFILE
    left join v_R_System ON v_R_System.ResourceID = v_GS_USER_PROFILE.ResourceID
    where LocalPath0 LIKE '%\users\%' and v_R_System.Operating_System_Name_and0 LIKE '%worksta%'
    group by v_R_System.Name0 order by profileTotal desc

DCOM hardening issue.

This application fails to authenticate with WMI on the SCCM server because Microsoft has not yet hardened DCOM on their Windows Preinstallation Environment. We are working on a different approach, but it will only be released during the first quarter of 2024. But until that time, the only workaround will be to uninstall the update corresponding to KB5004442.