mmayer5823 · Sr. Enterprise Monitoring Engineer

@"bobmarley" thanks much for your reply. That does propagate the statistic value but not the text from the log (in the example. System.Net.WebException: The remote server returned an error: (500) Internal Server Error. That is what I am trying to do. Thanks for your help

Thanks Brian and sum_giais for your replies, I am testing today.

Hi Brian, Thanks for your reply. Well, this just became a lot more complicated. Seems like this would be a common task.

Will do thanks Kevin

Hi Kevin, Thanks for your reply. Those are some good questions. We have a customer at a location that wants to have "end users" be able to login and view their dashboards. Security does not normally permit that in our environment . The discussion has turned to giving them their own additional web server joined to their…

Awesome Kevin and Bourlis, exactly what I needed. Thanks so much for your help.

Nice!!! Works like a champ. You da man. Even in a kilt 

Thanks Kevin, So how would I get just the latest value if I want to use this as a KPI? I used this query for getting 1 specific pollerID SELECT [Metrics].ValueToMonitorId , [Metrics].ObservationTimestamp , [Metrics].AvgMetric , [Metrics].Status , [Metrics].ValueToMonitor.DisplayName AS [Metric Name] ,…

Kevin, I will do that. It will take some time to gather all the queries.

The URLs in the template have been changed by MS.

Yasir, I am looking into the same thing and thus how I cam across your post. Did you evet get this resolved?

Never mind I figured it out . I need to change to the raw value

So we changed our firewall from a Cisco ASA to Fortinet. For the VPN widget for Cisco I used this query which worked great. SELECT CurrentValue FROM Orion.NPM.CustomPollerAssignmentOnNode Where NodeID = '1434' AND DisplayName LIKE 'VPNCurrentUsers' OR NodeID = '2042' AND DisplayName LIKE 'VPNCurrentUsers' Now I am using…

Thanks Steven, works like a champ 

Hey Kevin, I would like to run just the SWQL queries separately to add some of these to a exec dashboard without the JSON. Is that possible?

Using any connect as well and its a pretty simple query. SELECT CurrentValue FROM Orion.NPM.CustomPollerAssignmentOnNode Where NodeID = 'XXXX' AND DisplayName LIKE 'VPNCurrentUsers' OR NodeID = 'XXXX' AND DisplayName LIKE 'VPNCurrentUsers'

Thanks Kevin

So similar to last one I need to be able to show specific interfaces in a table and convert to MBs. Not sure how/where to insert that in this query. SELECT I.NodeID, I.InterfaceID, I.Node.Caption AS Node, I.Caption AS Interface, DATETRUNC('day', I.Traffic.ObservationTimestamp) AS [Day], AVG(I.Traffic.InAveragebps) AS…

How would I round that to 2 decimal points?

Thanks Kevin, Works like a champ. It was giving me timeout for 24 hours but with this it works like a champ. WHERE TimeStamp > (GETUTCDATE() - 0.08) When I am done with these Dashboards I would be happy to share my dashboard(s) with queries. I am sure some others out there would like to duplicate. This one is great for…

Its awesome trying to think of new dashlets. I would like to create a netflow ingress and egress KPI dashboard showing zoom traffic. Here is what I have so far: SELECT Hostname, sourcedomain ,destinationhostname ,egressbytes ,ingressbytes --COUNT (ingessbytes) as Total From Orion.Netflow.FlowsByHostname --count…

Thanks for all your help Kevin, Yes I am aware of the active state but I have created a number of complex alerts based up tags. and actually using tags instead of captions is better. I was just not sure of the correct variable.

My Reply was spam? LOL

Does anyone know how I take that query and add the totals for 2 VPN UDP values so I just have 1 total? SELECT CurrentValue FROM Orion.NPM.CustomPollerAssignmentOnNode Where NodeID = '1434' AND DisplayName LIKE 'VPNCurrentUsers' OR NodeID = '2042' AND DisplayName LIKE 'VPNCurrentUsers'

awesome and thanks Kevin, How do I add exceptions like: WHERE Vendor = 'Windows' AND Caption Not Like '%VM%' AND Caption Not Like '%perf%' AND Caption Not Like '%test%' AND Caption Not Like '%Stage%' AND Caption Not Like '%DEV%' AND Caption Not Like '%QA%'

Thanks for all of the input guys. My new Dashboard(s) is starting to take shape. So one dash I would like to add is for volumes with less then 2 weeks forecast. I found this query from @"jest4kicks" (Thanks Michael) and made a couple of small changes, and I am wondering how I convert/join etc to take the node ID to convert…

Thanks all for your input. I have it working. I do end up with unmanaged devices and servers that I would like to remove from the list as we have a number of volumes called docshares that are full for a reason and we create new volumes.

Thanks for your reply , I am running version 5.1. Let me upgrade to 7 and test

Ughhh, well I am a pain today I guess. Lastly getting this error. PS C:\Users\adminmatm> Import-ModernDashboard -SwisConnection $SwisConnection -Path "C:\Download\import\dashboard.json" Import-ModernDashboard : File content of 'C:\Download\import\dashboard.json' does not match JSON format At line:1 char:1 +…

Thanks so much for your help Kevin, excited to get this going. I am getting this error on the last step PS C:\Users\adminmatm> Import-ModernDashboard -SwisConnection $SwisConnection -Path "C:\Download\import\Dashboard.json" Get-SwisData : No DNS entries exist for host https. At C:\Download\export\moderndash.ps1:214 char:23…