The most recent content from our members.
Hello everybody Can help to SWQL below? SELECT aa.TriggeredMessage, aa.TriggeredDateTime, SUBSTRING(aa.TriggeredDateTime, 1, 19) AS [Data do evento], ao.RelatedNodeCaption, ao.EntityCaption, ac.Name, ac.AlertMessage, ac.Severity, ab.Comments, CONCAT( CAST((CAST(SUBSTRING(aa.TriggeredDateTime, 12, 2) AS INT) + 21) % 24 AS…
Hi all, Hope someone can help. I have no idea about SQL/WSQL. I've copied and altered as best I can to get the info needed. I had started work a couple of years ago on modern dashboards. I've got a basic high level overview of all devices (up/down/critical etc) which is fine for now. I then started to build dashboards for…
Hi everyone, May I request some help on a timeseries chart in modern dashboard? I am creating a dashboard for all our internet line and I would like to create a timeseries chart for the summarized Inbps and Outbps of all internet line, but the problem is that modern dashboard seems only support the PerfStack graph. Does…
Hi I have a problem in show bps in Modern dashboard interface bandwidth when i use Time series Widget but show Mbs in perfstack with same interface bandwidth when i create project and use in modern dashboard convert to bps can you help me? tanks
Both queries give me the results I need in separate tables, now I just need help with the formatting and syntanx for it to work properly in ONE table. Can anyone help me out with this join? SELECT n.FullyQualifiedName,n.ApplicationAlert.ApplicationAvailability AS…
Hello all, I'm new to Modern Dashboards and I'm trying to create a KPI widget that shows a down/critical application count but I need to filter by a custom property. I'm using a simple count but I'm not sure how to add the filter. Below is my count query: SELECT COUNT(1) AS KPI_Numbe from Orion.APM.Application WHERE…
Hello, I am trying to create a table widget that reports availability metrics for some custom properties. I have tried 3 different solutions and none of them have worked out. If anyone has a solution to any of the following attempts, please let me know! 1. We have an existing table in the old dashboard that is reporting…
With the migration to modern dashboards many of us are rolling out thanks to the awesomesauce that is 2020.2 I had hit a snag on the "latency/packet loss" graphic widget in classic. After a few weeks trial and error and a lot of help with swql nesting from @daniel_ on this I'm ready to share. Our environment has 2 WAN…
It looks like you're new here. Sign in or register to get started.