Seashore · Solutions Architect · ✭✭✭✭✭

Have you ever seen a .net installation go fast!?!??! ;-) Nice that it all worked out well.

Hi, Update SWQL studio to at least 3.0, then you can play around with Orion.OLM. This simple SWQL query gives you a start: SELECT TOP 1000 L.LogEntryID, N.Caption, L.DateTime, L.Message, L.Uri FROM Orion.OLM.LogEntry AS L INNER JOIN Orion.Nodes AS N ON L.Nodeid=N.Nodeid Where L.DATETIME>ADDHOUR(-24,GETDATE())

How do you want them integrated? What information do you want to pass to the other system and in what direction? If alerts from orion to HPE; I would look at HPE and see how that system can receive information. Sending information FROM orion is not an issue.

Hi I haven't tested this yet but I would try something like this. Create a custom variable and add the SUBSTRING SWQL function, like this: SELECT SUBSTRING(${N=SwisEntity;M=ComponentAlert.WindowsEventMessages} ,0,100) The variable that is added to the alert then looks like this: ${N=SWQL;M=SELECT…

Sorry, I found hardware health about power, fans, temp and disk but no overall or other hardware status. 

Not knowing all about Palo Alto, can it be that all the interfaces and volumes sat on that "slot-3-card"? So when slot 3 died the underlying elements disapeared? Can the volumes and interfaces then had been "unknown"? If so that is something that orion can trigger on. If orion gets an event, llike in your list, you can…

Hi Every 2 min seem to be the default. But you can change that. When the API-poller is assigned to a node, edit the API-poller, press configure in upper right corner. Then you have the option to "use custom polling interval".

Ok, than I am also very interested in what you find out. Will have to do that myself in a couple of weeks :-)

There is a template in SAM called "Microsoft Azure App Service", can that one help?

Can be something in "the middle" of the script that is failing, not showing in GUI. I suggest you enable debugging on the component and look in the debug log. 

I Think you are correct there.If you want icons in reports, or custom tables you can use one of two methods: A complete html tag for the image and enable html code in the cell: Or have a link to the icon and say that the column is an icon:

Many websited don't respont correct if you only use the IP-address, you need to use the FQDN instead. So therfor the variable ${IP} might not work, write the hostname and domaon, FQDN, manually. 

Hmmm, interesting. I haven't tried that one. Not sure how I will use it in reality but it's always good with more tools. Got to test that, thanks!

HI I see that alot on various cisco devices. Several time it's just nothing connected to the interface, or it just alerts anyway. Most times I go into "Manage hardware sensors" under settings, check the sensors affected, choose "edit threshold" and "Force to up". That way it will not alert you but you can see the value.…

Hi No, I think you should on the actual SAM component set "Warning if statistic=2" and "Critical if statistic=3". Then on the alert rule you can say "alert when component status is warning/critical". I always try to just have one (or at least very few) alert rules. Having a single alert rule that triggers if an application…

Hi There is now easy GUI way of doing this. You could PROBABLY do it with a custom script. Depending on how many UnDPs you had assigned a script may take longer to create.

Got the same error at two customers. Did you get any info on how to resolve? "Sequence contains no matching element"

@"stuartd" , I can't explain why you have a SAM/APM view even though you don't have SAM. It's strange. Have you tested SAM before and uninstalled? But it's good you now finds your data.

Same for me, second time I ran the conf wizard it worked.

No, not possible as far as I know. Support is right here.

I guess it might be continuing the upgrade in the background. But as it is upgrading the AWS and you look at that, the web gui will not work. As its the administration services that handle the upgrade they should be able to take care of it. But it scary, like driving with the eyes closed. Look at the log files for…

For me I have locked at what date you did the last install, look at your calendar maybe. Then you might be able to figure out what version was out there then. The other way could be to look at C:\Program data\solarwinds\installer. There you also have old installation files. You migth be able to figure it out there. 

"Unable to start preflight checks" I had that on one installation. Right-clicked the installation and ran as admin. Then it worked.

@"stuartd" hold that Pint, I might have a better solution!!! Couldn't let this go and what better end to a Friday than to create a nice SWQL-query. * Create a new alert rule, a "Custom SWQL Alert" * Choose "Custom Node Poller" as target. * The first part is "read only" and can't be changed, but the rest we can alter. Add…

Thought you might come to that...so I took a look but I did't find any obvious solution. I'm afraid this might need a custom swql to solve. To look at the history and comparing the values. Probably doable but nothing I have in my library.

Got the same error: ALTER TABLE SWITCH statement failed because column 'AvgIOPSTotal' at ordinal 3 in table 'SolarWindsOrion.dbo.VIM_VirtualMachineDisksStatistics_CS_Hourly_stg' has a different name than the column 'MinIOPSTotal' at the same ordinal in table…

Wonderful! That is for Orion, NPM and NCM. SAM is missing (URL's to IBM, Dell and HP for warranty.) Can there be more?

.. and thwack access, warranty info, NCM vulnaribility, upgrades, MIB-db status etc.... I wanted a list of URL's needed: https://thwack.solarwinds.com/t5/NPM-Discussions/List-of-URLs-needed-by-Orion/td-p/612754 as we have lists of ports required etc.

Single server with separate SQL. Only NPM 2020.2.1 HF2. Administration service, yes already restarted that one a few times

Hi The SQL database and the Information service structure is not always the same. So many times they differ alot. So if you are new I recommend you start learning either SQL och SWQL as you will be confused on where to find things. There are advantages with both SQL and SWQL but I think that if you are using it for…