4 Replies Latest reply on May 17, 2012 4:21 PM by bshopp

    SQL server Data Access to IPMonitor 7.5

    fnia

      We have ipmonitor 7.5 in our company that NOC use to monitor certain devices and they generate a monthly availability report that they export out to Excel and then take the average uptime percentage which they present in a chart. We are trying to export the data out of IPmonitor and into a data warehouse server (SQL Server) for reporting and data analytics. Is there a driver that I could use to connect my SQL server (2008 R2) to the ipmonitor databases/files. They have an ipmdb extension. Any suggestions is greatly appreciated

        • Re: SQL server Data Access to IPMonitor 7.5
          fnia

          I did not hear back from aynyone, either my question did not make any sense or no one knew the answer, either way sorry about the post....

            • Re: SQL server Data Access to IPMonitor 7.5
              DanielleH

              fnia,

               

              I apologize for the lack of responses you've received.  When a thread has been bumped, like you have, I'll always mark for the PM to comment if the community hasn't already chimed in, which is what I'll do for you now.

               

              Thank you for your patience and I will get this over to the PM for comment.

              Danielle

            • Re: SQL server Data Access to IPMonitor 7.5
              Term

              I guess for whatever reason these forums are semi abandoned lately. 

               

              There is no direct exporting of data from ipmonitor.  It's in flat files in a unknown format that is not documented for the public. 

               

              If someone from solarwinds were to stop by and answer your question, they would tell you to look into orion, because that product does support what you want to do. 

               

              Take a look at the reporting functions, as they might be able to help you produce a report that shows what you want, then you could write a program to parse the report and insert the data into your sql server database.