Hello Everyone, We are trying to bring the resources on the node over list resources functions. Here is the functions that we are trying : You can see these functions under the Orion.Nodes table on the SWQL. We are using ScheduleListResources for starting. You are entering the Node id and it's give you a Job id. We can see…
I'm attempting to create some 30 day average widgets in the Modern Dashboard and I'm running into a snag. When attempting to do this with array size data SWQL is converting the calculated values to exponential values. I'm losing some of the value with this format and I'm also not sure how to properly convert it into KB,…
Hello Everyone, I got a requirement to work on AD user details monitoring through SAM. I wrote a script and it is working fine when I am running it on Orion Poller itself locally for a user which is in same domain as my poller server is member of. When I ran the same on a remote server which is not in the same domain then…
I see a table in the Orion SQL Server database called AlertConditionState but nothing resembling that in the SWQL tool. is that table not included in that tool? If it is included, what would be the name in SQWL?
I'm trying to run a SQL query against SolarWinds to obtain a list of BGP neighbors to be used in another report, and need to include the name of the neighbor in the output. I'm trying to accomplish this by joining Orion.Nodes with Orion.Routing.Neighbors, using Orion.Nodes.IPAddress as a common property with…
Hello, Can anyone help me find which entity or which set of entities is holding the content of the "Poling setting" of the webconsole?
Build a Custom HTML page in Javascript. Want to execute an SWIS call to delete a record when a button is clicked on that page. I either need to open a connection to the database from within Javascript, or create a custom widget that can be called from that page with an argument that is the id of the record to delete. How…
I tried reading solarwinds documentation for alerts but I have hard time understanding them, Can anyone explain me alarms structure of alarms (say a device down) and how do I identify a single alarm by it's unique ID, and how do I check if a single alarm is cleared or active using it's unique ID via rest api?
Testing the commands: Invoke-SwisVerb $swis "orion.nodes" "ScheduleListResources" Invoke-SwisVerb $swis "orion.nodes" "ImportListResourcesResult"Really like the idéa and it seem to work under 2020.2.6. But is there a way to filter what is imported? Right now it seem to import everything that is found, also all down…
Hello Orion guru, Is there a way to access UserTabs table in SWQL or it is only possible through SQL? Like I want to use this SQL SELECT TOP (1000) [AccountID] ,[TabID] ,[MenuBarID] ,[TabPosition] FROM[dbo].[UserTabs] Order by [MenuBarID] What will be the equivalent in SWQL?
It looks like you're new here. Sign in or register to get started.