LadaVarga

Hello again, There is no easy way how to do that. Probably you want something like this: Am I right? Use this SQL query as datasource: SELECT et.Name AS EventTypeName, DD.Date, SUM (CASE WHEN Mult = 0 THEN -1 ELSE 1 END) AS count FROM Events e JOIN EventTypes et ON e.EventType = et.EventType -- ${ToTime} - bug has to be…

Hello, Could you please post the ticket number here, we will have a look on that. Thanks Lada

Hello, For chart we need minimum 2 points to show. there is workaround add another point. There is example for cpuload: Datasource: select top 1 datetime,avgload,minload,maxload from cpuload where datetime < ${totime} union all select top 1 dateadd(day,1,datetime),avgload, minload,maxload from cpuload where datetime <…

In NPM 11.5, this can be done with a bulk edit of alert actions in the "Manage Alerts" grid. "Action manager" tab is next to "Alert manager" tab.

Hello, It will never delete data from alerthistory if the record from Alerthistory has counterpart in ActiveAlert tables. . That means if you have many active alerts, records from Alerthistory table will be protected. You should have look to swdebugmaintenance.log and check 2016-09-21 02:15:05,329 [1] INFO…

Hello, I answered similar question before: Look at here: Re: Need a report of non-responding IPs during Discovery

SELECT top 50 tolocal(EventTime) as eventtimee,'/NetPerfMon/images/Event-' + TOSTRING(EventType) + '.gif' AS [_IconFor_Message] , Message FROM Orion.Events where NetworkNode=${nodeid} Order by Eventtime desc It limit to 50. Color isn't available in this resource. If you have NPM 10.7 you can use Custom table. 1. Add custom…

Hello, Hasty001 tells true.

Hello, Are you insert to node detail page? Do you have interfaces managed by NPM or NOT? If not you can slight modify it: SELECT ip.IPAddressType, ip.IPAddress, ip.InterfaceIndex, i.caption as Caption, i.DetailsURL as [_LinkFor_Caption], '/Orion/images/StatusIcons/Small-' + i.StatusIcon AS [_IconFor_Caption] FROM…

Hello, Yes, please open and put case number here please. thanks a lot

Hello, This issue was fixed in NPM 11.5.2.

Hello, You can use Display setting with SQL too.

Hello, Leon is right. Summary: The best workaround is use any email client with filter which have play sound as action. * Set up alert with Send email -. Add "Play sound" to subject for example. * Open outlook or other mail client. * Set up filter with "Play sound" text in subject. 4. Use "Play sound" as action. Another…

We have this only in new created report, that mean with Custom Table.

${IP_Address} Node IP address, It is Node ip adress not Interface IP adress.

DateTime between (DATEADD(m, DATEDIFF(m, 0, getdate()) -1 , 0)) AND (DATEADD(m, DATEDIFF(m, 0, getdate()) , 0 DateTime between ${fromtime}/${fromtimeUTC} and ${totime}/${totimeUTC} can be used and u can use timeframe picker

Hello Could you please try do this: 1) Stopped IIS & our Services 2) Removed ASP.NET cached files from c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files 3) Re-run CW with just Website configuration If not help don't hesitate to…

Hello, Yes for Custom SQL datasource you need to have Admin rights. Thanks for understanding

Yeah it doesn't like * on nodes. SELECT i.IPAddress,n.caption FROM NODES as n LEFT JOIN NODEIPADDRESSES as i ON N.NodeID = I.NodeID Works fine.

Youre faster]]

Hello, How do you have set Rollup status on that groups? what say this query: SELECT TOP 10000 * FROM [dbo].[Containers_DailyContainerAvailability] JOIN Containers_AlertsAndReportsData ON (Containers_AlertsAndReportsData.GroupID = Containers_DailyContainerAvailability.GroupID) where datetime BETWEEN 41623 AND 41714 AND (…

Hello stefanIT Could you please provide us your query we can look and try optimize. Optimizied Steven Klassen query: DECLARE @StartDate DateTime SET @StartDate = CAST (DATEDIFF(d, 0, DATEADD(d, 1 - day(getdate()), getdate()))as datetime); SELECT TOP 10000 Convert(DateTime,Floor(Cast((DateTime) as Float)),0) AS SummaryDate,…

Hello, For multi-module we have this document: Multi-module system guidelines Lada

Hello, I believe this is more accurate and actual: NPM 12.2 system requirements - SolarWinds Worldwide, LLC. Help and Support Lada

Hello When node is going unmanage alert engine stop executing action on that node. Can be turned off: Settings-> Polling settings -> And check this: Allow alert actions for unmanaged objects Alerting Engine will execute actions for network objects in unmanaged state. After that if someone unmanage something Alert engine…

Hello, Unfortunately if you use Custom SQL or SWQL datasource you should filter inside query. Filtering via UI is not possible, because you can write on that query practically anything. Ill look on your query and try modify it for your needs. Lada

Hello Network_Guru You can send page as HTML. In action tab you can pick Email action and check HTML.

Hello, For custom SQL you need have admin rights. Report management rights isn't enough for Custom SQL. Thanks

Hello, Alert engine runs program under his user(his). That mean you can't see for example calc.exe. I recommended test with 1. test.bat content: dir > c:\test.txt After execute action look into text.txt in C drive. 2. Try run your .bat manually. Maybe alert user doesn't have rights to run your application. 3. Resolution:…

Hello Lawrence, We dropped SQL Server 2005 SP1 and SP2 in NPM 10.7. We support SQL server 2005 SP3 or SP4. Thanks