Summary of harddisk space used by exe

First make sure your Software Inventory Client Agent collect *.exe

Here is the report that query *.exe

select

            v_GS_COMPUTER_SYSTEM.Name0 as 'PC Name',

            v_GS_COMPUTER_SYSTEM.UserName0 as 'User Name',

            sum(v_GS_SoftwareFile.fileSize/1024/1024) as 'Size in MB'

from

            v_GS_SoftwareFile,

            v_GS_COMPUTER_SYSTEM

Where

            v_GS_SoftwareFile.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID

            and v_GS_SoftwareFile.FileName like ('%.exe')

Group by

            v_GS_COMPUTER_SYSTEM.Name0,

            v_GS_COMPUTER_SYSTEM.UserName0

Order By

            v_GS_COMPUTER_SYSTEM.Name0,

            v_GS_COMPUTER_SYSTEM.UserName0