SCCM report computers Count of unidentified and uncategorized software’s:

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