/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


licence compliance report

10/11/2019 220 views

i want to make a licence compliance report with Sw made by Adobe, how can i make it?


ty in advance

1 Comment   [ + ] Show comment

Comments

  • select (ID * 1000) AS ORDINAL,
    'Summary' AS TYPE, PRODUCT_NAME AS NAME, EDITION, PUBLISHER, INSTALL_COUNT, LICENSE_COUNT, VARIANCE, FORMAT(RISK,2) AS RISK, FORMAT(SURPLUS,2) AS SURPLUS,
    USAGE_30, NOT_USED_30, USAGE_60, NOT_USED_60, USAGE_90, NOT_USED_90, '' AS LICENSE_COVERAGE, '' AS SOFTWARE_PLATFORM
    from SAM_COMPLIANCE_SUMMARY
    where SUMMARY_TYPE = 'ProductEdition' and SAM_COMPLIANCE_SUMMARY.PUBLISHER = 'Adobe Systems, Inc.'
    group by ORDINAL

    this is what i have it works but doesnt show versions

Be the first to answer this question

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