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

Comments

1 comment

  • 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
    Comment actions Permalink

Please sign in to leave a comment.