Description
To get image count per user searching with ClientId
Query :
To get image count per user searching with ClientId
Query :
select sum(ImageCount), A.ClientId,Username,Name--, CreatedByUserId
from AssetPurity A
join Security_User B on A.CreatedByUserId=B.UserId
join Security_Role C on B.RoleId=C.RoleId
where A.clientid=100 and
cast(A.CreatedOn as date) between '2025-02-01' and '2025-02-28' and StatusId=13 and A.IsDeleted IN ('0','1')
group by A.ClientId,Username,Name
--------------------------------------------------