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.
MERIGOT
shared this idea
Admindjam
(Product Director, or Executive, Microsoft Endpoint Configuration Manager)
responded
Tempted to mark this completed, now that we’ve released full blown powerBI integration:
https://powerbi.microsoft.com/en-us/solution-templates/sccm/
Building reports & dashboards doesn’t get much easier than that.
48 comments
-
Jordan Benzing
commented
One challenge with marking this completed is it requires another standalone SQL database in order to run as the data is collected via a PowerShell script that is run via a scheduled task that executes a set of SQL queries.
Currently this additional database is not on the list of supported database for ConfigMgr.
-
Akash Rajgure
commented
Hi,
what makes a good SCCM report ?This is the more important part of your reports. You need to query the right SQL views in the SCCM database. If you’re showing incorrect information, your report will be useless
Building an efficient SQL query is the hard part of report creation. Without any SQL skills, it will be hard to achieve what you want… but, everything can be learned. Two years ago I’ve never done a SCCM report and today we’ve build many and sells them to businesses like yours.
Visually attractive
A report full of data is useful but if it’s presented awfully, you won’t get readers attention
Try to keep it clean : add pie charts and graph if possible. Microsoft proves this with their latest Software Update dashboard and Office 365 dashboard.
The little details :
Try to add links between your report to direct your reader in the right direction
Add tool tips to explain the data. -
Greg Isett
commented
Please, Please, Please do not *require* an Internet connection to run these reports.
-
Archive.org link to the original page: https://web.archive.org/web20171204125448/http://appsource.microsoft.com/en-us/product/web-apps/microsoft-powerbi.pbisolntemplate_sccm?tab=Overview
Github site:
https://microsoft.github.io/BusinessPlatformApps/I hope this helps.
-
ITrooster
commented
As of today 7/24/19 Link is still dead = 404 Not Found
-
Anonymous
commented
Not sure if anyone knows but that link doesn't work... thought you should know @djam
-
Andy D'Hollander commented
PowerBI could be a solution but in my opinion only when licensing for the on-prem Power BI Report Server gets included with the System Center licensing.
That way your reports are on-prem, so a lot of people here that complain that their they don't want their report data in the cloud from a security/privacy perspective will be pleased.
Secondly, it makes no sense to have to pay for additional licensing for another product just to visualize data that is available in SCCM. The current out of box SSRS reports are totally not user friendly, they look prehistoric and are not interactive. So either give us better and modern options in SSRS, or replace SSRS with a Power BI Report Server role in SCCM that is licensed with SCCM.I do actually have a Power BI Licensing item for this separately on uservoice too:
https://configurationmanager.uservoice.com/forums/300492-ideas/suggestions/36675385-make-power-bi-reporting-server-licensing-part-of-s -
Jiri
commented
The link goes to nowhere (404) :-(
-
Greg Isett
commented
Just looking thru and wondering about this. I can't use PowerBI for a solution if it has to connect to Azure.
-
Jade Hearne
commented
What would help is a tool to convert SQL to WQL.
-
Ben S
commented
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
-
Frank
commented
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?
-
Anonymous
commented
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
-
Jim
commented
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!
-
Anonymous
commented
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.
-
AlexM02
commented
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.
