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
Can you explain it to me, why do you need a dashboard?