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

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);

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

It would be nice to have a generic subscription for all new active alerts, rather than having to create a subscription to each alert.

I want to be notified of any alert that comes up by email. (Option warning/critical level).

Created(or make this view) a supported version of vSMS_Boundary that can be used with reporting. This will allow admin to local computers not within boundaries and allow for boundary related reporting

Many built-in reports can be filtered by site, but I would like to see them modified so they can be filtered by collection.

A teams integration would be great. Like a simple solution to lookup information in SCCM or a self service solution to add your computer to a Collection. Also just alerting to teams would be Nice. Im sure there are more fun things you could do with this.

We use install and uninstall Collections for Application Deployment over AD-Group (installation) and Softwareinventory (uninstall). When the number of clients in a collection is changing an email notification would be great.

To save companies time when building reports from other environments or being imported, it would be nice to have a CSS theme like template which can be applied to the look and feel of the report.

So this would mean all objects, like pie or bar charts, fonts and frames, tables, text boxes can be changed as soon as you plant a CSS theme configuration setting on it.

We want SCCM to track, on a per individual device basis, which devices connected to CMG and/or CDP and when. We need this data for both reporting on effectiveness/utilization of CMG/CDP and also to help identify which systems are connecting versus which ones we expect to be connecting.

Currently, data is tracked only in quantities, for example, I can see how many systems connected over CMG in the past 30 days and how much data was used, but I cannot see which devices were the ones that connected.

Thank you.

To meet the business needs from our customers and to ease the access we have modified the default folder structure Microsoft uses. When an update is applied the default folder structure is re-created, We have to manually remove the default folder structure after each update. -> the existing folder structure should not be affected by an update

Troubleshooting Hardware inventory has always been a problem. Recently I was make aware of a great table within the SCCM database that can help with troubleshooting. HW inventory issues. However there is no support view to query this great information! Please create a supported view for this table or Enable support for vInventoryLog view so that it can be officially used in reports.

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.

It would be nice to have a reliable way to detect primary screen resolution or primary monitor aspect ratio. This will help management of branded backgrounds and lock screens. Our infrastructure has mixed 4:3 and 16:9 monitors. We don't have a good way to make sure the optimal image is placed in the right spot.

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.