Received the following question:
I want to make a report that list everything from add/remove programs and do a count like the report : “Count of all instances of software registered with Add or Remove Programs”. I have cloned the report and try to exclude all the following publishers:
Hewlett-Packard
LSI Corporation
Agere Systems
Solution, use the NOT IN operator and add to the list of excluded publishers as needed:
SELECT [DisplayName0], COUNT([DisplayName0]) as Total
FROM [v_GS_ADD_REMOVE_PROGRAMS]
WHERE [DisplayName0] NOT IN ('Hewlett-Packard', 'LSI Corporation', 'Agere Systems')
GROUP BY [DisplayName0]
GO