/build/static/layout/Breadcrumb_cap_w.png
01/07/2019 155 views

Hi All.

I Would like to create a smart label to get all freeware installed softwares in my environment.

Any Help?

0 Comments   [ + ] Show comments

Comments


All Answers

0

I do this as a report since license type is in the software catalog and that does not have a smart label create option.

SELECT SC.NAME AS SOFTWARE_NAME, SC.LICENSE_TYPE, SAM_COUNT.INSTALLED_ON  FROM SAM_MACHINE_JT  JOIN CATALOG.SAM_CATALOG SC ON SC.ID = SAM_MACHINE_JT.SAM_CATALOG_ID
JOIN SAM_COUNT ON SAM_COUNT.SAM_CATALOG_ID = SC.ID
LEFT JOIN SAM_METER_DATA SMD ON SMD.MACHINE_ID = SAM_MACHINE_JT.MACHINE_ID
    AND SMD.TITLED_APPLICATION_ID = SC.ID
LEFT JOIN SAM_METER_TITLED_APPLICATION SMTA ON SMTA.TITLED_APPLICATION_ID = SC.ID
LEFT JOIN SAM_NOT_ALLOWED SNA ON SNA.TITLED_APPLICATION_ID = SC.ID
LEFT JOIN MACHINE M ON M.ID = SAM_MACHINE_JT.MACHINE_ID
LEFT JOIN KBSYS.SAM_TITLE_REQUEST STR ON STR.SAM_APPLICATION_FILE_ID = SC.ID  WHERE (SC.SAM_TYPE IN ('TITLED_APPLICATION', 'TITLED_SUITE') AND (SC.SOFTWARE_CATEGORY_ID <> 32) AND SAM_COUNT.SAM_CATALOG_ID NOT IN (select SAM_CATALOG_ID from REPORT_SOFTWARE_CATALOG_EXCEPTION)) AND ((SAM_COUNT.INSTALLED_ON > '0') AND (SC.LICENSE_TYPE = 'Freeware'))  GROUP BY SAM_MACHINE_JT.SAM_CATALOG_ID ORDER BY SOFTWARE_NAME





Answered 01/07/2019 by: SMal.tmcc
Red Belt