makecrazy

this reboot count is that correct because its counting node down event . nodes which is monitor by icmp is showing reboot count , how ? need count on router Last Boot

can u add Node.CustomProperties.ATM_Branches = ' ATM Branches ' only to get nodes with above custom property

thanks a lot , let me check it

dear can u copy urs script here , unbale to get script from such huge text

yes, need report only where node get down and now there status are up

reboot = router get down and up in Power when get down in power means its uptime get effected. time = always today date start from 12 AM and end at what time we execute query. yes need same output as yours above chart.

don't know which table to do join. Yes , ATM_Branches is custom property SELECT Nodes.Caption ,COUNT(Nodes.LastBoot) AS [total boot count] ,Nodes.ATM_Branches ,ResponseTime.Availability FROM dbo.ResponseTime INNER JOIN dbo.Nodes ON ResponseTime.NodeID = Nodes.NodeID WHERE Nodes.ATM_Branches LIKE ' atm branches' GROUP BY…

please help 

many thanks , urs provided quey works for me 

dont know why but still there is differance between SWQL script and Report from WEB report for % Availability of yestaerday. SWQL SCRIPT = 96.06 Report Writer Yesterday report of same custom Property ( SP_Media='ptcl fiber') = 96.56 SELECT round(avg(Availability),2) as [Availability] FROM Orion.ResponseTime rt where…

how get average availability of nodes by power BI ?

Hi can you re-generate swql script for yesterday and last 7 days ( as simple script as possible) , i just want add this scrpit in Modern Dashboard KPI to show SLA of Service Provider. like Avg % Availability / Date

i select time period = yesterday SWQL and Report writer giving difference in % Availability. - 1 means yesterday 00:00 to 23:59 on the 11th October ?

Thanks for detail reply. -1 is not giving correct % Availability = 96.75 because by creating report of last 1 day is giving = 94.45 %

@tony.johnson

plzz help

ok these are basically Modern dashboard links that are hyperlink on that buttons so that team can access these dashboard from single page.

i need to add buttons in page view that have hyperlink in it like i made in MAP is this possible. thanks for detail reply

I want to make page view in this style not in MAP , as map get continues auto refresh. Any way to add these hyperlink button on page view 

atm_interface is interface custom property

from where i can get valid and accurate template for cisco ASA 5545

[33bf2722] [06/10/2021 18:34:14.518] -----------------Net. SWTelnet v7.12.4.922------------------- [33bf2722] [06/10/2021 18:34:14.565] UseCustomMorePromptBehaviour: False [33bf2722] [06/10/2021 18:34:14.830] MorePromptKey: [33bf2722] [06/10/2021 18:34:14.940] Custom MorePrompt Pattern: [33bf2722] [06/10/2021 18:34:15.018]…

when date change today chart become empty , i wait for 20 mins but still todays chart is empty what i observer that % increasing in yesterday chart after date change but today chart is empty yesterday chart: today chart: thanks for replying on my every post one last query :) , need combined avg availability and avg down…

can you add yesterday date in this pie chart ? i tried to remove -1 for getting today's avg but it didnt work.

thanks a loooot dear , this query only showing UP % and need to have same for last day with Date 

i want orion.nodescustomproperties = city average availability ( yesterday ) orion.nodescustomproperties = city average Percent Down ( yesterday ) with date option all in one to show in PIE chart. like Average Percent Availability | Average Percent Down Availability | Date

thanks its work plzzz also tell how to get yesterday and today data ( avg availability ) and ( avg Down ) also need to show date colum please

using on modern dash baord need orion.nodescustomproperties = city average availability my nodes having orion.nodescustomproperties = city , need average availability to show on modern dash board of this month and separately of last month

need city average AVAILABILITY

not giving any value