/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Server Name + Software Name and Version

08/24/2020 145 views

Anyone have an updated SQL query that will search for servers with a specific software title installed, then generate a report that shows the server name, software name and version?

1 Comment   [ + ] Show comment

Comments

  • Here is the SQL for finding the software but it only finds the servers and doesn't list the software or version:

    SELECT MACHINE.NAME AS SYSTEM_NAME, MACHINE.IP, OS_NAME FROM MACHINE WHERE ((( exists (select 1 from CATALOG.SAM_CATALOG JOIN SAM_MACHINE_JT on CATALOG.SAM_CATALOG.ID = SAM_MACHINE_JT.SAM_CATALOG_ID where MACHINE.ID = SAM_MACHINE_JT.MACHINE_ID and CATALOG.SAM_CATALOG.NAME like '%JAVA SE%')) )) ORDER BY SYSTEM_NAME

All Answers

This content is currently hidden from public view.
Reason: Member has been banned from the site SPAMMER For more information, visit our FAQ's.
This content is currently hidden from public view.
Reason: Member has been banned from the site SPAMMER For more information, visit our FAQ's.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ