Microsoft

System Center Configuration Manager Feedback

Suggestion box powered by UserVoice

How can we improve Configuration Manager?

Seggregating SQL tables/views for SCCM Application and for Admins

1286 tables and 7153 views, makes it an extensive and difficult job for SCCM Admins to create custom reports, as herculean task for finding where needed info exits, sometime data is available in multiple table/views, makes it tough to decide. Do you think it helps to re/design table or views naming structure in such a way that, set of them are meant for SCCM application for internal purposes which we don’t user for reporting purposes, and a second set of them are meant for SCCM Admin for creating report purposes, making the naming convention and data available in later section more intuitive and easy for admins. You may even keep current tables intact and create few views for admins, from those tables by following different naming convention for these views. Probably this could even reduce the direct load/impact on DB

1 vote
Vote
Sign in
(thinking…)
Password icon
Signed in as (Sign out)
You have left! (?) (thinking…)
Vasu shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
Noted  · 

1 comment

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    may be good idea, but that make it non-compatible with old reports, all of the reports to be rebuild, lot of work for existing SCCM admins to relearn what they had learned for many years. Nevertheless it's good thinking....

Feedback and Knowledge Base