/build/static/layout/Breadcrumb_cap_w.png

K1000 Report: List of installed softwares on the computers under the particular lable

Finding list of installed softwares on the computers under the particular lable

0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: anonymous_102124 10 years ago
Blue Belt
0
SQL Select Statement:

Resolution: 

 

SELECT (SELECT group_concat(distinct if(LABEL.NAME not like 'HDN_LABEL_%', LABEL.NAME, 'System Hidden') separator '
') FROM MACHINE_LABEL_JT MLJT INNER JOIN LABEL ON MLJT.LABEL_ID = LABEL.ID WHERE MACHINE.ID = MLJT.MACHINE_ID 

ORDER BY LABEL.NAME) as LABEL_NAME, MACHINE.NAME AS SYSTEM_NAME, (SELECT GROUP_CONCAT(DISPLAY_NAME order by

DISPLAY_NAME separator '') FROM SOFTWARE S2 INNER JOIN MACHINE_SOFTWARE_JT MSJT ON S2.ID = MSJT.SOFTWARE_ID 

WHERE MSJT.MACHINE_ID = MACHINE.ID) AS DISPLAY_NAME FROM MACHINE  WHERE ((( exists (select 1 from LABEL, MACHINE_LABEL_JT where 

MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID AND MACHINE_LABEL_JT.LABEL_ID = LABEL.ID  AND LABEL.TYPE <> 'hidden' and LABEL.NAME = 'Jnk-Comp')) ))  ORDER BY LABEL_NAME

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