I have the following query to pull a list of all applications from all clients
and the count of each installation. Management wants to know if it's possible
to tell whether or not any of the applications are installed on a server OS.
That's a more advanced query than I have the ability to write. What would be
the best way to do that?
select distinct arp.DisplayName0 as 'Application Name'
,COUNT(1) AS COUNT
from v_GS_ADD_REMOVE_PROGRAMS arp
WHERE arp.DisplayName0 not like 'Security Update%'
AND arp.DisplayName0 not like 'Definition Update%'
AND arp.DisplayName0 not like 'Hotfix%'
AND arp.DisplayName0 not like 'Update for%'
GROUP BY arp.DisplayName0
Any guidance would be appreciated.
Thanks,
James
________________________________
Confidentiality Notice: This e-mail is intended only for the addressee named
above. It contains information that is privileged, confidential or otherwise
protected from use and disclosure. If you are not the intended recipient, you
are hereby notified that any review, disclosure, copying, or dissemination of
this transmission, or taking of any action in reliance on its contents, or
other use is strictly prohibited. If you have received this transmission in
error, please reply to the sender listed above immediately and permanently
delete this message from your inbox. Thank you for your cooperation.
