The most recent content from our members.
Hi all, I would like to create a report that counts the number of active users per office location per month. In the ‘nodes’ table I have custom properties for each node that includes for example ‘Region’ and ‘Location’. Using these custom properties I would like to count the number of active users per month to allow me to…
We ran into an issue we have a fairly new issue. I recently upgraded SW to the newest versions. In doing so, we needed to migrate our SW database from 2012 R2 over to 2016. When we did that and our database doubled. It was around 12 - 13 GB and now its about 25 - 330 GB. IF anyone has any suggestions or reasoning on this…
Hello I set up an alert triggered when specific databases status changes to anything other than online. What we would like is to have it only trigger on the primary HA server. I cannot find a way to tell the alert to not trigger on other node So logic would be If this is primary server and these databases are not online…
After installing AppInsight on our MSSQL instance hosting Solarwinds, I noticed that one of weekly database maintenance jobs was failing. I checked the logs and saw the following error: Failed:(-1073548784) Executing the query "ALTER INDEX [I_OrionServers_ServerType_HostName_in..." failed with the following error: "The…
Hi Guys, We currently have a report which finds all nodes not responding on SNMP which is created using SQL. SELECT *, '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:'+CAST(N.NodeID as nvarchar(256)) AS DetailsURL ,N.StatusLED AS Status_Icon FROM NODES AS N WHERE ObjectSubType<>'ICMP' AND N.SysName NOT LIKE '%-LK%' AND…
Hi, we are trying to collect device info (IP, MAC, HOSTNAME) from Solarwinds, with DB Connect add-on for Splunk. I managed to connect to the database and looking at the schemas/tables, I am unable to find anything that related to devices reporting to Solarwinds. I'm new to the Solarwinds product so I have very little…
Heya folks, I am working on a SQL database migration and wanted to clean up the accounts allowed access before I move it over. Would anyone happen to have a listen of all accounts that are necessary for the SQL server to function?
It looks like you're new here. Sign in or register to get started.