I am trying to use the SWQL as my selection method for a custom table. I have been going through documentation and once I came across the 1.9 SDK I have made much more progress. My question is how can I write an SWQL query that gives me all cisco devices? This is quite simple with dynamic query builder, however I then want to be able to filter the data based on work hours (eg. 8-5 Monday-Friday) so the dynamic query builder isn't the solution for me.
For example I can do
FROM Orion.Nodes z
This just gives me captions though of all cisco devices. I want something like SELECT *. Any help is greatly appreciated. Thank you!
You cannot use a wildcard with SWQL queries. You'll need to explicitly request all of your columns by name.
Loop1 Systems: SolarWinds Training and Professional Services