The most recent content from our members.
Hello solarwinds community, we use orion for our company, and we noticed a big problem of space consumption of the orion database lately. on the log table, we have this line : [dbo].[OrionLog_LogEntryFieldValue] of the size of more than 140.000.000KB so is more than 140 GB, which is huge. we do not know what this table…
Hello, if we create UnDP, is that will make a new table in Database Manager, I want to create custom SWQL query to read the UnDP. thank you
Hello everyone, I am an intern helping my network engineering team to automate things in SolarWinds using Python scripts. My last project concerns extracting/updating information for every subnet. We use different servers for testing and production. I created a script extracting information from the database using the…
I am trying to use the following SQL query to pull the date of the most recent archived running config and last time NCM successfully downloaded a running config: SELECT [dbo].[NodesData].NodeID, [dbo].[NodesData].IP_Address, [dbo].[NodesData].Caption, [dbo].[NodesData].UnManaged, [dbo].[NCM_ConfigArchive].DownloadTime,…
Hi All, I'm trying to become a "power" user, and do a fancy SQL query, but it's not working for me. I can't find a discussion about doing a basic join. In English pseudocode, I'm trying to: select IfName as Interface from Interfaces select IPAddress as 'IP Address' from NodeIPAddresses where the InterfaceIndex.Interfaces =…
It looks like you're new here. Sign in or register to get started.