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