The most recent content from our members.
Hello Thwack Team, For the below working query - which works in custom swql dashboard resources and in swql studio, SELECT TOP 1 ARRAYVALUEAT(SPLITSTRINGTOARRAY(Replace('Part1-Part2-Part3-Part4','-','|§|§|')),0) as Field1, ARRAYVALUEAT(SPLITSTRINGTOARRAY(Replace('Part1-Part2-Part3-Part4','-','|§|§|')),1) as Field2, CONCAT(…
Dear THWACK members, Please could someone advise what I am missing / where I am incorrect with the SNOW Service Graph Connector configuration page ? attaching the configuration page snip and test connectivity error snip
Hi, I have a requirement to work on, where a user wants to see the list of all the nodes which is grouped by custom properties along with their status. I have below query that shows the count of nodes based on their custom properties and its status: SELECT n.CustomProperties.Comments, COUNT (CASE n.Status WHEN '1' THEN 1…
I need step by step instructions for importing modern dashboards. I have gone through article Import and export modern dashboards (solarwinds.com) already but when I am trying to paste the content inside XML into definition tab and click invoke it is throwing errors. Is anyone else tried importing modern dashboards via…
I have been trying to find a status field for endpoints in UDT. There are OperationalStatus and AdministrativeStatus in the Orion.UDT.MACAddressInfo table, but I can't find any documentation on what those fields mean. The values for OperationalStatus are either -1. 1 or 2. AdministrativeStatus is -1, or 1. Anyone know what…
I am tiring to search for the RawStatus of a Node based on Datetime. This is what I have so far but I cannot figure out how to modify this to search for the date and time. SELECT [Node].NodeID , [Node].CustomPollerStatistics.DateTime , [Node].CustomPollerStatistics.RawStatus FROM Orion.NPM.CustomPollerAssignment AS [Node]…
I am interested in leveraging SWQL and SDK but my knowledge is lacking in these two areas. Any advise about training resources for theses both would be greatly appreciated.
I'm trying to run a morning check to ensure that all SolarWinds and SQL based services are running within the environment. I've got this far with it and it isn't working at the moment; $myServiceArray=@() $myServiceArray="*Solar*","*SQL*" Foreach($Service in $myServiceArray){ Try { $servers = Get-Content…
Hi, all! Welcome back to the continuation of our Primer posts on SWQL and the Orion SDK. In the last post, we established how to create a query, and how to link tables together to get useful information. In this post, we’re going to discuss how to apply these to your Orion Platform products. If you don’t feel entirely…
Hello everybody. Well, on the previously weeks, my team and me have been working with the IPAM and its python-sdk (https://github.com/solarwinds/orionsdk-python). We wrote an python script that will retrieve an free ip address from a SUBNET based on a given NETWORK_DISTRIBUTION. An example for a call the python script is:…
It looks like you're new here. Sign in or register to get started.