"Hardware 01A - Summary of computers in a specific collection" shows logical drive space in GB but column header show MB. Update OOB reports to match avail data in DB

Writing queries requires using WQL which has a very stripped back feature set. Please allow normal SQL queries to be used.

Would be nice to be able to tell within the console, or via a collection which servers are installed as server core, or with desktop experience without jumping through hoops.

missing Software Distribution report that will show deployment status (same as Status of a specified package and program deployment report)

Ability to show client data sources used on specific deployments in Reporting would be very helpful. The Client Data Sources dashboard does not prove the granularity I'm looking for.

It would be great if we could be a little more granular with this report and target it at a specific collection. I appreciate we can't add the device name into the report as it takes away the export to csv functionality but targeting a collection would help us more easily identify which machines we are importing into AutoPilot.

Currently, there is no other way to check that report subscriptions have executed correctly but to go in the console and check the Status column for each subscription.

It would be nice to add the possibility to create alerts on report subscription.

Benefits:
- admins & report users can be notified of reporting errors, without having to verify in the console
- admins no longer miss these errors because they check the console only seldom
- admins can take immediate action to investigate and fix the error

We have about 1200 computers, and would like to have a report to show the computers not shutdown after work duty

Display "Microsoft Update" as data source.
If you enable "fallback to Microsoft Update" for SUP deployment you cannot see this as data source. You can only see "Distribution Point", "Cloud Distribution Point", "BrachCache" and "Peer Cache"

v1710 issues with report "Hardware - Disk/Computers with low free disk space (less than specified MB free). Report name needs to reflect GB not MB. Which was changed in v1710

Inventory default unit revision
As devices now include hard drives with sizes in the gigabyte (GB), terabyte (TB) and larger scales, this release changes the default unit (SMS_Units) used in many views from megabytes (MB) to GB. For example, the v_gs_LogicalDisk.FreeSpace value now reports GB units.

I have build many custom RBAC web reports, cince moving to CB massive performance problems appear on this reports.

As part of a man day analysys i noticed that the most of them has a validation join to the TableValuedFunction "fn_rbac_R_System_Valid".

And finaly 6 hours of searching i found the bug that produces this performance Problem in the function named above.

Attached are the orginal and my improved DropAndRecreate.SQL Files.

The following sql query needs - executed with my own UserSIDs - needs more than 5 minutes without, and only 2 secounds with the improvement:

SELECT Netbios_Name0 FROM dbo.fn_rbac_R_System_Valid(@UserSIDs);

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.

Currently a computer seems to be marked as non-compliant if at least one update is missing in the DW tables. There are loads of reasons why this may be justified. The DW reports would be much better if we could filter on a SUG as that would be more meaningful for end users

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 noticed SCCM is not able to pull Microsoft SQL Server 2014 & 2016 Edition report i.e. Standard, Enterprise, Express or Datacentre.

This I have checked with multiple customers environment & in multiple SCCM version. Its very strange that Microsoft SCCM not able to pull Microsoft product inventory properly.

It would be nice to have a report to list all administrative actions performed by admins in a CM site. A report similar to "Administration activity log", but not limited to changes in the administrative roles section.

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.