I would like to deactivate NPM devices directly by interfacing with ms sql from my script. which tables need to be updated and how
Doing direct sql edits is not recommended as there tend to be lots of changes that need to happen to multiple tables. Even when the sql edit appears to give the desired results it tends to leave behind inconsistencies in the db that can bite you later.
If you have scripts you should look into having them interact with the api instead, the verbs in there rely on mostly the same mechanisms as making changes in the gui.
GitHub - solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in Powe…
