Forum Discussion
M365 Desktop Apps Reporting and Compliance
Using MECM 2203. We have deployed the M365 desktop apps to our estate using MECM but now we are looking to report on the versions out there and what patches have been applied etc. We currently allow them to patch directly form the CDN. How to achieve this?
- There are multiple ways to extract this information. You can start by looking at the M365 dashboard on the console. It gives a representation across channels, versions. You can also use the built in update compliance report against an SUG containing all the M365 updates. Or you can create your own custom report.
rahuljindal-MVP So in terms of the M365 Dashboards in the MECM console I assume you mean navigate to \Software Library\Overview\Office 365 Client Management ? I do this and I indeed see high level metrics as follows (i.e. counts of versions etc.):
What I need though is a tabular report showing me which systems are at which version. is there a canned/built-in report for this?
Try the following query as a collection query or using Monitoring/Queries:select distinct SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where LOWER(SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName) like "microsoft 365 apps for enterprise - en-us"
It should give you a starting point, you can then add additional attributes as needed.
