1. Support
  2. Community
  3. Collection and Report Sharing Center - PDQ Inventory

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

Avatar
Evan Sullivan

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.

0

Comments

1 comment
Date Votes
  • Avatar
    Evan Sullivan

    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;
    1

Please sign in to leave a comment.

Didn't find what you were looking for?

New post