SCCM Report - Easy way to create Report & Dashboard
Not really easy to create some SCCM report or Dashboard if your're not a SQL DBA .. even with Report Builder.
Could be awesome to have a new tool where Reports or Dashbaord could be created easily whithout searching which SQL views I need ..ect ... Like some others concurrent application give.
Tempted to mark this completed, now that we’ve released full blown powerBI integration:
Building reports & dashboards doesn’t get much easier than that.
I tend to agree that PowerBI isnt quite the valid solution. Have done a fair bit with SCCM reports using SSRS and dabbled briefly in PowerBI. As great as the current templates look, there are two showstoppers for us.
Firstly, needing a seperate SQL DB to use the reports means more overhead for our SQL support and currently makes it a bit hard for us to setup.
Would be great if reports were made just to read the DB rather than create seperate structure (have tested a few custom dashboards myself and this is viable but needs a lot of tweaking. Would be great to have some good templates to work off without the full DB requirement)
Secondly, the fact that powerbi requires full pro license subscription for each user accessing the published report is a bit over the top and also not viable for us currently (Yes individuals can export the report file and upload to their own workspace, but its hardly viable in a corporate environment).
Popovici Ioan commented
PowerBI might be the sollution but it’s not for everyone.
I would rather prefer docummented views and functions.
You guys have a pretty comprehensive reporting pack with sql functions that I never heard of but it’s for Microsoft Premier Support Engineers only.
I’ve only seen it once when a MSPSE came on site.
It would be nice to document all those functions and tables.
@Frank thank you for reporting this. We are working on it. For now you can download from here: https://bpsolutiontemplates.com/?name=Microsoft-SCCMTemplate
Link https://powerbi.microsoft.com/en-us/solution-templates/sccm/ no longer works. It's redirected to https://appsource.microsoft.com/product/web-apps/microsoft-powerbi.pbisolntemplate_sccm?tab=Overview where I receive a 404.
Emil Skibsted commented
Is it possible to include Primary User as a search field in the template somehow?
Does powerbi support a way of using RBAC and SQL functions to filter data users can see based on scopes?
Sean Pierce commented
Shouldn't have to lower security settings to use
Do the right thing MS, do try to force to buy cloud services for reporting on a tool that we already purchased. This is a joke! Get it together Microsoft!
If PowerBI is the solution then I'll quit administrating your product and move on. The current SCCM DB is a joke. PowerBI is a joke.
Creating Custom Queries is intuitive, is based on SCCM inventory (and other) information and can be displayed as WQL Queries. Converting WQL Queries to SCCM Custom Reports is the best way forward, as it would not require a detailed understanding of SCCM's SQL Schema, tables, and views in the way Report Builder does - something that is complex, poorly documented, and time-consuming. PowerBI does not seek to address the industry's main requirement of making user customised (formatted) reports easily accessible. It seeks to provides additional solutions, brings in an additional Azure requirement, and is over-engineered. While it is acknowledged that Query Results can be copied into Excel, a query to report conversion will satisfy 95% of the customised report requirements that I have worked on over the years, across dozens of SCCM customer projects of all sizes.
PowerBI cant be the solution. Our customers need a solution that makes creating reports easier. Working with the current DB structure is an impossible task for many since its so complex and undocumented. Just pointing to a different visualisation tool will not help anyone ....
not even talking about the cloud only aspect which many customers will not tolerate.
Roy Padrick commented
This could not be further from a real answer. Telling people "there's a third party app" for basic functionality is not a real solution to tell people.
How about a full refresh of the SSRS reports with updated graphics so they don't look so 90s? And the ability to tie into PowerBI (free or paid for auto updating options) for customers that want to explore that avenue?
This is a joke right? PoweBI? Get over yourselves.
Michael Schultz commented
need an on-perm solution
Would be nice to see some integration with the PowerBI SSRS when it makes RTM.
Iain Fairbairn commented
PowerBI is NOT the solution. you can't just assume all organisations will use a cloud based reporting solution for their on premises enterprise management systems, additional licensing or cloud data charges alone will basically blow it out of consideration, not to mention privacy concerns. But the real issue is that in the mean-time if the MS response is "use PowerBI" then that means they have no incentive to enhance one of the fundamental features of SCCM, that frankly is given inadequate development already. SSRS is okay, but it has a steep learning curve and arguably is harder to use in some ways than classic SCCM 2007 reporting. So while it is more capable if you really know what you are doing with the SQL schema and reportbuilder (arguably one of the least user friendly design tools I have ever encountered). SQL management studio create views functionality shows some good capability with graphically allowing you to join tables\views and have it then generate the SQL code for you. something like that perhaps simplified would be a great addition to an on-premises reporting tool either built into the SCCM console or (more likely) as a companion tool launched from the console.
Jason Kellar commented
Regarding your reply with Microsoft Power Bi. Where can i get information about what data is transferred to the USA and if there is data transferred to the USA is their a version for Canada? i work at a university and our privacy laws are very strict about what can be sent and stored in the USA.
Qasim Mashwani commented
@djam While creating reports via PowerBI is very easy many SCCM users may not be licensed for it and the feature requests states integration of features into SCCM.
Dustin Adam commented
we've implemented the PowerBI Report Pack, and while it's great, it feels... unfinished. there are a number of tables that don't have active cardinal relationships. hopefully there will be an update to the report pack, or at least the sql scripts that extract data to the report pack sql database.