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

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 NetbiosName0 FROM dbo.fnrbacRSystem_Valid(@UserSIDs);

We need to do better at showing the value of ConfigMgr. Most managers (IMO) do not understand the amount of successful (or unsuccessful) change we can do with ConfigMgr. Some high-level dashboard reports would go a long way to help people understand the power of ConfigMgr.

This could be related to another one I submitted (http://configurationmanager.uservoice.com/forums/300492-ideas/suggestions/8922754-help-me-find-objects-that-i-can-remove-from-config), but felt it's different enough to have a separate post.

I want to easily provide information to management on things like this:
- Number of installs, per application (in my experience, this is difficult to get, since an app is re-evaluated every week, by default)
- Number of installs, per package/program
- Number of SW updates installed
- Number of OS Deployments
- Number of Compliance Settings checked, failed, enforced

Basically, anything that can be deployed to clients, it would be nice to get rollup summaries in a dashboard that I can show to management. I would like to be able to select the interval, like 'in the last 7 days', or 'in the last 30 days' for example.

All of this should be filter-able by collection, so that I can see stats based on region, OS, architecture, etc.

Help me easily show the value (and impact) of ConfigMgr.

Since the MAC address isn't added to heartbeat discovery data, it's really hard to go from a MAC address to a device name in the console. This comes up all the time when troubleshooting things like PXE logs. We end up having to use the "Network > MAC - Computers for a specific MAC address" report.

Unfortunately, that report contains a list of every MAC address in your environment. Since MAC's are often only different by a few characters at the end, it is really hard to 1) skim the list and pick what you want, or 2) type in the MAC address to have it find the exact entry.

A quick solution is to include a MAC Address Filter text box that works like the Device Name Filter box on Compliance 5 - Specific Computer.

Please add a MAC Address Filter text box... I'm pretty sure you could get that into 1606 before it ships. :-)

Sending an Operation to a Client results in an operation which is being displayed in the "Monitoring/Overview/Client Operations" window.

I am using this to e.g. send a "Download Defintions" job to a set of clients (e.g. all Clients at risk).

The status of an operations is being updated regularly and the amount of affected clients is being displayed. Also the amount of clients for which the operation "succeeded" and "failed".

Unfortunately further information is missing. I cannot drill down the operation so that the client names are being displayed.
The most important information would be:
- which clients were successful
- which clients failed to run the operation
- which clients are unknown or offline

It would be really great if when configuring a Report Subscription Schedule you could configure it to run based on the number of days / weeks since "patch Tuesday" (especially in countries other than the USA where "patch Tuesday" is actually a Wednesday and not necessarily the second Wednesday of each month).
It takes some time (hours/days) to receive the updates compliance data from all clients after the MS patches release and WSUS sync, so this feature is really important for Path Management Compliance reporting.
I believe there are a lot of ways to customize the reporting process including another tools together with SCCM, however the described feature will make it much easier and elegant.
Besides, the same feature was already realised in ADR schedule options since SCCM CB 1802 (screenshot is attached), so I guess it will not be a big deal to implement it again in Reporting Subscriptions Schedule Options.