Count of Unidentified & Uncategorized software

SELECT
    ISC.NormalizedPublisher,
    ISC.NormalizedName,
    ISC.NormalizedVersion,
    ISC.CategoryName,
    count(*) as ‘count’
FROM
    dbo.v_GS_Installed_Software_Categorized ISC
WHERE
    ISC.FamilyName In (‘Unidentified’,’Uncategorized’)
group by
    ISC.NormalizedPublisher,
    ISC.NormalizedName,
    ISC.NormalizedVersion,
    ISC.CategoryName
order by
    ISC.NormalizedPublisher,
    ISC.NormalizedName,
    ISC.NormalizedVersion,
    ISC.CategoryName

Leave a Reply

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