SCCM SQL query to find total number of user profiles on workstation devices
-
SCCM SQL query to find total number of user profiles on workstation devices
How do I create an SQL query to find total number of user profiles on workstation devices.
We’ve got a lot of devices that have multiple profiles that take up a lot of local storage space.
This leads to other issues with Software Update installation failures. -
2 Replies
-
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 -
That works as treat. I’ll just copy and paste and create a table in SQL server reporting services report. Thank you for your help.
Log in to reply.