-
Re: 99th percentile Report for Link/CPU/Memory
yaquaholic Apr 11, 2018 7:01 AM (in response to rehan.mudassir@wipro.com)There are a few canned reports already available, for the interface reporting.
Have a look under the Reports section and have a search for reports containing the word 'percentile'.
These reports can easily be copied and modified, to suit your requirements and will give you a good starting point.
And have you tried to create a report for the CPU and Memory?
There are plenty of good references to get you started here: Manage reports in the Orion Web Console - SolarWinds Worldwide, LLC. Help and Support
I am a little unclear on the "script to fetch" bit, are you trying to pull this data via the API?
-
Re: 99th percentile Report for Link/CPU/Memory
rehan.mudassir@wipro.com Apr 11, 2018 8:05 AM (in response to yaquaholic)Hi yaquaholic
thanks for information
Sorry its not script but 'SQL Query' i am referring to
i checked the canned report available in Orion but unfortunately it just keep running for ever and doesn't show any data
and later i copied the SQL Query to Report writer and put where condition (interface caption like 'wan') to fetch precise data but it shows interfaces with 0 value as well
and i believe we don't have canned reports for CPU and Memory for percentile if yes how to find it , if no do u have any Query ?
-
Re: 99th percentile Report for Link/CPU/Memory
yaquaholic Apr 11, 2018 8:38 AM (in response to rehan.mudassir@wipro.com)Yes, the Orion DB doesn't actually store the percentile values, so they are calculated on the fly - hence the long wait.
Instead of viewing the report, copy and edit it and then limit the report to the interface (or interfaces) of interest, this will greatly reduce the amount of work the report is doing at the DB end and speed things up for you.
And you will also get an idea of how they are created.
Though I have learned today, that MS SQL support quite a few percentile calculations,
Let me have a play and I will see if I can get them working against some CPU metrics for you.
Might not get this done today for you though, as I have some of this work stuff to do.
-
Re: 99th percentile Report for Link/CPU/Memory
rehan.mudassir@wipro.com Apr 11, 2018 9:11 AM (in response to yaquaholic)sure i will do that and wait for CPU query
thanks :-)
-
-
Re: 99th percentile Report for Link/CPU/Memory
yaquaholic Apr 11, 2018 8:42 AM (in response to rehan.mudassir@wipro.com)-
Re: 99th percentile Report for Link/CPU/Memory
rehan.mudassir@wipro.com Apr 11, 2018 9:13 AM (in response to yaquaholic)hi yaquaholic
is there anyway that i can export this data of Graph into CSV,Excel
because i need to share the data with Management .
-
Re: 99th percentile Report for Link/CPU/Memory
yaquaholic Apr 11, 2018 9:34 AM (in response to rehan.mudassir@wipro.com)-
Re: 99th percentile Report for Link/CPU/Memory
yaquaholic Apr 11, 2018 9:35 AM (in response to yaquaholic)p.s. It will create a worksheet for each table or graph within the report.
-
-
-
-
-