Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

SQL Report Request - Multiple failures of the same package on the same machine

Evan Sullivan

March 01, 2021 17:02

I would like to have a report that shows if the same package is failing multiple times to be able to correct the issue. I would like it to narrow down to only the last, say, 30 days? PDQ support requested I reach out for help with an SQL report. I am not an SQL guy, at all.

Comments

1 comment

Evan Sullivan

March 02, 2021 13:26

Zach at PDQ was nice enough to provide this to help me. Looks to work great!

SELECT Name, PDQDeployments.ComputerId, PackageName, Status, count(*) c 
from PDQDeployments
JOIN Computers
on Computers.ComputerId = [PDQDeployments].[ComputerId]
WHERE Status = "Failed"
GROUP BY PDQDeployments.ComputerId, PackageName
HAVING c > 1;