Is it possible to have a page filter for dashboards and reports?

Ravennn · 2022-02-15T21:19:38+00:00

Basically four interface aggregate charts, * interfaces' availability * interfaces' average receive/transmit percent utilization * interfaces' 95th percentile * interfaces' 99th percentile need to be in a page, for interface groups based on location. Kind of similar to the server aggregate charts below. Now these interface…

Ravennn

Basically four interface aggregate charts,

interfaces' availability
interfaces' average receive/transmit percent utilization
interfaces' 95th percentile
interfaces' 99th percentile

need to be in a page, for interface groups based on location. Kind of similar to the server aggregate charts below.

Server Group Charts

Now these interface groups are dynamically created based on custom property Location and there are at least 40 to 50 such locations, hence 40 to 50 interface groups.

Unlike the interface details page and node details page, where the page contents dynamically reflect the current object's values, I understand it is not possible to have a customized Group Details page since the group might contain heterogeneous objects and it is not possible to have a "current object" for a group.

Is there any way to achieve a page filter which allows selection of Group name and possibly a date-time filter that allows selection of timeframe (as it is available in NTA summary page)?

If there isn't a way to dynamically select and populate the contents of the page, I believe the only option would be create multiple separate reports for each location?

It would be interesting to hear thoughts on this.

Thanks!

Find more posts tagged with

filters

aggregate

groups

Accepted answers

All comments

KMSigma.SWI

Honestly this looks like a job for Modern Dashboards to me. Since the back end of Modern Dashboards is based entirely on SWQL, then it should be able to pull the members' of a group (based on a Node Custom Property) and pull in the data sets you want.

To my knowledge, no one has (yet) shared a Modern Dashboard built in this way, but it should be 100% possible. I worked on a similar (Group Membership with availability) request not too long ago, so I'm kind of already halfway there. What's the name of your Node Custom Property and what's are some of the possible values?

You can also pass in parameters to the Modern Dashboards (though I haven't done this part yet), so you could have one dashboard for everything and 'child' dashboards where you just change the URL parameters.

Ravennn

Thanks for the quick response. I did see your report, Group Membership with availability, and I saw a similar solution by @mesverrum where OrionSDK is used to automatically add and remove tabs from a summary view. I am more comfortable with Perl and Python and less of SQL, so I didn't go down this route yet.

In this case, we would actually be using an Interface Custom Property. We could call it City and we could assume the values to be Chicago, Sao Paulo, Cairo, Manila etc.

It would be great if we could "pass in parameters" to the Modern Dashboards as you've mentioned. With one generic dashboard template we could then have the 'child' dashboards display information as expected.