dhodgson

Comments

  • Oh I get it! Thank you! If that works, I'll share the script here.
    in Alert Action - Execute An NCM Action - Execute A Script - Shut Interface Comment by dhodgson August 2024
  • main problem is referencing the specific interface. I'm not sure if I have to query that information out of the alert or if there's a variable swinds would recognize. 
    in Alert Action - Execute An NCM Action - Execute A Script - Shut Interface Comment by dhodgson August 2024
  • NEW QUERY: SELECT n.NodeID,n.InterfaceCaption,n.Bps FROM Orion.NPM.Interfaces n WHERE (NodeID = 262 AND InterfaceCaption LIKE 'irb%') This gives me that table but now I'm realizing I don't know how to make it look nice. It seems like this is kind of turning into a diary of me troubleshooting this query so we'll see what I…
    in Monitor Interface activity on a node Comment by dhodgson December 2023
  • After restarting the Server we were able to delete it. @"donrobert5" I will be using the links you sent to make sure this doesn't happen again. Thank you.
    in Deleting SolarWindsOrionLog Comment by dhodgson December 2023
  • This was our first troubleshooting step at the beginning of the week and sadly it did not solve our specific problem. The log file is not so large but the database is taking up all of the server's memory. Currently we have resorted to trying to delete the database to no avail.
    in Deleting SolarWindsOrionLog Comment by dhodgson December 2023
  • We just attempted this and received the following error: -"The transaction log for database 'SolarWindsOrionLog' is full due to 'ACTIVE_TRANSACTION'." We have also attempted the following without success: -Changing SW Orion DB User permissions to Deny for connect -Powered down server then tried to take it offline and…
    in Deleting SolarWindsOrionLog Comment by dhodgson December 2023
  • I see no downside to learning as much as possible about DB management. In the short-term, I really only need base level knowledge to be effective. In the long term, I'd like to achieve the highest level of understanding that I can without neglecting my current career progression. I work in network infrastructure, so I…
    in Learning DB Management Comment by dhodgson December 2023
  • Sadly, I am unable to access the Web Console so cannot use the instructions from the first link. We plan to reconfigure the syslogs and traps once we have completed the upgrade and can access the web console again. We configured the SQL Server accordingly when first setting up the product.
    in Deleting SolarWindsOrionLog Comment by dhodgson November 2023
  • Currently I am only responsible for the SolarWinds database but I see plenty of areas where we would benefit from having a database to improve our current tracking methods. I'm not necessarily looking for a career change, but I am looking to create my "niche" where I can benefit the organization in a way no one else can.…
    in Learning DB Management Comment by dhodgson November 2023
Avatar