/build/static/layout/Breadcrumb_cap_w.png
10/11/2019 112 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

There are no answers at this time