SSRS - Client Health Dashboard

SSRS - Client Health Dashboardnext release will include more efficient code where possible. Next release plans include drill downs for entire client health package, count systems missing 10 or more patches, count top 10 vulnerable systems for patching. count of systems that are p

 
 
 
 
 
5 Star
(4)
661 times
Add to favorites
System Center
7/3/2018
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • Execution Failure on Dataset
    1 Posts | Last post March 22, 2018
    • I'm getting an execution failure on the dataset - TotalClientPushError when running the report and in Report Builder.  However, I can run the query in Management Studio and it works.  Something I need to change?  I switched to my datasource.  I will keep looking in to the dataset and come back with a solution, if I find one before you answer.
  • Clients Active vs Clients Healthy Empty
    3 Posts | Last post March 22, 2018
    • Running 1710 and this graph is showing "No Data Available".  Permission issue or something else?
    • I've tried this report / query logic in a few environments but not on 1710 yet..Looking at the logic on the query I'm not seeing how 1710 should be a problem. At my customers site I should be able to go 1710 in a months time. I'll do more testing to include 1710 before I re-release this with drill downs and additional reports. 
      
      Do you see anything when you run the following sql query on your configmgr database?
      Select * from v_CH_ClientSummaryHistory
      
      The logic for the graph came from this link: https://gregramsey.net/2017/11/20/how-build-client-health-trendline/
      
    • Yes, that view has all sorts of data in it.
      I see the problem though.  Dug into the report, you are hard coding the site code to "MOC" in your query.  Obviously, my site code is not MOC. :)
  • Report is good, but needs some updates to the queries.
    1 Posts | Last post March 21, 2018
    • I like this report, but I modified the queries to get rid of the Access Denied errors.  I now have a working version.  I would be willing to share thee updated rdl file.
  • Query Error
    1 Posts | Last post March 20, 2018
    • Hi, thanks for this report, but unfortunately on SCCM 1710, I have this error : An error has occurred during report processing. (rsProcessingAborted)
      Query execution failed for dataset 'Architecture'. (rsErrorExecutingCommand)
      The SELECT permission was denied on the object 'Computer_System_DATA', database 'CM_PR1', schema 'dbo'. Any help will be appreciate.
  • Account for InTune
    2 Posts | Last post March 20, 2018
    • Pretty good stuff in here.  Should probably do something to account for InTune Hybrids.  For example, "Duplicate System Names", I have a bunch because of iPhones (Dave's iPhone, John's iPhone, etc).
    • I like the way you are thinking, so Intune Reports are coming! Those will be on their own dashboard w/ drill downs. I'm not projecting having those ready for public testing for a few more months. 
      
  • Configuration Manager version?
    1 Posts | Last post March 19, 2018
    • What is the minimum SCCM version for this report? We are running SCCM 2012 R2 SP1 CU4 at the moment and I am having a tuff time editing the datasets, specifically the clients installed in the last 24 hours. It keeps errorsing out on the custom "BUILD01" field.