Systems Management

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 - acid8k 5 years ago