So, I have been working on several powershell scripts... Here is what i have. #Author: John Johnson #Last Modified: 3/8/22 #Summary: Set Node Custom Properties in SolarWinds # Be sure to install the SwisPowershell module on Powershell 5 or lower prior to use # Install-Module SwisPowershell #Designate Hostname $server =…
All, I am looking for some SWQL/SQL code that can pull out the following information from the database. Columns include: * Device Name * IP Address * Make * Model * Serial Number * IOS Version * End Of Software Maintenance * End of Life
Dear, A while ago I made a request here to add access points and down nodes into one widget with SWQL. This got fixed but now we also want to apply this to another widget down below: The SWQL querry is as follows for this: SELECT COUNT ([N].NodeID) AS Quanity , [N].Status AS [Node Status] FROM Orion.Nodes AS [N] GROUP BY…
Hello, I have 1 JSON dashboard, how can I add this dashboard to solarwinds? Can someone guide me on this?
Hello, I am trying to convert the following SQL query into SWQL. Any assistance would be appreciated. There should be 4 columns named Last Up, Node Name, Note Date, and Note. It should only show one line for each node with the most recent note. SELECT InterfaceLastChange as [Change Time], REPLACE(NODE.CAPTION, '-F', '') AS…
SELECT COUNT(1) AS KPI_Numbe from Orion.Groups WHERE Status= 2 Hi All, Some ideas needed , the above SQL has been used to created a KPI widget to list DOWN nodes within the full Orion.Groups set. I need too be able to change the SQL to not list KPI data for all GROUPS but for specific only GROUPS . For example based on…
Hi everyone, I came across a problem when trying to install Orion Platform evaluation products. Here are some of the details. --------------- Due to the invalid checksum: 8A06C517E14699C2EF08BECD6D66BFA4690B17949CE20C2379B06A528858D0D0 for file…
We had an issue yesterday with our APE engine that caused it to freeze up and we had to give it a reboot for it to come back. We found out that there were 7 nodes that could not fully contact the APE and these 7 nodes keep reaching out and could not fully connect and it caused the APE to stop functioning. I have both the…
I have a group created to capture all volumes that are in a Critical status due to low free space. For alerting and reporting purposes, I need a SWQL query to show the members of this group.
Hello everyone, I'm trying to use 'Get-SwisData' to generate a list of Nodes through PowerShell. But I'm receiving an error when running 'Get-SwisData' and would appreciate any information on the error and a possible solution. Thank you! $Swis = Connect-Swis -Credential $Cred -Hostname $OrionServerName Get-SwisData $Swis…
It looks like you're new here. Sign in or register to get started.