Author Topic: Software Update Dashboard  (Read 700 times)

Offline sfairchild

  • Newbie
  • *
  • Posts: 1
    • View Profile
Software Update Dashboard
« on: February 03, 2021, 06:21:52 PM »
I have a client running Configuration Manager with Patch My PC integrated. Along with the product came some SSRS reports. When they click on '01 - Software Update Dashboard' SSRS just hangs.

I ran SQL Profiler and found the Required Updates query was never finishing. I can't post the query because it is blocked.

The SQL DBA stated this is a long running query and it should be simplified. Note: I waited 10 minutes and the report still wouldn't load.

In addition, the Start Date defaults to the last day of the month.

Have other clients experienced this issue with this report? Do you have any other dashboards that aren't as complex and load faster?

Thanks,
Scott

Offline Eshfor

  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: Software Update Dashboard
« Reply #1 on: July 26, 2021, 01:28:24 AM »
Can you explain it to me, why do you need a dashboard?