Microsoft

System Center Configuration Manager Feedback

Suggestion box powered by UserVoice

How can we improve Configuration Manager?

Support for custom table synchronization into Data Warehouse

Issue: Support for custom table synchronization into Data Warehouse

Currently, although a method exists to extend tables that can be imported into the Data Warehouse, we learnt recently that this is not supported. We feel this represents a gap with the following impacts:
- Not all tables from the SCCM database are currently synced into the DW. Even a common AI table like Install_Software_Data must be synced via this custom process. This is a table used heavily in AI based software title reporting and therefore a common addition to the DW.
- Custom inventory tables – inventory extension/customization is a common action in many medium-large customer environments, thereby presenting a usability gap with the Data Warehouse
- Long-term Reporting/Warehouse need – customers have been longing for an alternate reporting mechanism in SCCM which other applications can integrate into without impacting Site/Hierarchy operations. Our view is that the DW should facilitate more of these scenarios and not limit them by only allowing a limited subset of data to be imported in.
- Performance impacts to the SCCM DB are avoided if reporting can be shifted to the SCCM Data Warehouse

Our view is that the DW has the potential to solve various reporting challenges with the existing SCCM database and if more investments are made in this role, it will eliminate pain points related to maintenance of custom reporting solutions, promote standardization and eliminate usage of unsupported actions such as database mirroring/log shipping etc.. We would also advocate for a GUI based add-in to allow customers to extend the default tables imported into the SCCM DW.

63 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
stephane shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base