Export to PDF

Sunday, May 12, 2024 6:30:07 AM

SD-WAN Orchestrator Details - Meraki Orchestrator Controller - SD-WAN Orchestrator Summary

Management

Widget is hidden on dashboard,
there is no data to show now.

Help

Details

Widget is hidden on dashboard,
there is no data to show now.

Active Alerts

Widget is hidden on dashboard,
there is no data to show now.

Latest Events

Widget is hidden on dashboard,
there is no data to show now.

Help

WAN UpLinks

Widget is hidden on dashboard,
there is no data to show now.

Help

Warm Spare

Widget is hidden on dashboard,
there is no data to show now.

Help

Edge Devices

Widget is hidden on dashboard,
there is no data to show now.

AppStack Environment for Meraki Orchestrator

Widget is hidden on dashboard,
there is no data to show now.

Help

Edge Devices Performance

Widget is hidden on dashboard,
there is no data to show now.

Help

Edge Devices Status

Widget is hidden on dashboard,
there is no data to show now.

Help

VPN Connections

SELECT 
    n1.Caption AS [Source Node], 
    '/Orion/images/StatusIcons/small-' + ToString(n1.StatusIcon) AS [_IconFor_Source Node],
    n1.DetailsUrl AS [_LinkFor_Source Node],
    CASE WHEN si1.InterfaceInfo IS NULL THEN c.SrcInterface ELSE si1.InterfaceInfo END AS [Source Interface],
    '/Orion/images/StatusIcons/small-' + CASE WHEN i1.InterfaceID IS NULL THEN 'unknown.gif' ELSE ToString(i1.StatusIcon) END AS [_IconFor_Source Interface],
    i1.DetailsUrl AS [_LinkFor_Source Interface],
    '' as [ ],
    '/Orion/images/TopologyItems/RArrow2.png' AS [_iconfor_ ],
    c.StatusDescription AS [Status],
    '' as [  ],
    '/Orion/images/TopologyItems/LArrow2.png' AS [_iconfor_  ],
    CASE WHEN c.DestNodeID IS NULL THEN c.ExternalDestInterface 
         ELSE CASE WHEN si2.InterfaceInfo IS NULL THEN c.DestInterface ELSE si2.InterfaceInfo END 
    END AS [Target Interface],
    '/Orion/images/StatusIcons/small-' + 
    CASE WHEN c.DestNodeID IS NULL THEN NULL 
         ELSE CASE WHEN i2.InterfaceID IS NULL THEN 'unknown.gif' ELSE ToString(i2.StatusIcon) END 
    END AS [_IconFor_Target Interface],
    i2.DetailsUrl AS [_LinkFor_Target Interface],
    CASE WHEN c.DestNodeID IS NULL THEN c.ExternalDestNode ELSE n2.Caption END AS [Target Node],
    '/Orion/images/StatusIcons/small-' + ToString(n2.StatusIcon) AS [_IconFor_Target Node],
    n2.DetailsUrl AS [_LinkFor_Target Node]
FROM Orion.SdWan.TopologyConnections (nolock=true) c
JOIN Orion.Nodes (nolock=true) n1 ON n1.NodeID = c.SrcNodeID
LEFT JOIN Orion.Nodes (nolock=true) n2 ON n2.NodeID = c.DestNodeID
LEFT JOIN Orion.SdWan.NodesInterfaces (nolock=true) si1 ON si1.InterfaceID = c.SrcInterfaceID
LEFT JOIN Orion.SdWan.NodesInterfaces (nolock=true) si2 ON si2.InterfaceID = c.DestInterfaceID
LEFT JOIN Orion.NPM.Interfaces (nolock=true) i1 ON i1.InterfaceID = c.SrcInterfaceID
LEFT JOIN Orion.NPM.Interfaces (nolock=true) i2 ON i2.InterfaceID = c.DestInterfaceID
LEFT JOIN Orion.SdWan.Nodes (nolock=true) sn1 ON sn1.NodeID = c.SrcNodeID
LEFT JOIN Orion.SdWan.Nodes (nolock=true) sn2 ON sn2.NodeID = c.DestNodeID
WHERE sn1.OrchestratorNodeID = 505 OR sn2.OrchestratorNodeID = 505

SELECT 
    n1.Caption AS [Source Node], 
    '/Orion/images/StatusIcons/small-' + ToString(n1.StatusIcon) AS [_IconFor_Source Node],
    n1.DetailsUrl AS [_LinkFor_Source Node],
    CASE WHEN si1.InterfaceInfo IS NULL THEN c.SrcInterface ELSE si1.InterfaceInfo END AS [Source Interface],
    '/Orion/images/StatusIcons/small-' + CASE WHEN i1.InterfaceID IS NULL THEN 'unknown.gif' ELSE ToString(i1.StatusIcon) END AS [_IconFor_Source Interface],
    i1.DetailsUrl AS [_LinkFor_Source Interface],
    '' as [ ],
    '/Orion/images/TopologyItems/RArrow2.png' AS [_iconfor_ ],
    c.StatusDescription AS [Status],
    '' as [  ],
    '/Orion/images/TopologyItems/LArrow2.png' AS [_iconfor_  ],
    CASE WHEN c.DestNodeID IS NULL THEN c.ExternalDestInterface 
         ELSE CASE WHEN si2.InterfaceInfo IS NULL THEN c.DestInterface ELSE si2.InterfaceInfo END 
    END AS [Target Interface],
    '/Orion/images/StatusIcons/small-' + 
    CASE WHEN c.DestNodeID IS NULL THEN NULL 
         ELSE CASE WHEN i2.InterfaceID IS NULL THEN 'unknown.gif' ELSE ToString(i2.StatusIcon) END 
    END AS [_IconFor_Target Interface],
    i2.DetailsUrl AS [_LinkFor_Target Interface],
    CASE WHEN c.DestNodeID IS NULL THEN c.ExternalDestNode ELSE n2.Caption END AS [Target Node],
    '/Orion/images/StatusIcons/small-' + ToString(n2.StatusIcon) AS [_IconFor_Target Node],
    n2.DetailsUrl AS [_LinkFor_Target Node]
FROM Orion.SdWan.TopologyConnections (nolock=true) c
JOIN Orion.Nodes (nolock=true) n1 ON n1.NodeID = c.SrcNodeID
LEFT JOIN Orion.Nodes (nolock=true) n2 ON n2.NodeID = c.DestNodeID
LEFT JOIN Orion.SdWan.NodesInterfaces (nolock=true) si1 ON si1.InterfaceID = c.SrcInterfaceID
LEFT JOIN Orion.SdWan.NodesInterfaces (nolock=true) si2 ON si2.InterfaceID = c.DestInterfaceID
LEFT JOIN Orion.NPM.Interfaces (nolock=true) i1 ON i1.InterfaceID = c.SrcInterfaceID
LEFT JOIN Orion.NPM.Interfaces (nolock=true) i2 ON i2.InterfaceID = c.DestInterfaceID
LEFT JOIN Orion.SdWan.Nodes (nolock=true) sn1 ON sn1.NodeID = c.SrcNodeID
LEFT JOIN Orion.SdWan.Nodes (nolock=true) sn2 ON sn2.NodeID = c.DestNodeID
WHERE (sn1.OrchestratorNodeID = 505 OR sn2.OrchestratorNodeID = 505)
    AND (n1.Caption LIKE '%${SEARCH_STRING}%'
      OR si1.InterfaceInfo LIKE '%${SEARCH_STRING}%'
      OR n2.Caption LIKE '%${SEARCH_STRING}%'
      OR si2.InterfaceInfo LIKE '%${SEARCH_STRING}%'
      OR c.ExternalDestNode LIKE '%${SEARCH_STRING}%'
      OR c.ExternalDestInterface LIKE '%${SEARCH_STRING}%')

Widget is hidden on dashboard,
there is no data to show now.

Help

Top SD-WAN VPN Tunnels by Average Jitter

Widget is hidden on dashboard,
there is no data to show now.

Help

NPM Network Topology

Show

NODE

WITH

INTERFACE

CONNECTS TO

INTERFACE

NODE

LOSA-MX64-FW

Unknown

GigabitEthernet1/0/13

LosA-1920-SW

LOSA-MX64-FW

Unknown

GigabitEthernet1/0/14

LosA-1920-SW

LOSA-MX64-FW

lan4

Custom

wan1

LOSA-MX64-FW

lan4

Custom

lan4

NEWY-MX64-FW

LOSA-MX64-FW

wan1

Unknown

LosA-1920-SW

Page

of 2

Show All

Displaying 1 - 5 of 8

Widget is hidden on dashboard,
there is no data to show now.

Help

Top SD-WAN VPN Tunnels by Average Latency

Widget is hidden on dashboard,
there is no data to show now.

Help

Top SD-WAN VPN Tunnels by Average Packet Loss

Widget is hidden on dashboard,
there is no data to show now.

Help

SD-WAN Map

Widget is hidden on dashboard,
there is no data to show now.

Help

Orchestrator Inventory

Last Rediscovery: 5/12/2024 6:29:06 AM

SELECT d.Name AS [Device Name],
n.DetailsUrl AS [_LinkFor_Device Name],
TOLOWER(CASE WHEN ns.DeviceID IS NULL OR sdwn.StatusDescription IS NULL
    THEN d.StatusDescription
    ELSE sdwn.StatusDescription
END) AS [Status],
'/Orion/images/StatusIcons/small-' + ToString(n.StatusIcon) AS [_IconFor_Device Name],
d.IPAddress AS [IP Address],
d.Model AS [Model], 
d.ProductType AS [Product Type],
d.DeviceSerial AS [Serial No],
ISNULL(d.SiteName, d.SiteID) AS [Network],
CASE WHEN ns.DeviceID IS NOT NULL
    THEN NULL
    ELSE ''
END AS [Managed by Platform],
CASE WHEN ns.DeviceID IS NOT NULL 
    THEN '/Orion/images/ok_16x16.gif'
    ELSE '/Orion/images/StatusIcons/Small-EmptyIcon.gif'
END AS [_IconFor_Managed by Platform]
FROM Orion.Orchestrators.Devices (nolock=true) d
FULL JOIN Orion.Orchestrators.Nodes (nolock=true) ns ON d.OrchestratorNodeID = d.OrchestratorNodeID AND ns.DeviceID = d.DeviceID
LEFT JOIN Orion.Nodes (nolock=true) n
ON n.NodeID = ns.NodeID
LEFT JOIN Orion.SdWan.Nodes sdwn
ON sdwn.NodeID = n.NodeID
WHERE d.OrchestratorNodeID = 505
ORDER BY d.Name

SELECT d.Name AS [Device Name],
n.DetailsUrl AS [_LinkFor_Device Name],
TOLOWER(CASE WHEN ns.DeviceID IS NULL OR sdwn.StatusDescription IS NULL
    THEN d.StatusDescription
    ELSE TOLOWER(sdwn.StatusDescription)
END) AS [Status],
'/Orion/images/StatusIcons/small-' + ToString(n.StatusIcon) AS [_IconFor_Device Name],
d.IPAddress AS [IP Address],
d.Model AS [Model], 
d.ProductType AS [Product Type],
d.DeviceSerial AS [Serial No],
ISNULL(d.SiteName, d.SiteID) AS [Network],
CASE WHEN ns.DeviceID IS NOT NULL
    THEN NULL
    ELSE ''
END AS [Managed by Platform],
CASE WHEN ns.DeviceID IS NOT NULL 
    THEN '/Orion/images/ok_16x16.gif'
    ELSE '/Orion/images/StatusIcons/Small-EmptyIcon.gif'
END AS [_IconFor_Managed by Platform]
FROM Orion.Orchestrators.Devices (nolock=true) d
FULL JOIN Orion.Orchestrators.Nodes (nolock=true) ns ON d.OrchestratorNodeID = d.OrchestratorNodeID AND ns.DeviceID = d.DeviceID
LEFT JOIN Orion.Nodes (nolock=true) n
ON n.NodeID = ns.NodeID
LEFT JOIN Orion.SdWan.Nodes sdwn
ON sdwn.NodeID = n.NodeID
WHERE d.OrchestratorNodeID = 505 AND (n.Caption LIKE '%${SEARCH_STRING}%'
    OR d.Name LIKE '%${SEARCH_STRING}%'
    OR d.IPAddress LIKE '%${SEARCH_STRING}%'
    OR d.Model LIKE '%${SEARCH_STRING}%'
    OR d.ProductType LIKE '%${SEARCH_STRING}%'
    OR d.DeviceSerial LIKE '%${SEARCH_STRING}%'
    OR d.SiteID LIKE '%${SEARCH_STRING}%'
    OR d.SiteName LIKE '%${SEARCH_STRING}%'
    OR d.StatusDescription LIKE '%${SEARCH_STRING}%')
ORDER BY d.Name

Widget is hidden on dashboard,
there is no data to show now.

Help

VPN Tunnels

SELECT
    n.Caption AS [Source Node], 
    '/Orion/images/StatusIcons/small-' + ToString(n.StatusIcon) AS [_IconFor_Source Node],
    sn.DetailsUrl AS [_LinkFor_Source Node],
    '' as [ ],
    '/Orion/images/TopologyItems/RArrow2.png' AS [_iconfor_ ],
    CASE WHEN n2.Caption IS NULL THEN t.PeerName ELSE n2.Caption END AS [Target Node], 
    '/Orion/images/StatusIcons/small-' + ToString(n2.StatusIcon) AS [_IconFor_Target Node],
    sn2.DetailsUrl AS [_LinkFor_Target Node],
    t.DisplayName AS [Name], 
    CASE
        WHEN t.Status = 1 THEN '/Orion/images/StatusIcons/small-up.gif'
        WHEN t.Status = 2 THEN '/Orion/images/StatusIcons/small-down.gif'
        WHEN t.Status = 3 THEN '/Orion/images/StatusIcons/small-warning.gif'
        WHEN t.Status = 10 THEN '/Orion/images/StatusIcons/small-unplugged.gif'
        WHEN t.Status = 12 THEN '/Orion/images/StatusIcons/small-unreachable.gif'
        WHEN t.Status = 14 THEN '/Orion/images/StatusIcons/small-critical.gif'
        WHEN t.Status = 22 THEN '/Orion/images/StatusIcons/small-up.gif'
        WHEN t.Status = 31 THEN '/Orion/images/StatusIcons/small-up.gif'
        ELSE '/Orion/images/StatusIcons/small-unknown.gif'
    END AS [_IconFor_Name], 
    t.DetailsUrl AS [_LinkFor_Name], 
    t.StatusDescription AS [Status],
    ROUND(t.AvgJitter,2) AS [Jitter], 
    ROUND(t.AvgLatency,2) AS [Latency],
    ROUND(t.AvgPacketLoss,2) AS [Packet Loss],
    ni.ServiceProvider AS [Service Provider]
FROM Orion.SdWan.Tunnels (nolock=true) t
LEFT JOIN Orion.SdWan.NodesInterfaces (nolock=true) ni ON ni.NodeInterfaceID = t.NodeInterfaceID
LEFT JOIN Orion.SdWan.Nodes (nolock=true) sn ON sn.NodeID = ni.NodeID
LEFT JOIN Orion.Nodes (nolock=true) n ON n.NodeID = sn.NodeID
LEFT JOIN Orion.SdWan.NodesInterfaces (nolock=true) ni2 ON ni2.NodeInterfaceID = t.PeerNodeInterfaceID
LEFT JOIN Orion.SdWan.Nodes (nolock=true) sn2 ON sn2.NodeID = ni2.NodeID
LEFT JOIN Orion.Nodes (nolock=true) n2 ON n2.NodeID = sn2.NodeID
WHERE sn.OrchestratorNodeID = 505

SELECT
    n.Caption AS [Source Node], 
    '/Orion/images/StatusIcons/small-' + ToString(n.StatusIcon) AS [_IconFor_Source Node],
    sn.DetailsUrl AS [_LinkFor_Source Node],
    '' as [ ],
    '/Orion/images/TopologyItems/RArrow2.png' AS [_iconfor_ ],
    CASE WHEN n2.Caption IS NULL THEN t.PeerName ELSE n2.Caption END AS [Target Node],
    '/Orion/images/StatusIcons/small-' + ToString(n2.StatusIcon) AS [_IconFor_Target Node],
    sn2.DetailsUrl AS [_LinkFor_Target Node],
    t.DisplayName AS [Name], 
    CASE
        WHEN t.Status = 1 THEN '/Orion/images/StatusIcons/small-up.gif'
        WHEN t.Status = 2 THEN '/Orion/images/StatusIcons/small-down.gif'
        WHEN t.Status = 3 THEN '/Orion/images/StatusIcons/small-warning.gif'
        WHEN t.Status = 10 THEN '/Orion/images/StatusIcons/small-unplugged.gif'
        WHEN t.Status = 12 THEN '/Orion/images/StatusIcons/small-unreachable.gif'
        WHEN t.Status = 14 THEN '/Orion/images/StatusIcons/small-critical.gif'
        WHEN t.Status = 22 THEN '/Orion/images/StatusIcons/small-up.gif'
        WHEN t.Status = 31 THEN '/Orion/images/StatusIcons/small-up.gif'
        ELSE '/Orion/images/StatusIcons/small-unknown.gif'
    END AS [_IconFor_Name], 
    t.DetailsUrl AS [_LinkFor_Name], 
    t.StatusDescription AS [Status],
    ROUND(t.AvgJitter,2) AS [Jitter], 
    ROUND(t.AvgLatency,2) AS [Latency],
    ROUND(t.AvgPacketLoss,2) AS [Packet Loss],
    ni.ServiceProvider AS [Service Provider]
FROM Orion.SdWan.Tunnels (nolock=true) t
LEFT JOIN Orion.SdWan.NodesInterfaces (nolock=true) ni ON ni.NodeInterfaceID = t.NodeInterfaceID
LEFT JOIN Orion.SdWan.Nodes (nolock=true) sn ON sn.NodeID = ni.NodeID
LEFT JOIN Orion.Nodes (nolock=true) n ON n.NodeID = sn.NodeID
LEFT JOIN Orion.SdWan.NodesInterfaces (nolock=true) ni2 ON ni2.NodeInterfaceID = t.PeerNodeInterfaceID
LEFT JOIN Orion.SdWan.Nodes (nolock=true) sn2 ON sn2.NodeID = ni2.NodeID
LEFT JOIN Orion.Nodes (nolock=true) n2 ON n2.NodeID = sn2.NodeID
WHERE (sn.OrchestratorNodeID = 505)
    AND (n.Caption LIKE '%${SEARCH_STRING}%'
      OR t.SourceInterface LIKE '%${SEARCH_STRING}%'
      OR t.DisplayName LIKE '%${SEARCH_STRING}%'
      OR t.StatusDescription LIKE '%${SEARCH_STRING}%'
      OR ni.ServiceProvider LIKE '%${SEARCH_STRING}%'
      OR t.PeerName LIKE '%${SEARCH_STRING}%'
      OR t.PeerInterface LIKE '%${SEARCH_STRING}%')

Widget is hidden on dashboard,
there is no data to show now.

Customize Page

Page Settings

SD-WAN Orchestrator Summary

Wireless Controller Summary

Map

Last Rediscovery: 5/12/2024 6:29:06 AM

SolarWinds Demo Feedback