/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Help with KACE SQL

01/23/2020 191 views

Hello, I'm almost done with the script but I'm not sure how to get the software versions.

This is what I currently have:

SELECT CATALOG.SAM_CATALOG.NAME, PUBLISHER, SMJT.MINOR_VERSION AS 'Software Version', COUNT(DISTINCT SMJT.MACHINE_ID) AS INSTALLED_ON, CATALOG.SAM_CATALOG.ID  FROM CATALOG.SAM_CATALOG    join SAM_MACHINE_JT SMJT ON SMJT.SAM_CATALOG_ID = CATALOG.SAM_CATALOG.ID WHERE (CATALOG.SAM_CATALOG.SAM_TYPE = 'ADDREMOVE') AND ((CATALOG.SAM_CATALOG.NAME not like '%Driver%') AND (CATALOG.SAM_CATALOG.NAME not like '%Service Pack%') AND (CATALOG.SAM_CATALOG.NAME not like '%Update%') AND (CATALOG.SAM_CATALOG.NAME not like '%Redistributable%'))  GROUP BY CATALOG.SAM_CATALOG.ID ORDER BY INSTALLED_ON

It outputs the File Version column, but not the values.

What do I need to add so that it gives me the file version?

KCGfgqM4awwAAAABJRU5ErkJggg==




Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

1

See if this output is correct for the versions.


SELECT CATALOG.SAM_CATALOG.NAME,
CATALOG.SAM_CATALOG.PUBLISHER,
CATALOG.SAM_CATALOG.MAJOR_VERSION,
COUNT(DISTINCT SMJT.MACHINE_ID) AS INSTALLED_ON,
CATALOG.SAM_CATALOG.ID 
FROM CATALOG.SAM_CATALOG   
join SAM_MACHINE_JT SMJT ON SMJT.SAM_CATALOG_ID = CATALOG.SAM_CATALOG.ID
WHERE (CATALOG.SAM_CATALOG.SAM_TYPE = 'ADDREMOVE') AND ((CATALOG.SAM_CATALOG.NAME not like '%Driver%')
AND (CATALOG.SAM_CATALOG.NAME not like '%Service Pack%') AND (CATALOG.SAM_CATALOG.NAME not like '%Update%')
AND (CATALOG.SAM_CATALOG.NAME not like '%Redistributable%')) 
GROUP BY CATALOG.SAM_CATALOG.ID ORDER BY INSTALLED_ON
Answered 01/23/2020 by: KevinG
Black Belt

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