bobmarley ✭✭✭✭✭

Here is another way to think about it as you construct your query. The default "SELECT Nodes.Uri, Nodes.DisplayName FROM Orion.Nodes AS Nodes" is pretty much the equivalent of using the select below. I believe all of these fields are available to use with the remainder of your query. Below is an example using the…

Here is a script, slightly modified from the example on Github referenced above that will allow you to pull ICMP nodes in from a file. First make a directory called PowershellScripts on your C drive and copy save the script from there (or change the file path in the script). Next create a CSV file called SimpleAddNodes.csv…

Are the Syslog Alert/Resets you are referencing on a Kiwi or Solarwinds NPM server? If it is NPM are you using the old engine or the new engine?

Below is an example. You can not change the Select statement so that stays as is. "SELECT Nodes.Uri, Nodes.DisplayName FROM Orion.Nodes AS Nodes --this is already filled in on the top of the alert " The Inner Join is connecting the Custom Properties Tables to the Orion.Nodes table The Where Clause is selecting specifically…

Have you tried changing the 'I want to alert on:' field to SQL or SWQL query? You should be able to run your query from that point.

For Cisco ASA I use this. It will return these tables SELECT [data].[OrionNode].[DisplayName] AS [DisplayName],[data].[RemoteAccessSessions].[UserName] AS [UserName],toLocal([data].[RemoteAccessSessions].[ConnectedTime]) AS [ConnectedTime],toLocal([data].[RemoteAccessSessions].[DisconnectedTime]) AS…

Here is one I use on the main dashboard as a Widget. It is similar to the Down Nodes resource but includes a custom Property called Group which in our environment is the owner of the node. You can change the code to match any Custom Property you may have. Add it as a Custom Query Widget. The widget will display down nodes,…

You could simply give them Node Management access on their accounts? That would be the easiest way. If Node Management is too much access you could also consider allowing your NOC to have access to Unmanage or Mute and node under the account settings. That will provide enough access so they can unmanage the node without…

The SDK would be the easiest option. Here is Github repository which has several examples. github.com/.../PowerShell The one specifically for adding nodes is here github.com/.../CRUD.AddNode.ps1 You just need to put the code in to read your IP list from a file.

Excellent example! Used it for joining my World Map tables today to get Node, Custom Properties, and Latitude and Longitude all into one report. Select NodeID, IP_Address, Caption, Latitude, Longitude, CustomProperty1, CustomProperty2, CustomProperty3, CustomProperty4, InstanceID, Status FROM Orion.NodesCustomProperties AS…

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/exporting-data/task/t_ExportDirectlyFromTheURL.html One way is to export it through a URL. This is how I have been grabbing CBDB Data for our Powershell scripts. 

We rarely restarted ours. 

We monitor both the NIC as well as the Switchport, but we don't alert on when a NIC goes up/down. Only if the NIC utilization goes too high for an extended period. There has been a few times when someone decided to copy huge amounts of data from one place to another and filled up a WAN link. The Network Top 10 report will…

If you grab the SWQL code that @sum_giais posted you can easily make it into a widget on a page as long as you are an admin on the system. Click the pencil in the upper left corner In the upper right corner click Add Widgets Type Custom into the search bar and select Custom Query Drag that onto your dashboard Click Done…

I have been using a group that I created called _Email_Nodes in my alerts and it works fine. This is being used for Node Down events. I suspect the issue you are running into is with the variable use for the Custom Properties. Custom Properties can be set up for any of these different entities. The one I listed above is…

What version of SNMP? I have some latency in my network connection between my workstation and the Orion server (work remote). I have noticed when adding SNMP V3 to a node occasionally when I try the 'Test' function I will get either a fail or a timeout but if I try it again it will work on the second try right away. Once…

I tested out the Custom HTML resource and you can pretty much make it look like whatever you want. 

There is a feature request for this Multiple search ability in Manage Nodes - Feature Requests - The Orion Platform - THWACK - SolarWinds Community Depending on your needs you can do this function using SWQL Studio or Powershell

You could create the text with something like Powerpoint then do a screen capture of the text. Save the capture as a .jpg or .png then place it in your web directory and call it from there into a Custom HTML frame.

It sounds as if you would like to allow multiple people to RDP to the server at the same time and launch the console? If that is the case you can increase the number of allowed RDP sessions above the default 2. If you Google Enable Multiple RDP Sessions you can quickly find out how to do it with your operating system. I…

@vinay.by Do you have all of your AP's in Orion or just managing the controllers? 

You are on the right track. We had a similar issue and we set up some custom properties such as Group, Priority, City, Street, Site Name, Email Group, Alert After Hours, etc. These tie into the alert logic as well as pass variables along onto our ticketing system for automation. So far as the alert logic goes you can use…

SELECT TOP 9000 AuditEventID, TimeLoggedUtc, AccountID, ActionTypeID, AuditEventMessage, NetworkNode, NetObjectID, NetObjectType, DetailsUrl, DisplayName, ObservationTimestamp, ObservationRowVersion, ObservationSeverity, ObservationSeverityName, Description, InstanceType, Uri, InstanceSiteId FROM Orion.AuditingEvents Where…

Possibly try what is shown below. It will attempt to log in with whatever credentials your PC is currently using. Replace "YOURORIONSERVER" with your server name Import-Module -Name SwisPowerShell $swis = Connect-Swis -host YOURORIONSERVER -Trusted

@christopher.t.jones123 I tried changing the custom property name to one that exists in my environment and it ran fine. Thanks for posting. 

I usually use the Event Table instead of the Alert Table. EventType 5000 is an Alert and 5001 is the Reset. The Message field contains the event message. That should get you started. SELECT TOP 1000 EventID, EventTime, NetworkNode, NetObjectID, NetObjectValue, EngineID, EventType, Message, Acknowledged, NetObjectType,…

I think you need to join the Custom Properties table in order for that to work. If you can paste the code in as a reply I can give it a try. I do mine in a similar manner using SQL instead of SWQL as shown below - but I'm not joining the CP table in my example INNER JOIN Traps ON Nodes.NodeID = Traps.NodeID INNER JOIN…

I am not familiar with Grafana but a quick Google search states that is has a built in MS Sql Data Source plug in. You should have no issue collecting from the Solarwinds database directly. 

Definitely doable, we use powershell and python for our add/delete scripts. 

If I am understanding your question you just need the 'retired' nodes for custom property name AuditCategoryValue? This may work. Select IP_Address, Caption, NodeID, AuditCategoryValue FROM Orion.NodesCustomProperties cp INNER JOIN Orion.nodes nd on cp.NodeID = nd.NodeID Where AuditCategoryValue Like '%Retired%'