LadaVarga

Hello, In SWQL can be written like this: SELECT Nodes.LastSync, Nodes.IP, Nodes.Status, Nodes.ObjectSubType, Nodes.DNS, Nodes.Caption, Nodes.SysName, Nodes.LastBoot, Nodes.MachineType, Nodes.NodeDescription, Nodes.IOSImage, Nodes.IOSVersion, HardwareInfo.Manufacturer, HardwareInfo.Model, HardwareInfo.ServiceTag, CPULoad as…

Hello, For now you can try this The secret lives of web-based reports

This maybe easier your life: The secret lives of web-based reports

Desktop Notification Tool

NPM 10.7 Beta 1 Available

Hello, It looks like reset condition is wrong. It will be reseting after 1Min and trigger again if active node is the same one. (It maintains DNS in good shape every minute) 1. I recommend Copy that DNS alert. 2. Go to reset condition and change from "Reset this alert automatically after" -> Reset this alert when trigger…

Hello all, Good News: From NPM 12 you are able to integrate with ServiceNow. https://store.servicenow.com/$appstore.do#!/store/application/28d51d460f129a006d9cb17ce1050e6c/1.0.0?referer=$appstore.d… and Network Monitoring Software | SolarWinds NPM 12 Lada

Hello, Be aware 11.5.2 breaks the Filter SQL Node feature so you will need to rewrite your Report Writers if you used Filter SQL What do you mean by that? Do you mean Filter SQL in "Editing Report from from Orion report writer"? It is working for me. Only problem is with "NODEID" column it can be fixed by change it to…

Hello, It will trigger when any of poll member which is in Active poll will become "Mainpoller". Node1 = MainPoller (alert triggered) Node2 = MainPollerStandby after failover Node1 = MainPollerStandby (alert reset) Node2 = MainPoller (Alert triggered) Unfonantely we don't have such as "failover event occurred" or other…

Hello, Before fix you can use SQL variable workaround: VolumePercentUsed: ${SQL: SELECT round(VolumePercentUsed,2) FROM [dbo].[Volumes] where volumeid=${VolumeId}}% VolumePercentAvailable: ${SQL: Select round(100.00-VolumePercentUsed,2) from [dbo].[Volumes] where volumeid=${VolumeId}}% This is if you create alert up to…

That is good. use ${toTime} or ${toTimeUTC} instead ${untilTime} . We will update in help.

I've gotten this to work -> what that mean? It that mean datasource work or you see some data in chart? Most important thing after you add this datetime macro is prolong time period -> look on image.

Hello, In my enviroment is working great. Could you please check if you have set same as me: This is working great. Another possible workaround can be: Create another Email action and put the second query there. LAda

Hello, In NPM 11.5.2 we introduced: SELECT TOP 1000 [AlertHistoryID] ,[AlertID] ,[TimeStamp] ,[EventTypeWord] ,[Name] ,[ObjectType] ,[AlertEnabled] ,[Frequency] ,[Message] ,[AccountID] ,[AlertActiveID] ,[AlertObjectID] ,[ActionID] ,[ActionTypeID] ,[Title] ,[RealEntityType] ,[TriggeredCount] ,[EntityNetObjectId]…

SELECT Nodes.NodeID AS NodeID, Interfaces.InterfaceID AS InterfaceID, Nodes.Caption AS NodeName, Nodes.Location AS Location, Interfaces.Caption AS InterfaceName, AVG (InterfaceTraffic_Detail.In_Averagebps) AS Average_Receive_bps, MAX(InterfaceTraffic_Detail.In_Maxbps) AS MAX_Receive_bps, AVG(Case InBandwidth When 0 Then 0…

Hello, You can see timecolumn picker only if you use minimum one timemacro that means: ${fromtime} ${totime} ${fromtimeUTC} or ${totimeUTC} can be commented of course. Example: select * from cpuload where datetime > ${FromTime} Unfortunately it is not working in NetObject detail page (node detail, interface detail...…

Hello could you please add clrf characters to string: <span class="str" style="color:#800000;">'This is line 1.'</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> CHAR</span><span class="pun">(</span><span class="lit" style="color:#800000;">13</span><span class="pun">)+</span><span…

Hello, It looks like more "ticketemail" has some wrong format character in email address and SMTP server return the error. What do you have in that ticketEmail for that particular application. If you use only one "to:" Is that working? Lada

Sorry you are right. From 10.4 user can set to 32767 minutes that means 22.75 days.

I looked on that csv and import to DB and it is working perfectly with little change. Please add to where condition datetime condition 1. AND datetime > ${fromtime} 2. Edit chart, add dataseries, pick time column and objectid 3. Submit and next to datasource you should see From: Past hour 4. Change for what do you want for…

Hello, What are you missing in AlertHistory table? If you need time which show you how lond is alert triggerd there is macro for that: ${N=Alerting;M=DownTime} Lada

Hello Graphs are part of new web based reporting in NPM 10.6. You can look here for quick review: How to use the SolarWinds Orion Report Writer - YouTube

Hello, Cahunt is right, you can use Orion SDK and create script which export all alerts via "Orion.AlertConfigurations.Export" VERB. Lada

Hello, I recommended upgrade to 11.5.2 In 11.5.2 we introduce: SELECT TOP 1000 [AlertHistoryID] ,[AlertID] ,[TimeStamp] ,[EventTypeWord] ,[Name] ,[ObjectType] ,[AlertEnabled] ,[Frequency] ,[Message] ,[AccountID] ,[AlertActiveID] ,[AlertObjectID] ,[ActionID] ,[ActionTypeID] ,[Title] ,[RealEntityType] ,[TriggeredCount]…

Hello, You can, but we don't know what happened if we will update Solarwinds app in ServiceNow and this scenario is unsupported. I highly recommend to create business rule which will tranform what ever you want right after incident creation. It will be isolated and if we update something you disable it or modify. LAda

Hello, 1. You cannot combine SQL macro with SWIS variable 2. () or in is forbidden in to/cc/bcc 3. You should use ' ' instead of "" Please try this: ${SQL:select ticketemail from APM_Applicationcustomproperties WHERE Dept = 'RHPSAS' and ApplicationID=${ApplicationID}} ${SQL:select ticketemail from…

what does this line refer to: Everything what is happening in the system it fires event. You can filter it on Event page (remove changeIP eventype) It refers your message in this thread from: pratikmehta003 May 1, 2018 12:56 PM (in response to tmeyers)

It is possible to prolong Topology polling interval to 32767 minutes that means 22.75 days.

Hello, You should try "Add variable" and try search URL. For example for hardware sensor I got: ${N=SwisEntity;M=HardwareCategoryStatus.Node.DetailsUrl} ${N=SwisEntity;M=HardwareInfo.Node.DetailsUrl} Lada

You should see same things as in reporting. If not please wait some minutes and try it again. In first load it takes some time. In custom chart u need to define datasource and after that you can define data series. You should see something like this: Custom chart: