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

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.



1 comment
Date Votes
  • 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;