Comments
-
Thanks for the query, seems something has changed from time you made it and values are now not in CustomPollerLabels table but in CustomPollerStatus. Query works and looks like this: SELECT wap.DisplayName as [AP Name], CONCAT('/Orion/Wireless/ThinAccessPointDetailsView.aspx?NetObject=WLTAP:',wap.ID) as [_linkfor_AP Name],…
-
Still works and made some update to poll also last packet and latency SELECT --[SA].ProbeName AS [Source] , [SA].ServiceName AS [Destination],[si].shortdescription , [SA].DetailsUrl AS [_LinkFor_Destination] , CONCAT('/Orion/images/StatusIcons/Small-', [SI].IconPostfix, '.gif') AS [_IconFor_Destination] -- This is the…
-
I dont know if I understood you correctly but you can try something like that select isnull(t1.[Total ATM Branches],0), isnull(t2.[Total Non-ATM Branches],0), isnull(t1.[Total ATM Branches],0) + isnull(t2.[Total Non-ATM Branches],0) as [Total], t2.City from (select count(nodeid) as [Total ATM Branches], City from…
-
Okay it stores IP Address in Decimal format
-
Works for me, check if the inner query return all values for each node
-
You need to extend limitation for your custom property http://www.solarwinds.com/documentation/en/flarehelp/npm/content/core-creating-an-account-limitation-sw1268.htm And then in View in Page Settings set which vlaue or values from your custom property you want to limit widgets on this page
-
Same thing here, this issue seems to be for quite some time now. We are also not able to check what query is set as hubble is not available on those pages. There is a view dbo.UDT_DeviceInventory and in our case ~400k records take around 2 minutes to generate and it seems webpage has timeouts. I made two cases, one for 3.4…
-
I did exactly what you said. I just thought that Solarwinds NTA filter can accept 'like' statements.
-
Wonder if there is possibility to automate this with some powershell script to change this settings and then with task scheduler to run it.
-
Anyone figured it out maybe ? Information notification would be great to have for nodes which have been unmanaged or alerts muted for longer time than X.
-
Hey, we would like to use this for teams if there are some options
-
Thanks you for your answer
-
I tried, seems SWQL query has only Node. properties and in SQL I cant use current node only as I want this widget for each node I have.
-
Perfect, thanks
-
Thank you for links and description. Unfortunately there are no custom pollers assigned to that node so I am trying other options.
-
Hey, thanks for your answer. Second option I know, it is just we have over 70 locations and i would have to make 70+ alerts - which I am not really a big fan to make . I will check with API and Powershell Thanks
-
Thanks for your reply. I know I can do this with Manage Nodes right, but those agents doesnt have this turned on and I wouldnt like them to have so I search for other option for them to set devices which they can see in MM all at once.
-
Okay thanks I made it with SWQL Here is query if someone would like to use that too. SELECT Audit.TimeLoggedUtc as "Time_Logged" ,ActionType.ActionTypeDisplayName as "Action" ,Audit.AccountID as "User" ,node.Caption as "Node" ,Node.IP_Address as "IP" ,Node.UnManageFrom as "FromTime" ,Node.UnManageUntil as "UntilTime" FROM…
-
Same goes with SQL query, just the top one ${SQL: SELECT n.Caption from [dbo].[Nodes] as N left join [dbo].[Dependencies] as D ON n.nodeid = d.ChildNetObjectID WHERE d.ParentNetObjectID = '${N=SwisEntity;M=NodeID}'}
-
Case: OBJECT REFERENCE NOT SET TO AN INSTANCE OF AN OBJECT - just for one Node. Solution: Assign Poller Engine It turned out after Orion platform upgrade that I was able to get into Edit settings of that unknown node that Polling Engine is not assigned. So I tried to put it on also changed IP and Name of that node and…