makecrazy

kindly add Gifs support so that any critical icon can blink on down state

Restrict any user from creating or editing Modern dashboard who don't have have Dashboard rights.

can any brother help me out

Hi mesverrum need to have swql query to add in Modern Dashboard i had search all forum but unable to get query which only shows Todays data

@ jajao555 in urs provided swql query its not define that date is only for today , need to have todays Avg availability in business hours 

@"KMSigma.SWI" need yours help

need to have some tweaking in provided swql query

got simple query for same but need to get result in this format Media typeTotalATM BranchesNon-ATM BranchFiber30015050 SELECT n.CustomProperties.Branch_Media as Location, COUNT(n.NodeID) AS [Total Fiber] FROM Orion.Nodes n WHERE ( n.CustomProperties.SP1 LIKE 'cybernet%' or n.CustomProperties.SP2 LIKE 'cybernet%' or…

can any one provide help on above mentioned query

updated , thanks SELECT Nodes.Caption, Nodes.IPAddress,nodes.CustomProperties.Branch_media ,nodes.CustomProperties.Media_Type_1,nodes.CustomProperties.Media_Type_2,nodes.CustomProperties.Media_Type_3, Nodes.CustomProperties.regions, nodes.status, TOLOCAL(StartTime.EventTime) AS DownTime , TOLOCAL( ( SELECT TOP 1…

Thanks , kindly guide how to apply tolocal on EndTime.EventTime , tolocal applied on StartTime.EventTime SELECT Nodes.Caption, Nodes.IPAddress,nodes.CustomProperties.Branch_media ,nodes.CustomProperties.Media_Type_1,nodes.CustomProperties.Media_Type_2,nodes.CustomProperties.Media_Type_3, Nodes.CustomProperties.regions,…

Hi sum_giais can just add ( date = today and time = 9 am ) in mentioned query SELECT m.Media_Type ,COUNT(m.NodeID) AS [Total] ,COUNT(CASE WHEN m.Status = 2 THEN 1 END) AS [Down] FROM ( SELECT n.NodeID ,CASE WHEN n.CustomProperties.SP1 IS NOT NULL THEN n.CustomProperties.SP1 WHEN n.CustomProperties.SP2 IS NOT NULL THEN…

sum_giais need one more help need to get SWQL result of specific time i.e. down count only of 9 AM 

Down alert will not compile the requirement , need node down count on specific 

Excellent , thanks a loot 

Dear its works , thanks. can Null be removed from out put

Hi Sum_gails thanks for urs reply , getting this error while running urs provided query

many thanks 

can any 1 help me on this 

Seashore yes its works correctly. one more and last thing can u add per city down count in it , like Total ATM BranchesUnmanaged Cout ATM BranchesDown Count ATM BranchesTotal Non-ATM BranchesUnmanaged Cout Non-ATM BranchesDown Cout Non-ATM…

its not showing right total count. actual count: and urs provided script showing also need to have unmanage count per city in front of " Total ATM Branhes " and " Non-ATM Branches" like:

Seashore getting this error 

Dear Seashore thanks it works perfectly. can u add also unmanage count per city in front of " Total ATM Branhes " and " Non-ATM Branches" Total ATM BranchesUnmanaged Cout ATM BranchesTotal Non-ATM BranchesUnmanaged Cout Non-ATM BranchesTotal_Branchescity5856864Bahawalpur72427399Faisalabad68116774Gujranwala

Hi Dear i had opened case on SW and after long discussion i got correct SWQL script that is generating same results as orion web report. SELECT CONCAT(ROUND(Availability,2), ' %') AS sla_availability FROM ( SELECT SUM(Availability * Weight) / SUM(Weight) AS [Availability] FROM Orion.ResponseTime AS rt WHERE…

Ok I will open case for it Thanks

any update on this and case number

Thanks for opening case for this issue. sure i will post if i can any resolution for this issue.

Hi first of all thanks for supporting me in this issue. What do you get if you don't use custom SWQL for the report? we need to add SLA % in modern dashboard that why trying to get same result in Custom SWQL query. i had imported urs provided report and its showing correct Last Month availability % as my report in web…

both % availability on swql studio and Custom Query widget are same but different from web report writer. i.e. 93.04 SELECT round(avg(Availability), 2) as supernet FROM Orion.ResponseTime rt where (MONTHDIFF ([rt].ObservationTimestamp, GETDATE()) =1) and rt.Node.CustomProperties.SLA_LTE ='supernet' also tried in SQL but…

any confirm solution of the issue that iam facing ?