• Welcome to Support Forum: Get Support for Patch My PC Products and Services.
 

Software Update Dashboard

Started by Scott Fairchild, February 03, 2021, 06:21:52 PM

Previous topic - Next topic

Scott Fairchild

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

Eshfor

Can you explain it to me, why do you need a dashboard?