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


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

Please sign in to leave a comment.