How can i build widget that the user insert ip address and the result will be to which group belong ? Can i do it with wsql ?

avivi

Thanks

Find more posts tagged with

Accepted answers

All comments

avivi

I mean to which group the ip of the switch that the user insert is belong ( i have 10 name of groups)

avivi

For group i mean

A group is a collection of monitored objects, such as a group of nodes from the same location, or group of all nodes owned by a department.

mesverrum

Don't have a live environment to flesh out this query but from memory the swql will be roughly like this for the custom query widget.

Select c.name

From orion.containers c

Join orion.containermembersnapshots cs on cs.containerid = c.containerid

Join orion.nodes n on n.nodeid = cs.objectid

Join orion.ipaddresses ip on ip.nodeid = n.nodeid

Where ip.ipaddress = '${SEARCH_STRING}'

avivi

My first problem is that i cant build input with custom html widget, its not allow me to insert string

mesverrum

Correct. the custom html widget doesn't normally support that kind of thing (except when you DIY it in javascript). That's why i suggested to use the custom query widget.