Custom Chart in Node Details View of Variable Node

msarkar

Hi

I have few questions about chart display using custompoller data:

1. Is there any option to put the legend in Y axis, while custom poller data is published as chart through UnDp Web Display? I have attached a screenshot1 without legend in Y-Axis and screenshot2 with Y-Axis legend which is built in resource for clarification.

2. However, if i do sql query from custompollerstatistics_detail table, i can plot the data in any way using custom chart resources. But that is node specific and i like to do this as Node Variable i.e. when i use node_details page for a specific node, it only shows the data of that nodes. If there is no data, chart should be in hide mode. Attached screenshot3 using custom chart and screenshot4 using built in resource which has node variable option for clarification.

3. I see the option in SWQL where i can use different type of variable but is there any history table in SWQL like custompollerstatistics_detail in SQL where raw data are preserved for certain time? I only found custompollerstatus table which holds only the current polling data.

*For privacy, some items are marked black.

BR

MSARKAR

attachments.zip

wluther

msarkar​

I think you can do a SWQL query on "Orion.NPM.CustomPollerStatistics", which should have historic data, I believe...

Also, you might be able to use the node ID variable in your queries.

WHERE NodeID=${NodeID}

I'm not 100% it works from a query in a custom object/chart resource, but I know it works for basic query resources, report writer reports, and even the HTML resources.

Thank you,

-Will