Who is you Asset Manager? Is it you?
Honestly, I would bother filtering out anything that I can’t guarantee is not licensable. This way I don’t accidently filter out something that should have been filtered out.
fcm.CollectionID = @CollID
AND arp.DisplayName0 not in(
'Microsoft Deployment Toolkit 2010 Update 1 (5.1.1642.01)',
'Microsoft Office SharePoint Designer 2007 Service Pack 3 (SP3)',
'VC Runtimes MSI',
'System Center Configuration Manager Help Updater',
'Windows Genuine Advantage v1.3.0254.0',
'Software Update Deployment SuperFlow',
'IIS 7.5 Express',
'IIS Search Engine Optimization Toolkit 1.0'
AND (Publisher0 LIKE 'Microsoft%')
AND DisplayName0 NOT LIKE '%Hotfix%'
AND DisplayName0 NOT LIKE '%Security Update%'
This is where the fun of asset management comes into play….