Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

UNDP Charts even more limited in 'new style' - got a solution?

Hi,

I was really hoping for 10.4 to solve one of my main caveats with Solarwinds: UnDP graphing. This did not happened, and several feature requests regarding this have been ignored back to 10.X

So I hope the community can help me!

Several interesting mibs for Check Point, Cisco and Juniper returns a table. This could be a table of current utilization of a Cisco ACE server farm, or the connection usage of a Check Point VSX firewall.

Let me illustrate with two graphs displaying the same info: connection usage per Virtual System on a Check Point.

Classic Style	New Style

The two graphs shows the same data. Both graphs have the same limitation. The number of rows graphed are fixed. The New Style is even worse - limiting the display to 10 values.

I cannot even do a 'top 10' to get the most 'interesting' ones.

Can anyone guide me where I can find these fixed vaules? If Solarwinds cannot provide the possibility, I hope to hack the html / database query.

Best regards,

Henrik Noerr

Find more posts tagged with

Accepted answers

Yossarian

Hi Henrik,

what are the limitations you want to overcome?

New charts has the limit lowered to 10 for performance reasons, if you are using IE7/8, having more series can bring you problems. However, if you are using modern browser, performance of charts is better, and the value of '10' is configurable - it can be set for whole web in web.config (see '<add key="MaximalNumberOfSeriesInChart" value="10" />'), and change it to some other limit, or, (which is what I'd recommend, raising this limit only for one chart) - add, to the ResourceProperties table, new property with PropertyName='chartmaxseries' and PropertyValue='30' for given ResourceID (you can get ResourceID from URL, when editing the chart).

HTH,

Vita

All comments

Yossarian

Hi Henrik,

what are the limitations you want to overcome?

HTH,

Vita

henriknoerr

Hi Yossarian,

First of, thank you! - This has immediately helped.

Well the limitation is that I have hundreds of these tables where I want to give a quick overview. Number of rows in the tables are growing, so I would have to manually create new graphs for each 10 new rows.

Not to mention I had to keep an eye on this.

I understand the limit on 10 - but i could not find the lever to change this. I don't see why it shouldn't be an available user setting.

An even better solution would be only to display 'TOP XX'. Currently I show all because I do not know which rows are nearing 'max utilization' and have no possibility to filter out rows with "X < 40"

Unless you have another table setting for this

Best regards,

Henrik

Yossarian

Well, this is probably nothing I can help you with, I pinged the PM for having a look :-)

If you want to see actual utilization, you can create table using Custom Query resource:

add resource on node details (Miscellaneous -> Custom Query), and write following query (in Edit):

SELECT top 10 cps.RowID, cps.RawStatus

FROM Orion.NPM.CustomPollerStatus cps

INNER JOIN Orion.NPM.CustomPollerAssignment cpa ON cpa.CustomPollerAssignmentID=cps.CustomPollerAssignmentID

INNER JOIN Orion.NPM.CustomPollers cp ON cp.CustomPollerID=cp.CustomPollerID WHERE cpa.NodeID='${NodeID}' AND cp.UniqueName='CPConnUsedPercentage'

ORDER BY RawStatus DESC

this, providing I did not made any mistake, should show you table with top 10 RowIDs and Values polled for shown node. Can be useful for some cases. :-)

Regards,

Vita

henriknoerr

Thank you for giving me some hints

What I am displaying in the graph is a transform of a UnDP to a percentage. "How many connections are used out of maximum allowed"

In a overview, the most ideal would be to display, let us say anything above 30%

I know the actual utilization of the firewalls, I have that displayed in a table (60 rows long).

The graph is for helping to give a better overview.

Best regards,

Henrik

michal.hrncirik

Hi Henrik,

so instead more data sources for line chart you would like to have TOP XX resource for UnDP table poller data correct? If so, I'll add +1 for this feature we are currently tracking.

thanks,

Michal

henriknoerr

Hi Michal,

Yeah that would be great.

Also the ability to map the table IDs to other tables, like it is possible in the tabular undp table.

Best regards,

Henrik