Description
To get images Monthly report per Username and Role
Query :
To get images Monthly report per Username and Role
Query :
Select SU.RoleName,SU.Username,SUM (AP.ImageCount) as ImageCount from AssetPurity AP join vwSecurity_UserList SU with (nolock) on SU.Userid = AP.CreatedbyUserid where AP.clientid = 228 and AP.CreatedOn >= '2025-08-01' and AP.CreatedOn < '2025-09-01' and StatusID = 13 GROUP BY SU.RoleName,SU.Username --------------------------------------------------