troubleshooting Question

Want to get a count of software installed using a mysql query

Avatar of maximus81
maximus81Flag for United States of America asked on
MySQL Server
4 Comments1 Solution405 ViewsLast Modified:
Here is the query I have:

SELECT
sys_sw_software.software_name,
sys_sw_software.software_version
FROM
sys_sw_software, system
WHERE sys_sw_software.timestamp = system.timestamp
AND sys_sw_software.software_name LIKE '%Cisco% %Agent%'

This will list all the Cisco Agent software but I want to get a count of them for each version. We have three different versions installed and I want to get a count of each. I tried this query but it never gives me all the versions.

SELECT COUNT(DISTINCT system.system_id) AS
software_count,
sys_sw_software.software_name,
sys_sw_software.software_version,
sys_sw_software.software_publisher

FROM sys_sw_software, system

WHERE sys_sw_software.timestamp = system.timestamp
AND software_comment NOT LIKE 'Update'
AND software_comment NOT LIKE 'codec'
AND software_comment NOT LIKE 'odbc driver'
AND software_name NOT LIKE ''
AND software_name LIKE '%cisco%'
GROUP BY sys_sw_software.software_name
ORDER BY sys_sw_software.software_name
ASKER CERTIFIED SOLUTION
Ron Malmstead
Network Operations Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros