This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Custom Query Macros/Variables available

antonis.athanasiou over 6 years ago

Hi All,

I have been enjoying the Custom Query resource with its native capabilities on filtering (Search box) and enhancements like icons and links ( [_IconFor_Column Name] [_LinkFor_Column Name] for anyone's reference )

It is also very beneficial on detailed views where filters can be applied in the WHERE clause ( WHERE NodeID=${NodeID} )

Recently we tried to build a custom SWQL query resource for one of our VM Details view, however the statement WHERE VirtualMachineID=${VirtualMachineID} just wont work (displays all VMs)

Is there a reference which macros can be parsed in the Custom Query resource ? I searched on GitHub but no luck. hopefully tdanner can assist

Antonis Athanasiou

Prosperon - UK SolarWinds Partners

Installation | Consultancy | Training | Licenses

Top Replies

0 tdanner over 6 years ago

I'm not aware of any reference for these macros. I had to go look at the code for the VM Details view type to see what was available: not much. It looks like you just get NetObjectID and the Caption.
I sent a message to the relevant dev team and will add an update here if they tell me something different.
Cancel
Vote Up +1 Vote Down

Cancel
0 mesverrum over 6 years ago in reply to tdanner

But on the plus side, netobjectid is effectively just as good as virtualmachineid for this use case.
I feel like this kind of request to know what variables each page can output is becoming more and more common as the user base becomes more skilled in building custom SWQL resources. Might be a worthwhile effort to try and compile some kind of documentation on what people can pull from the pages, or at least a methodology for how users can find out themselves without just guessing and checking against all the variables we hope for.
Cancel
Vote Up +2 Vote Down

Cancel
0 antonis.athanasiou over 6 years ago in reply to tdanner

NetObjectID is actually a great asset to work with!
Did you manage to get it working on a custom query? both ${NetObjectID} and ${Caption} are giving me the infamous 'Error: A query to the SolarWinds Information Service failed.'
SWISv3 logs "ErrorMessage = SolarWinds.Data.Query.ParserException: Cannot resolve property NetObjectID"
Cancel
Vote Up 0 Vote Down

Cancel