Count of file extensions.

Select
 CS.Name0,
 right(filename,4),
 count(right(filename,4))
from
 dbo.v_GS_SoftwareFile SF,
 dbo.v_GS_COMPUTER_SYSTEM CS
Where
 right(filename,4) in (‘.exe’, ‘.dll’)
 and CS.resourceID = SF.resourceID
Group by
 CS.Name0,
 right(filename,4)
order by
 CS.Name0

Leave a Reply

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