It would be nice to have a "local time" column in the reports instead of just UTC.

In the SQL query for the datawarehouse Endpoint report the line in the query "ELSE DATEDIFF(day, AntivirusSignatureUpdateDateTime, @Now) " means that there is never more than 7 days worth of data reported in the report. This is because this line says that anything over 7 days is non-compliant because it compares against @now.

A better comparison is against the date the data was entered i.e. "ELSE DATEDIFF(day, AntivirusSignatureUpdateDateTime, am.LastSyncTime_DW)" - which makes it relative to the Sync data rather than the date the report is run.

CMPivot should save the last 10-20 (or make it configurable) queries ran. Many times I will run a CMPivot query early in the day, then need to run it again later, or on a different connection. If there was a dropdown with recent queries, it would save a lot of time.

As there may be situations that admin would like to get extensive reporting if GPOs are in place and effective as planned in their organization, would be nice to have some dropdowns or listitems of GPOs that one could select to be as Configuration Items.

1000's of GPOs are available but sure MS has some ready list/xml/whatever that could be included in SCCM CI so reporting of GPOs, as they are just reg values, would be possible.

Posted by @arisaastamoinen

Consider to implement the option to copy/export the code from a dashboard or monitoring view. this should be the SQL code, that generates the view
This would give the possibility to present the data in e.g. PowerBI, Servicenow, Cherwell etc. and at the same time remove the
requirement for SCCM console access for users with reporting requirements.
The scope could be all nodes under monitorting

At least publish the code in a knowledge base doc. it will be very usefull managing several sites

The canned reports for Asset Intelligence are great, but they are out of date.
I don't see any updates or references to Windows 10, and I see Windows XP still listed, as well as many out of date, unsupported softwares.

For an upcoming upgrade, a refresh of all those canned reports would be fantastic.

We have a lot of subscriptions that use the same Report Name, and it is nearly impossible to determine which Subscription is which. Can you please add a Column to the Subscription pane that will show the 'Subject' of each particular Report? this will make it much easier to identify what each subscription is. Thanks!

Reporting is limited by the available data. A Location field allows geographic reporting.

Add a Report as Compliant 7 but not only for one SUG but several. When we deploy to computers we deploy montly updates but a old Baseile Aswell, we need to know the status of all of that deployments at once

In this section of SCCM: \Monitoring\Overview\Reporting\Reports\Hardware - Memory, it would be great to be able to see all computers that have less than 4GB of RAM, based on model. For example, I want to know how many of the Dell 3440s have 2GB so I can order more RAM for them.
Thanks!

No information is provided whether and what has changed within the reporting. I am particularly interested in very technical information, like stored procedures or changes that include the RBA model. Some of the changes might affect individually created reports, if they use the same methodology like the MS reports. Proactively apply those changes would suit me much better than waiting for an incident to be reported on a specific report -> detailed technical information on changes should be provided with each update (sp, used fn, ...)

In the database [dbo]. [ActiveDirectorySites] the name of the AD site is replicated in the site description and not taken from the AD site

The datawarehouse reports are a welcome addition. However it would be much more useful to be able to filter on collection for the report "Endpoint Protection and software updates compliance - Historical". We could then drill down to collections built on OS Version etc

I currently have over 60 reports that I have to copy on a daily basis to 13 different directories (due to their content/category) on a SharePoint site, as the OneDrive sync tool has issues, not to mention that persistent drive mapping to an MS hosted SharePoint site is not consistent, and I have to remap the drive when the site is failed over to a different server for patching, etc.
Manually copying these files is tedious.

As we get closer to the EOL of Winodws 7, it would be cool to have another widget in the Windows 10 servicing dashboard that shows Win10 v Win7 usage and the EOL date. Its a small thing but some additional visibility like that could help kick some orgs in the rear to get going on the upgrade to Win10.

With many people suddenly forced to work from home, we are trying to figure out how to deal with the fact that their computers will stop communicating with the KMS server. It would be extremely useful if MECM would have a standard, built-in report that provided the activation status of all computers. While I might not be able to update their activation, I could at least know how many are going to be falling out of compliance, as well as who and when.

TCP KeepAlive to port 4022 when Site-to-Site Communication disconected. And reporting result.

The "Software updates - Compliance by computer" sub-report is an easy way to see which computers have failed updates.

Updates often are in a "failed" state because the computer hasn't been restarted recently.

Therefore, adding the last time the computer restarted to the report would make it easy to quickly identify if that is the likely cause of failing updates.

(Additionally, adding "primary user" to the report would be appreciated.)

I would like to be able to go to Devices or open a collection of devices, or even from the queries section. Add whatever information I'm looking for in the "Columns to Fit" area then be able to export exactly what I have on my screen into Excel. It would make reporting so much more simple. For those small requests that managers give you.