8 Replies Latest reply on Feb 10, 2014 6:46 PM by desire99

I need help on creating a report in solarwinds

desire99 Feb 8, 2014 8:06 PM

Hello Guys,

Can someone help me or send a SQL SCRIPT that will allow me to create the peak utilization interface report for only certain interfaces . I have already done it, but I need to know to filter those interfaces as well as the date as the report need to be for the last 24 hours...

nonpose@ yahoo.com

Thanks

Sam

Re: I need help on creating a report in solarwinds

ryoung Feb 10, 2014 11:08 AM (in response to desire99)

Here is a link that you may find helpful. If it is not, please return and we will get you sorted.

Create Your Own Orion Report Now
Like (0)

Actions
- Re: I need help on creating a report in solarwinds
  
  desire99 Feb 10, 2014 3:02 PM (in response to ryoung)
  
  Thanks. I do know how to create the report. I just need to filter it for peak utilization for certain period of time like last 24 hours. Can you help me on that?
  
  Sent from Yahoo Mail on Android
  
  Like (0)
  
  Actions
Re: I need help on creating a report in solarwinds

rstoney00 Feb 10, 2014 3:14 PM (in response to desire99)

Why not create an interface custom property? Then in your SQL you have already created, just add in Where Your_Custom_Property = '1'
Like (0)

Actions
- Re: I need help on creating a report in solarwinds
  
  desire99 Feb 10, 2014 5:51 PM (in response to rstoney00)
  
  I am new to this. My boss just asks me to pull a report that only looks at a certain interfaces not all maximum utilization or peak utilization last 24 hours.
  I added all my fields just need to know to filter the max or peak utulization . I think it matter of create a function max within the fiter, but I am not too show. Now as far as adding custom property I have not done that. What is 1 represent in that case.
  
  Sent from Yahoo Mail on Android
  
  Like (0)
  
  Actions
- Re: I need help on creating a report in solarwinds
  
  desire99 Feb 10, 2014 6:02 PM (in response to rstoney00)
  
  How do you create custom property
  
  Sent from Yahoo Mail on Android
  
  Like (0)
  
  Actions
- Re: I need help on creating a report in solarwinds
  
  desire99 Feb 10, 2014 6:17 PM (in response to rstoney00)
  
  Do do have any SQL script that pulls max or peak utilization for past 24 hours for certain interfaces?
  
  Sent from Yahoo Mail on Android
  
  Like (0)
  
  Actions
- Re: I need help on creating a report in solarwinds
  
  desire99 Feb 10, 2014 6:20 PM (in response to rstoney00)
  
  How do you create custom property
  
  Sent from Yahoo Mail on Android
  
  Like (0)
  
  Actions
- Re: I need help on creating a report in solarwinds
  
  desire99 Feb 10, 2014 6:46 PM (in response to rstoney00)
  
  I am new to this. My boss just asks me to pull a report that only looks at a certain interfaces not all maximum utilization or peak utilization last 24 hours.
  I added all my fields just need to know to filter the max or peak utulization . I think it matter of create a function max within the fiter, but I am not too show. Now as far as adding custom property I have not done that. What is 1 represent in that case.
  
  Sent from Yahoo Mail on Android
  
  Like (0)
  
  Actions

Go to original post