The most recent content from our members.
Hello everyone, I need an urgent help! I was trying to replace the SA user of SolarWinds Database with another user (account was created with SolarWinds recommended permission). Started the configuration wizard and selected change only database connection. In every step SA user and pass was removed and new user and pass…
My windows server admin account was used to sign in to NPM MSSQL database (windows authentication). That account got deleted and now neither the system nor I can login to the database. Is there a way that my server's new admin account is authorised to sign in to the MSSQL db. I can't configure the npm web server or…
What are the minimum permissions required for a MSSQL read-only user to build dashboards on Grafana? Grafana has a MSSQL module where you can do normal SQL queries, but I don't want give access to passwords, ssh keys etc...
I have customers that come to me with reports with information from our SW database from years past asking for the SQL Query. The Reports they have were made through the Web Console. I know how to find the table name and column when I have something to go off of, but what if I dont know what table or column the information…
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.
I have a MSSQL with several DB's and I want to get logspace info (DBCC SQLPERF(logspace)) about each of these DB's. How can I do this if I don't know how many DB's are on this MSSQL server?
I have made a alert that trigger when a BGP Routing Neighbors is going down. I will then have an email from which node and to which node the BGP routing neighbor went down example: --------------- Subject: BGP routing Neighbors is down from NODE1 to NODE2 An issue on an object you are monitoring occurred at Never. View…
Hi, before I describe my problem, this is my environment: * 1 VM that runs SQL Server 2008R2 (from which I need to collect log) * 1 VM that runs Solarwinds LEM Manager appliance * 1 VM that runs SQL Profiler, LEM Agent and MSSQL Auditor (that have to collect data from the VM that run SQL Server described above) From the…
Is there a way to setup each monitored DB on it's own repository DB, but on the same DPA server? (Without resorting to installing multiple instances of the DPA server) I have it setup on MSSQL. Thanks in advance, Shay.
Usage of sys.sysprocesses view is depreciated due to sys.sysprocesses (Transact-SQL) | Microsoft Docs and cause some efficiency problems due to experience of my colleagues. Please make DPA using more up to date methods for MSSQL version > 2000.
It looks like you're new here. Sign in or register to get started.