marlief22 · SolarWinds Specialist · ✭✭✭✭✭

Hi there, Thanks for the tag @"stuartdc" - first off, the old query has to be ran on a group details page which is probably why you didn't get anything displayed before. Second off, here is a quick change around to make this work for nodes and then for the caption and last boot time: select n.caption as [Node], n.LastBoot…

Right okay, that makes more sense. Usually the only difference between the online and offline installer are that the offline also has a large folder with all the MSI files in which it uses as a source instead of some internet directory. When you are pressing "Download updates for pre-staging" you are probably…

Hey there, Unlike the online installer, the offline installer only contains a single version of SolarWinds. Since it will always default to the newest (In this case 2023.1) could you confirm that you selected the right version from the drop-down menu when you downloaded? 

It looks like you haven't installed the PowerOrion PowerShell module. Both 'Connect-SWIS' and 'Get-SwisData' are part of that. PowerOrion A Module for PowerShell · solarwinds/OrionSDK Wiki · GitHub

Hey, thanks for chipping in - Just knowing that it's not just me is good. I can go down the route of SQL if it's really needed. 

Hi there, Without a screenshot it's hard to know exactly what the problem is, however you may be getting confused (understandably) between the relative time values and what they represent. Compare for example, 'Last Week' and 'Last 7 days': 'Last Week': As I write this it is currently October 3, 2022 which is the first day…

Okay, I guess my next question is does the warning and critical alert need to be active at the same time? The workflow could be this: 1. Disk goes >80% 2. P3 alert triggers 3. P3 trigger action creates SNow ticket with eventID "XYZ" 4. Disk goes >90% 5. P2 Alert triggers 6. P2 trigger action resets P3 Alert 7. P2 trigger…

Just to add to this, following your population of flows, you will want to categorise each site into an 'IP Group', allowing you to then filter and view traffic between particular sites: IP address groups in SolarWinds NTA

Hey there, Based on your description, would this work: P3 Trigger: P2 Trigger: P2 & P3 Reset: In this configuration, the alerts will only clear once the Critical AND Warning values are no longer met. It also allows you to set individual thresholds for each volume (Allows better scaling later on) Let me know how you think…

Hi there, You are correct in your assumptions that you are looking at different database tables (Although technically it's API namespaces being mirrored into DB tables) - using SWQL Studio I can show you: The table you are looking at is the following: You see how the primary key is HardwareItemID - this means that it's a…

[deleted]

Hello there, You should be able to achieve this using a custom table or chart with a datasource like this: The above example shows traffic between our SCCM server and a particular device on the network. Let me know if you have any questions. Kind regards, Marlie. If this helps you please mark my response as the answer to…

Hi there, My recommendation would be to use a custom poller on the table row instead of the table itself. You can do this by taking the OID value of the table and appending .1, .2, .3 etc. for the row you want to pull the information from. This would then allow you to check each of the values individually rather than the…

Hi Girban, the best thing you could do is use the 'Time of Day' tab to schedule the alert to only be enabled for maybe an hour every month like in the example below:

Hi there, You would need to do a custom query alert, something like the following (Apologies, cannot test right now): Select node.nodeid, node.uri from orion.nodes having count(nodes.interfaces.interfaceid) >= 50 Let me know how you get on, Marlie

Hi there, I don't believe this should intrinsically be a problem, could you explain exactly what issues you are seeing when you try to monitor a device with this configuration? Kind regards, Marlie

I think a lot of the changes that SolarWinds have brought in over the years are all really good in a vacuum, but seem to fall down based on the same principle of 'change is scary'. A great example of this is the SAM node based license change from component based a couple of years ago. Customers were essentially only using…

Hello there, I have made a quick mock-up of this report for you, hopefully it hits your requirements okay? You can import the attached .XML into your reports section. [View:/cfs-file/__key/communityserver-discussions-components-files/19/All_2B00_VM_2B00_Volumes.xml:640:480] Kind regards, Marlie Fancourt | SolarWinds…

Hello there, In order to understand more about what has happened to give you the 'Connection Refused' error, we would need to see the detailed job log. Please follow these instructions to generate a 'Session Trace' for these…

Hello there, First of all, I generally don't recommend ANY manual manipulation of the DB unless absolutely necessary, and with a full back-up first done. Secondly, if these accounts aren't causing issues then it's best to not disturb them. Finally, before we can offer any advice we'd need to know specifically what table…

Hi there, I'm not sure where you have gotten this OID from, but it seems to me like a very specific sort of disk usage for a specific PA feature that you may not have on your devices "Log Collector". The error you are getting simply indicates that the device you are testing isn't putting out that OID from the device,…

Hi there, The best option would be to go to Settings > All Settings > Manage Custom Properties. Following this, you can select the custom property in the list, press 'Assign Values', then you can go through and bulk update the values on the nodes here Hope that helps! Kind regards, Marlie Fancourt | SolarWinds Pre-Sales…

Hi there, The best option you would have is to create these accounts and assign them limitations using the Orion SDK. Something like this PowerShell below will create an account with minimum rights called 'test' with password 'test', then assign it an Account Limitation that limits it to nodes whose caption contains the…

Hi Sunvad, you're absolutely right - I've edited my above comment. That shows me for typing out SQL from the top of my head without testing it first!

Great point! This is very similar to the issue about alerts not clearing when something is set as unmanaged. Since the status never went back to 'UP' it just stays there. @"zennifer" You could also try just simply remove these instances of the alert from the Active Alerts page, if they come back then you'll know something…

Hi there, Do you get the same result with the different get types? GET, GET NEXT etc.? These results aren't HEX or any system of data that I recognize. Could you use the MIB browser in the web console to confirm if that results come through…

Hey there, You can try adding the following to the end: and CPU.Timestamp > DATEADD(hour, -24, GETDATE()) This will only take rows that have a timestamp greater than todays date and time, minus 24 hours. That being said, I can see that you are mixing and matching your data resolution in your query: CPU is 'daily' and the…

Hey there, You'll want to put this directly into a 'Custom Query' Widget, it'll do everything for you: https://support.solarwinds.com/SuccessCenter/s/article/Use-Custom-Query-to-show-Node-Name-and-IP-Address?language=en_US In this link above it shows the process of creating a custom query widget, just replace the example…

Hi there, Here are the scripts I'm using (Data removed for security): HA Status Get-Module SSHSessions New-SshSession -ComputerName $IPAddress -Credential (Get-Credential $null) $result = Invoke-SshCommand -ComputerName $IPAddress -Command 'get sys ha status' -Quiet $text = $result.result $regex = '(HA Health Status: OK)'…

Hi Nazhif, Let me paste the full thing for you: SELECT TOP 10 e.Caption as Node, n.Caption as Volume, concat(round(n.VolumeSize/1024/1024/1024,2), ' GB') AS [Capacity] , n.VolumePercentAvailable , n.VolumePercentUsed FROM Orion.Volumes n, Orion.Nodes e where e.NodeID=n.NodeID and n.VolumeType='Fixed Disk'Can you let me…