My experience mostly lies with writing SQL queries. I am trying to learn more about translating those to SWQL moving forward. However, this one has me puzzled, I can't seem to get either version to work in a Report and I need some help. The goal of the query is to collect all IPs our Orion environment is aware and display…
Hi, I got some questions about, how we want to exclude the unmanaged nodes being calculated for availability percentage. Kindly need your help. SELECT 100 * SUM (CASE WHEN Status = 1 THEN 1 ELSE 0 END) / COUNT(*) AS Available_Percentage FROM Orion.Nodes n WHERE n.CustomProperties.Region IN ('Central - Network', 'East Coast…
Hi I tried to create an NCM node with Powershell like this (node already exist in the NPM): $ncmNodeID = $swis.invoke('Cirrus.Nodes', 'AddNodeToNCM', 1325) But I got an error: "Cannot find an overload for "invoke" and the argument count: "3"." Can someone help please? is it a right why to create an NCM node? Thanks
Looking how to create a SWQL query for SSL Certs. The device is a NetScaler Ideally I want it to query a specific NetScaler Example ( but i want if for one device ) select n.Caption as [Node] ,n.DetailsURL as [_LinkFor_Node] ,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node] ,cts.value as [Port]…
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
Please convert SQL query into SWQL Select Count(1) From Nodes a Inner Join NodesCustomProperties b on a.NodeID = b.NodeID Where b.Department = 'IT Division DataCenter'
Running queries against table NCM.NodeProperties. In regular Orion the query works fine. Attempting the same query in EOC returns an error: "Subqueries are not supported". No subqueries here. Just a simple SELECT statement against a single table We recently upgraded our Orion and EOC to version 2022.3. Using SWQL Studio…
Hello, My support ticket said API issues are not supported and you have to post on THWACK. When I attempt to use REST API to my SolarWinds Additional Web servers I get an error connecting. When I connect directly to the MPE it works as expected. Are the AWS not a support configuration? Is there something additional that…
I'm trying to programmatically add devices, discover them, and import resources using python. Currently I'm tryin to import resources, I'm using the following: - ScheduleListResources - to do a List Resources on the node - GetScheduledListResourcesStatus - to determine when it's ready to import - ImportListResourcesResult…
Hi Team, We successfully integrated ServiceNow using the Service Graph connector with SolarWinds. We can see the CI's are also populating the respective CMDB class with minimal information. In the SolarWinds fields, a few fields of information are not populating into the ServiceNow CMDB. Issue : Could anyone please tell us…
It looks like you're new here. Sign in or register to get started.