When you export any default report from CM SSRS as CSV, each line of the export contains also the complete header information, makes the report unreadable and not useful for further processing.

The Issue is described in more detail here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4a9ba696-e040-414d-b2f1-a24bfaf2289c/sccm-2012r2-reports-exporting-to-csv-incorrect-values-displaying?forum=sqlreportingservices

Windows Server 2016
SCCM just upgraded to SCCM CB 1806

When i run the Report "Lifecycle 01A - Computers with a specific software product" and i select "Windows 10, version 1703" it throws an error:
Error The SELECT permission was denied on the object 'v_WindowsServicingStates'
It Works fine if I for example select "Windows 8.1"

I could reproduce it both environments - Test and Live.

Solution:
smsschm_users had no rights on the view 'v_WindowsServicingStates' for select
set it manually, then it works

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

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!

The ability to create email subscriptions gives rudimentary notification when alerts happen. The ability to run a powershell script would open the possibility of integrating with 3rd party monitoring and notification systems. Current systems such as Solarwinds, PRTG,nagios/icinga2 and others have REST interfaces that can easily be addressed from powershell. This kind of integration would enable shops that choose not to run SCOM a way to integrate SCCM alerts into their existing monitoring set ups.

Ideally the script call would be able to pass the alert data to the script in some fashion.

if you plan a report, e.g. "Antimalware overall status and history", to run every 1st day each month for example, you can only enter fixed dates for the report.
There should be relative options like "first day of previous month" (see SCOM for good examples)

It would be good to be able to trigger a subscription report on demand. For testing etc...

It would be great to be able to report on within SQL how many clients in total have connected to a Management Point/s.

The scenario being for example, in a newly configured IBCM environment it would be nice to be able to report on how many clients in total have connected to one of the IBCM enabled MP's, business use being able to report on current uptake.

Currently you can report on LastScan but that is unfortunately only taken as a current snapshot and data would change as clients move back and forth between Internet and Intranet networks.

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.

Would like to have a Table with a Resource ID , timestamp , and compliance %, vendor and Update Classification. The table aggregation interval could be daily or weekly, or follow data warehouse sync. With a capture of system specific data we can build BI reports per system, and aggregate per customer groupings. This would be a win for executive level reporting to show how every month SCCM moves the enterprise to compliant, as compliance percent drops on 2nd Tuesday and move up throughout the month. Detail level data is needed to drive exceptions (read snowflakes) into standard best practices.

call web reporting/deployment report from client or collection by rightclick

Enable option to open report by rightclicking the target machine and viewing deployment webreport

I find this hard to believe that SCCM doesn’t have capability to report which software has been installed by the users themselves using Software Center

Trying to find out this report for specific PC, not for specific application

"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.