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…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Vasu shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
Noted  · 

2 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base