Modern View -- KPI to count Nodes that are up, down, and total number of nodes

mickdon

Hello All, 

I'm new to Solarwinds but have been watching a couple of videos to get myself up to speed.

I was tasked with creating a view that can show the count and tables of host down, hosts up, and total host of some particular systems managed by a particular group in our organization. 

I can only count the total numbers of nodes managed in my organization and not the specific group. My humble question is how can i filter/Count the specific group -- or example, Helpdesk --  and not the total numbers of nodes in our organization. 

Thank you for your assistance in advance. 

Select Count(1) as Countnodes from Orion.nodes where status <>1                                                        Comment: I assume the <> sign means systems that are not up

Select Count(1) as Countnodes from Orion.nodes where status = 1                                                          Comment: For systems that are up

Select Count(1) as CountNodes From Orion Nodes                                                                                    Comment: Total number of nodes

  

christopher.t.jones123

@mickdon, is there a common field that can be used to reference the various groups you want to break them down by? Things like a naming convention, IP Address, or a custom property (this is the most used method for something like this)? If so, then you can add additional conditions to your WHERE statement by using AND/OR to scope it a little more. As an example, if its a naming convention you could modify your WHERE statement to read "WHERE Status <> 1 AND Caption like '%HelpDesk%'

If there is no common value or field already populated you could create a node Custom Property (linked for how to do this) and then add to your WHERE statement by calling the Custom Property instead 'WHERE Status <> 1 AND Orion.Nodes.CustomProperties.NameOfCP like '%HelpDesk%'