mnsh_majumder ✭✭✭✭✭

This query will give the result of all those nodes who is currently not down/unmanaged & is having 100% packet loss with 100% availability SELECT NODES.CAPTION,RT.nodeid,RT.PERCENTLOSS,NODES.STATUSDESCRIPTION,NODES.STATUS FROM [dbo].[NODES] JOIN [dbo].[ResponseTime] RT ON NODES.NODEID=RT.NODEID where RT.percentloss>=60 AND…

Below SQL query in the trigger condition will give us the details of all those nodes who was recently rebooted where lastboot>(DATEADD(minute, -5, GETDATE())) and statusdescription not like'%unmanaged%' UTC->CST where lastboot>(DATEADD(minute, -5, (select DATEADD(hour, -6, getutcdate())))) and statusdescription not…

Thanks for the help, it worked!!

Thanks :) DayDiff() gave me the data. Do you know which function should i use to get the month count.

I'm trying to get the days count between unmanagefrom & current date using DATEDIFF but not working. Can someone help me with the correct SWQL function that i can use to get the result

SQL query ---------- SELECT 'Unmanaged' as [Status] ,n.Caption AS [Node],n.ip_address,n.machinetype ,n.UnManageFrom AS [From] ,n.UnManageuntil AS [To] ,DATEDIFF (day, n.UnManagefrom, GETDATE()) AS [DAYS] ,CASE WHEN ae.accountID IS NULL THEN 'Audit Log Not Found' ELSE ae.AccountID END AS [Account] FROM [dbo].[Nodes] n JOIN…

This did helped me to modify the source code & get the report as per the requirement.

Understood, Actually I was checking from DB manager

Have modified & used below query to get me the report. ------------------------POLLING STATUS WITHOUT SAM------------------------------ SELECT DISTINCT [E].ServerName AS [Server Name] , [E].ServerType , ROUND([N].SystemUpTime / 60 / 60 / 24, 0) AS [Uptime (Days)] , [E].Elements AS [Monitored Elements] , [E].Nodes AS…

I don't see Orion.PollingUsage table exist in SolarWind DB.

Have already gone through them but just for the update engineproperties table , coln:Orion.Standard.Polling stores the polling rate % value which I was looking for preparing the report.

You follow this doc shared Set up monitoring Cisco ASA firewalls in NPM (solarwinds.com) Solarwind already has VPN FW alert profile provided by default. So once CLI polling is enabled you can do a live test from the profile on that node

any solution suggested by vendor for this?

It should work.The query runs on web based report as I have ran the same and it worked for me. On Thu, Dec 5, 2019, 11:29 PM wes.reneau

I have modified the query only for Windows device (incase if someone is looking for any certain Vendor related report). Added extra columns from DB & removed few unwanted one's. SELECT 'Unmanaged' as [Status] ,n.Caption AS [Node],n.ip_address,n.machinetype ,tostring(tolocal(n.UnManageFrom)) AS [From] ,CASE WHEN…