Dashboard of Different Custom Monitors

Greetings -

The server patching team is looking for a dashboard or dashboards to display some custom SAM monitors that monitor services to tell if they are up or down. 

We have an issue where we patch our SQL nodes and when they come backup up some of the SQL services are not started and that causes some issues with SQL.  I put together a SQL services monitor that monitors SQL Server Agent, SQL Server Service, and SQL Server VSS writer on all of our SQL nodes.  This is a bit of a starting point and we will be adding additional service monitors once we ID what services we need to monitor. 

Can I put together a dashboard of different monitors so the patching team can have this up when they are patching to verify that everything came up successfully?  This can be a classic or modern dashboard I am looking to put something together for this.  Ideally if someone can point me in the right direction I can start running with this once I know where to begin.

Thanks!


Dave

Parents
  • Sorry for being late to the game on this one but if don't want to use the GUI data source picker, you can feel free to use the following SWQL Query.  I already filtered the results to exclude any Nodes that do not have an Application assigned to the Node but you can feel free to add further filters by adding further WHERE statements.

    SELECT Node.Caption AS NodeName
        , Node.Status AS NodeStatus
        , Node.DetailsURL AS NodesURL
        , Node.Applications.Name AS ApplicationName
        , Node.Applications.Status AS ApplicationStatus
        , Node.Applications.DetailsURL AS ApplicationURL
        , Node.Applications.Components.Name AS ComponentName
        , Node.Applications.Components.Status AS ComponentStatus
        , Node.Applications.DetailsURL AS ComponentURL
    FROM Orion.Nodes Node
    WHERE Node.Applications.Name IS NOT NULL

  • If I wanted a specific application would I change the "ApplicationName" to the specific application?

  • Pretty much...

    SELECT [Nodes].Caption AS NodeName
         , [Nodes].Status AS NodeStatus
         , [Nodes].DetailsURL AS NodesURL
         , [Nodes].Applications.Name AS ApplicationName
         , [Nodes].Applications.Status AS ApplicationStatus
         , [Nodes].Applications.DetailsURL AS ApplicationURL
         , [Nodes].Applications.Components.Name AS ComponentName
         , [Nodes].Applications.Components.Status AS ComponentStatus
         , [Nodes].Applications.DetailsURL AS ComponentURL
    FROM Orion.Nodes AS [Nodes]
    WHERE [Nodes].Applications.Name = 'My Application Name Here'

Reply
  • Pretty much...

    SELECT [Nodes].Caption AS NodeName
         , [Nodes].Status AS NodeStatus
         , [Nodes].DetailsURL AS NodesURL
         , [Nodes].Applications.Name AS ApplicationName
         , [Nodes].Applications.Status AS ApplicationStatus
         , [Nodes].Applications.DetailsURL AS ApplicationURL
         , [Nodes].Applications.Components.Name AS ComponentName
         , [Nodes].Applications.Components.Status AS ComponentStatus
         , [Nodes].Applications.DetailsURL AS ComponentURL
    FROM Orion.Nodes AS [Nodes]
    WHERE [Nodes].Applications.Name = 'My Application Name Here'

Children
  • Yeah, as already pointed out, you can change the "IS NOT NULL" to be "= <variable here>".  And you can do this for anything property.  Say you are building a Department Dashboard and you have "Department" as a Custom Property.   You can simply do something like this as shown below.

    SELECT [Nodes].Caption AS NodeName
         , [Nodes].Status AS NodeStatus
         , [Nodes].DetailsURL AS NodesURL
         , [Nodes].Applications.Name AS ApplicationName
         , [Nodes].Applications.Status AS ApplicationStatus
         , [Nodes].Applications.DetailsURL AS ApplicationURL
         , [Nodes].Applications.Components.Name AS ComponentName
         , [Nodes].Applications.Components.Status AS ComponentStatus
         , [Nodes].Applications.DetailsURL AS ComponentURL
    FROM Orion.Nodes AS [Nodes]
    WHERE [Nodes].CustomProperties.Department = <Department Name>

    And you are not limited to just filtering by one thing.  You can filter it by as many data points as you want such as Production/Non-Production/Development, Application Name, Department, or whatever other Custom Properties you have working within your environment.

    This is why I feel learning how to leverage SWQL is a game changer to any monitor engineer's workflow.  Yes, the drop-down lists are nice and easy but once you figure out how easy using SWQL is, your world will change for every within SolarWinds.  I know mine did.

  • Thank you started using Dept and application name to query against. Love using the Thwack for picking up ideas and which swql tables I need to use/combine. keep up the post...been using alot of you post.