Sweet. Thanks. Patrick Fowler Network Engineer Crocs Inc.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Janice Losgar Sent: Monday, June 29, 2009 2:31 PM To: InterMapper Discussion Subject: Re: [IM-Talk] Average utilization on graphs On 6/29/2009 4:22 PM, Patrick Fowler wrote: > It's there a way of getting an average utilization over a certain amount of > time from the graphs created in InterMapper? I've been asked by my Higher > Up's to provide metrics on a weekly basis. Graphs are cool but they like > numbers. > > Or is there a way to export the data for those link and time periods into > excel? Hi Patrick, You have two options for exporting this data so that you can get an average for utilization over a period of time. One is to export the chart data to a text file, which you could then import into Excel. This is quite simple. Open the Chart Options > Data window, select the variable you wish to export, and click the 'export' button. You can only select one variable at a time to export, so this would be a rather cumbersome process if you wanted to export many variables for many charts. Another option is to export the data to the InterMapper Postgres SQL database, which would then provide you with greater flexibility in reporting on the data via SQL queries. However, until InterMapper Reports is available, you will need external tools to retrieve data from InterMapper Database via SQL. To get you started, we've written several short example reports in Crystal Reports and OpenRPT, as well as several example perl scripts. This tech note provides much more detail as well as links to the sample scripts: http://www.intermapper.com/tech-notes-database-a-datacenter/191-intermapper-database-overview -- Best regards, Janice Losgar Dartware, LLC 603)643-9600 x114 ____________________________________________________________________ List archives: http://www.mail-archive.com/intermapper-talk%40list.dartware.com/ To unsubscribe: send email to: [email protected] ____________________________________________________________________ List archives: http://www.mail-archive.com/intermapper-talk%40list.dartware.com/ To unsubscribe: send email to: [email protected]
