Actually its the description of the interface, so I want all interfaces that has the word "Satcom" or "Radiolink" and "Seadrill" in it to show on the page.
Above query should list all our Satellite links and Radio links interfaces belonging to company Seadrill automatically to view
Btw. shouldn't you use % instead of character *?
Both * and % works the same, but the % is the correct one for db queries. Examples on the page uses * as wildcard though, not sure why.
We have a lot of sites moving around to different teleports and just by using the correct description on the routers interface page will be updated and no need for manual adding/removing interfaces from view.
You are right, you can use even * character - we replace it for % character. I have just tried that condition and it works fine.
Regarding condition "Alias LIKE '*Satcom*'" - there is no such field like Alias, you should use InterfaceAlias.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.