hallstev5 ✭✭✭✭✭

Service Now has an SolarWinds integration piece that can be used to import data from SolarWinds to Service Now CMDB. We do this where I work. 

I agree with doing a top ## query. But that doesn't work when you need the whole data set. It seems to me that the "paging" the results makes it easier to read and move through the results especially since I personally find it hard sometime to use the scroll bar in the table view.

I know I am able to do this. Ops Bridge and the older HPOM has a scheduler built in, where i don't have to worry about creating the schedule in my code. The agent for Ops Bridge and HPOM handles the scheduling and I can control it from the console. This control is especially nice when i don't have a range of times that I…

Do you know if this is on a road map for a future release?

the query that you have presented above gives the me the active alerts that have been acknowledged. What i need is a way to list all of the times that each alert has triggered in the past month, or given time frame. I am pretty sure i can't get the person who acknowledged the alert but i would assume i can get what…

You will want to create an external node and name it the same as the instance name in RDS. Then you will assign to policy template that you create.

Sure thing. The code used is almost exactly what was in the linked post. Just updated it to use the MultipleStatisticsData table. select c.NODE ,'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(c.NodeID) AS [_LinkFor_NODE] , c.NumericData as CPUUtilization , d.NumericData as FreeStorageSpace , e.NumericData…

Thank you. I used the post KMSigma linked to come up with a very similar solution.

Thanks, this pointed me in the right directions and i figured out what I needed.

Case # - 00796112

I opened a case with Support, but it was a waste of my time. I ended up trying to re-enter the password credential and hit next and it worked.

Yes, i have overcome the problem. The credentials weren't being properly passed so even though the user name and password for my db user was there, i had to re-input in the password for that account.

Does the SDK work within Powershell Jobs or some other mechanism for parallel processing?

@"jblankjblank" @"aLTeReGo" I was under the assumption that when you set the resolution of the RDP session to use full screen that the resolution of the session is whatever the resolution is set on the local monitor that that RDP session is running on. I rdp'd back into my QA application server with a set resolution…

The line that I am getting the exception on is the following: Invoke-SwisVerb -SwisConnection $swis -EntityName Orion.AlertSuppression -Verb SuppressAlerts -Arguments @([string[]] $uri.uri, $startTime, $endtime) -ErrorAction Stop | Out-Null Where $uri.uri is the collection of all of the uris from the nodes generated from…

Yes, in both case i used the stand alone installer for the initial install on my QA application server. I was under the impression it should have upgraded both the primary and additional poller. Found out it didn't do the poller so i just did the stand alone upgrade for the poller.

There are no messages for the volumes being added to another poller. I looked in the events database with the node id and It shows the following events: Node Removed Event 4 Volume Removed Event Interface Removed Event. Node Down Node Up Node Rebooted In another case: 4 Volume Removed Events Node Removed Interface Removed…

Can you tell me if CORE-10460 has been fixed in either of the newer releases of the Orion Platform?

I think so. When I am finished I will post what I came up with.

I don't know if these timeouts are a result of the performance issues. The scripts worked flawlessly for more than 25 days. I asked the gentleman who supported the Orion platform before me and he said that he noticed different timeouts in the log file, some he could track down others he couldn't. Of the 4 scripts that I am…

I have/had a support case for this and I was told to do the follow from this link: Clear the Information Services Subscription - link here -> Success Center I have done this in the past and usually within a day or so, i have subscription errors in my log and the pending notifications table begins to grow.

@"jblankjblank", I'm not sure how the browser would make a difference. This is after i have downloaded the installer and run it locally from my server. This would be contained within installer executable. Here are images of what i am talking about. The Annotation Image: I just clicked inside the installer window. SLW -…

Are production changes in the works to improve performance? Suppressing Alerts would be the way I would want to do my "maintenance mode" for server patching, but 11 minutes for the script to run is a long time, when i can unmanage a set of nodes in less than 10 seconds.

I looked into the audit events for that a particular node that has the event "[VolumeName] on [Entity] has been removed from [Polling Engine]". I see no corresponding audit events. I don't believe that the volumes have been removed, because they are collecting monitoring data and have been without any breaks. I guess I…

Version of Powershell - 5.1 OS - Was 2008 r2 and is now 2012 r2 No, my DB maintenance runs after the suppression script runs I made two changes since my last comments on April 24th. The first change was not piping the full list of Uri's to invoke-swisverb, but using a foreach loop instead. This way if there was an…

I see the following error in the log file for the time that the scripts run: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out What can be some of the…

Based on AppInsight for SQL, these are the top 10 tables based on Size: PendingNotifications196.23 GB1.7 %74.51 MNCM_ConfigParsedArchive9.74 GB0.0 %27.66 KAlertHistory8.02 GB3.9 %4.95 MAPM_HardwareItem_Detail5.96 GB24.3 %49.26 MNCM_ConfigArchive4.17 GB0.0 %28.59 KAPM_ComponentStatus_Detail2.50 GB51.6 %19.14 MEvents2.17…

We are not using HA with this environment. We have 10 APEs and 1 AWE. I guess my next logical question would be, what things should i look for on my primary server, on the APEs and on the AWE that would be "broken". I do know that I have a bunch of dcom errors for cloud nodes that are down that I am attempting to remediate…

Thank you for the response and script. I originally was looking at the LastSystemUpTimePollUtc to get the downtime, but I have all of my ICMP nodes and a couple of SNMP nodes that have NULL in the LastSystemUpTimePollUtc. I am looking into using the Orion.Events table and getting the latest Node Down Event for all of the…

Thank you. That is what I needed. I couldn't figure out the table name.