The most recent content from our members.
Hi all, We have a number of nodes which do not have SNMP enabled and as such have no auto-populated "Location" field. We want to manually enter the location of these nodes. From my research the only way to do this is to edit the orion nodes SQL table. But when I select the column field that I want to edit, the "Enable…
We've installed two instances of SW, one instance in each of our 2 data centers. We are following the Active / Active process within the DB; https://support.solarwinds.com/SuccessCenter/s/article/Orion-Active-Active-solution We have a number of queries in relation to this that during this period of time under maintenance;…
We're in the beginning process of upgrading our Orion DB and our DBA team requested the following: "We are thinking about partitioning data files base on data time, so the historical data can be put in different data file/file groups with the current data. Is there any document I can read for the definition of these data…
Greetings, I would like to know how one would write a script, using Powershell or Javascript, which would compare the string 'down' to the contents of the StatusDescription field in the Orion.NodesData table? This script would be run on a monitoring server and not on the database server.
Greetings Thwack land - I came in this morning to an alert on the server containing my Solarwinds database that the drive was 80% full on Monday. I logged into the server and checked and now we are at 94% full. There seems to be some strange daily database growth that started around 12/22. The database file has been pretty…
I am trying to tables/fields that identify which NodeID is associated with HardwareInfoID in the HWH_HardwareItem table. Any help would be appreciated.
I'm in the process of a drastic overhaul of our Orion Alerts, simplifying them wherever possible. To be thorough and secure that there is no disruption or miscreation of alerts, while making changes and/or removing custom properties within alerts, I am running a query in the db on the Alert Definitions, keywords or fields…
Hi all Am I right in saying that SQL 2016 all service packs and cumulative updates are supported WRT using it for the Database for Orion?
Hello, Thanks for the peek. One of our new security requirements is that all MSSQL instances need to be running in Windows Authentication mode, vs mixed mode...Essentially, managing MSSQL connects via AD instead of SQL users. I recalled that SolarWinds Orion (npm 12.0) used a SQL instance user. Once the instance…
Dear Experts, we are planning to procure Solarwinds solution for our proposed network( NPM,NTA,IPA,NCM), We have a estimate of about 2000 Devices to be on boarded, And so we consider our's as a Large Environment , In detail,for NTA storage, we need 8 GB for every 1000 flow per second , And so we can calculate based on the…
It looks like you're new here. Sign in or register to get started.