Office 365 Desktop Apps Report
I am looking to build 1 or 2 reports in KACE SMA 10.2 that will show how many devices by each version of the old Microsoft Office 365 ProPlus and how many devices by each version of the new Microsoft 365 Apps for enterprise are installed in my environment. I can't seem to get a wizard report to correctly show this and I am not good at generating a SQL query.
I would like to run this report weekly to show our progress of getting all devices on the same Microsoft 365 Apps for enterprise version.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
IgorAngelini
2 years ago
Try:
ORG1.SAM_COUNT.INSTALLED_ON
FROM ORG1.SAM_COUNT
LEFT JOIN CATALOG.SAM_CATALOG
ON CATALOG.SAM_CATALOG.ID = ORG1.SAM_COUNT.SAM_CATALOG_ID
WHERE ORG1.SAM_COUNT.SAM_CATALOG_ID = "STE1284542"
OR ORG1.SAM_COUNT.SAM_CATALOG_ID = "STE1341717"
Just add more/change the OR statements with the app IDs that you want.
To get the APP ID go to Inventory > Software Catalog and open the app. Look at the URL:
[...]sam_detail_titled.php?ID=STE1341717&IS_MOBILE[...]If you use ORGs you may need to change the number on the SQL.
