Sum of JPG by PC

select
    SYS.Netbios_Name0,
    sum(SF.FileSize)
From
    v_GS_SoftwareFile SF
    join v_R_System SYS on SYS.ResourceID = SF.ResourceID
Where
    SF.FileName like ‘%.jp%’
group by
    SYS.Netbios_Name0
ORDER BY
    SYS.Netbios_Name0

Leave a Reply

Your email address will not be published. Required fields are marked *