Microsoft

System Center Configuration Manager Feedback

Suggestion box powered by UserVoice

Anonymous

My feedback

  1. 862 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    43 comments  ·  Ideas » Reporting  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous commented  · 

    PowerBI is a significant improvement to SSRS and report builder but unless you are creating basic reports with a 1:1 relationship of data to a chart, PowerBI doesn't make creating reports easier as the core issue is knowing the db schema and how to map data together.

    As of now you need to have a skillset in SCCM, Structured Query Language (you don't need to be a dba just know joins and some aggregate functions at minimum), and a skillset in a reporting platform\tools (SSRS).

    We need an offline method (No internet connection, no subscription) for reports and at least and at lease updated documentation on the db schema. Ideally an easy way for admins to map views without being a SQL expert.

    Until the entire reporting platform can be revamped, an idea that can help (not solve) the issue is create a converter of the SCCM queries (WQL) to SQL and maybe even a button that says “Create report” that’ll do it for you.

    Anonymous supported this idea  · 

Feedback and Knowledge Base