2 Replies Latest reply on Nov 15, 2011 1:53 PM by Ralphr

    Create DB Procedure to rollup UnDP data

    Ralphr

      Have created a UnDP  that collects ipRouteDestinations on a host.  I need that data to run a report that counts the number of entries that meet a defined filter (ipRouteDestination LIKE 10.10.10.%).  I only care about this count and would love to be able to save the count result to a table and then delete the individual entries.  Any ideas on the best way to go about doing this ?

        • Re: Create DB Procedure to rollup UnDP data
          Nandish

          You can very well create a report using Report Writer showing the desired results using custom SQL query.This should give you the data required.Now you cant write this to the database,instead you can use options like building report.

          Hope this helps.

            • Re: Create DB Procedure to rollup UnDP data
              Ralphr

              I am already doing this.  What I want to avoid is having to save 1000's and 1000's of rows of historical data in a table  (every 10 minutes get all the destinations in the routing  table) when all I need to keep is a single entry (kept historically) for each polling cycle that is a count of those entries based on a pre-defined filter.