UnDP Audit Matrix - SQL Report

Version 1

    I needed a way to visually see where I might be missing certain custom pollers. This query generates columns for each custom poller associated with a specific vendor. You could remove the filters for vendor to get generate a matrix across your entire inventory, however this is a bit cumbersome.

     

    The attached report filters for 'American Power Conversion Corp.', so don't forget to update your vendor variable, @ven.