Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Enterprise Operations Console (EOC) > EOC 2.0 Administrator Guide > Customize the Environment Summary resource

Customize the Environment Summary resource

Updated: September 12, 2017

On the Enterprise Environment view, the Environment Summary resource displays a set of status tiles. Each tile displays aggregated status information for a set of entities, and shows the top five alerts associated with those entities.

You can customize the layout and content of these tiles. For example, you can rearrange, disable, or delete tiles. You can also create custom tiles.

  1. Click My Dashboards > Enterprise Summary.
  2. Click the menu icon File:Success_Center/Reusable_content_-_InfoDev/EOC/EOC_2.0_Administrator_Guide/0050-View_information_from_SolarWinds_Sites/0020-Customize_the_Environment_Summary_resource/MenuIcon.png in the upper-right corner of the Environment Summary resource.
  3. On the drop-down menu, click Configure.

    The Edit Environment Summary dialog opens. A rectangle represents each tile.

    File:Success_Center/Reusable_content_-_InfoDev/EOC/EOC_2.0_Administrator_Guide/0050-View_information_from_SolarWinds_Sites/0020-Customize_the_Environment_Summary_resource/Tiles.png

  4. To rearrange tiles, drag the tile to the desired location on the Edit Environment Summary dialog box and drop it in an area labeled Drop Here.

    File:Success_Center/Reusable_content_-_InfoDev/EOC/EOC_2.0_Administrator_Guide/0050-View_information_from_SolarWinds_Sites/0020-Customize_the_Environment_Summary_resource/DragAndDropTile.png

  5. To disable a tile, click Disable.

    The tile is removed from the Environment Summary resource, but it is not deleted. You can click Enable to display it again.

  6. To delete a custom tile, click Delete on the tile, and then again in the confirmation dialog box.

    Default tiles cannot be deleted.

  7. To add a custom tile, see Add a custom tile below.
  8. To edit a custom tile, click Edit.

    Default tiles cannot be edited.

  9. Click Save.

Add a custom status tile to the Environment Summary resource

Each tile represents a set of entities. When you create a custom tile, you define the set of entities that the tile represents. In Basic Mode, you can select locations, groups, and entity types to define the set. Optionally, you can go into Advanced Mode and use SWQL (SolarWinds Query Language) to filter by other properties.

  1. Click the + icon in the position where you want to add the file.

    The Add Status Tile dialog box opens.

  2. Enter a Title to identify the tile contents.
  3. In the Site Filter box, select one or more SolarWinds Sites to include entities from only those sites.

    To display entities from all enabled sites, leave all sites unselected.

  4. To filter by group membership, select the groups to include in the Group Filter box.
  5. In the Entity Filter, select one or more entity types to include.
  6. (Optional) To use SWQL to further refine the tile definition:
    1. Click Advanced Mode.

      The Edit Status Tile dialog box displays SWQL queries based on the selections you made in Basic Mode.

      If you did not make any selections in Basic Mode, the SWQL query boxes are empty. SolarWinds recommends making some selections in Basic Mode to generate initial queries that you can modify. To return to Basic Mode, click Basic Mode and then OK at the confirmation message.

    2. Modify the queries.
  7. Click Save.

SWQL queries to define custom tiles

In Advanced Mode, edit the following queries. Each query defines the set of entities that the tile represents, and what information is returned.

Query Description and required columns
SWQL Tile Query

Returns the status information displayed on the tile.

This query must return information from the following columns in the table that stores information about the entity type:

  • Status (the entity status)
  • InstanceSiteId (the ID of the SolarWinds Site where the data originated)
SWQL Asset Explorer Query

Returns the information displayed in the Asset Explorer view when a user clicks a number in the status section of the tile.

This query must return information from the following columns in the table that stores information about the entity type:

  • Status (the entity status)
  • DisplayName (the entity display name)
  • SiteName (the name of the SolarWinds site where the data originated)
  • InstanceSiteId (the ID of the SolarWinds Site where the data originated)
  • DetailsUrl (the URL of the details page for the entity)
  • Entity (the entity name)
SWQL Alert Query

Returns the list of alerts displayed on the tile.

This query must return information from the following columns in the Orion.AlertActive table:

  • Name (the alert name)
  • Priority (the alert priority, used to order the alerts)

  • InstanceSiteId (the ID of the SolarWinds Site where the data originated)

The following sections provide examples of custom tile queries.

Example 1: Filter entities by vendor and SolarWinds Site

The tile displays information about entities with the vendor "Windows" from one SolarWinds Site.

SWQL Tile Query

SELECT Status, InstanceSiteId FROM Orion.Nodes (nolock=true) WHERE 
Vendor='Windows' AND InstanceSiteId IN(1)

SWQL Asset Explorer Query

SELECT e.Status, e.DisplayName, e.OrionSite.Name as SiteName, 
e.InstanceSiteId, e.DetailsUrl, e.InstanceType as Entity FROM 
Orion.Nodes (nolock=true) e WHERE Vendor='Windows' AND InstanceSiteId IN(1)

SWQL Alert Query

SELECT c.Name, CASE WHEN c.Severity = 4 THEN 0 WHEN c.Severity = 0 THEN 1 
WHEN c.Severity = 1 THEN 2 WHEN c.Severity = 3 THEN 3 WHEN c.Severity = 2 
THEN 4 
END as Priority, a.InstanceSiteId
  FROM Orion.AlertActive (nolock=true) a
    INNER JOIN Orion.AlertObjects (nolock=true) AS o 
      ON o.AlertObjectID = a.AlertObjectID 
      AND o.InstanceSiteId = a.InstanceSiteId
    INNER JOIN Orion.AlertConfigurations (nolock=true) AS c 
      ON o.AlertID = c.AlertID 
      AND o.InstanceSiteId = c.InstanceSiteId
    INNER JOIN Orion.Nodes (nolock=true) AS n ON n.Uri = o.EntityUri
  WHERE n.Vendor='Windows' AND n.InstanceSiteId IN(1)

Example 2: Filter entities by custom property and sites

The tile displays information about entities with a custom property of "Critical" from two SolarWinds Sites.

SWQL Tile Query

SELECT Status, InstanceSiteId FROM Orion.NPM.Interfaces (nolock=true) 
WHERE Interfaces.CustomProperties.Comments='Critical' 
AND InstanceSiteId IN(1, 2)

SWQL Asset Explorer Query

SELECT e.Status, e.DisplayName, e.OrionSite.Name as SiteName, 
e.InstanceSiteId, e.DetailsUrl, e.InstanceType as Entity 
FROM Orion.NPM.Interfaces (nolock=true) e 
WHERE e .CustomProperties.Comments='Critical' 
AND e.InstanceSiteId IN(1, 2)

SWQL Alert Query

SELECT c.Name, CASE WHEN c.Severity = 4 THEN 0 WHEN c.Severity = 0 THEN 1 
WHEN c.Severity = 1 THEN 2 WHEN c.Severity = 3 THEN 3 WHEN c.Severity = 2 
THEN 4 
END as Priority, a.InstanceSiteId
  FROM Orion.AlertActive (nolock=true) a
    INNER JOIN Orion.AlertObjects (nolock=true) AS o 
      ON o.AlertObjectID = a.AlertObjectID 
      AND o.InstanceSiteId = a.InstanceSiteId
    INNER JOIN Orion.AlertConfigurations (nolock=true) AS c 
      ON o.AlertID = c.AlertID AND o.InstanceSiteId = c.InstanceSiteId
    INNER JOIN Orion.NPM.Interfaces AS i ON i.Uri = o.EntityUri
    INNER JOIN Orion.NPM.InterfacesCustomProperties AS p 
      ON i.InterfaceID = p.InterfaceID 
      AND i.InstanceSiteId = p.InstanceSiteId
  WHERE p.Comments = 'Critical' AND p.InstanceSiteId IN(1,2)

Example 3: Filter Exchange databases by name and site

The tile displays information about Exchange databases with the server name "LAB-EXCH2013-01" from one SolarWinds Site.

SWQL Tile Query

SELECT Status, InstanceSiteId FROM Orion.APM.Exchange.Database (nolock=true) 
WHERE ServerName = 'LAB-EXCH2013-01' AND InstanceSiteId IN(1)

SWQL Asset Explorer Query

SELECT e.Status, e.DisplayName, e.OrionSite.Name as SiteName, e.InstanceSiteId, 
e.DetailsUrl, e.InstanceType as Entity FROM Orion.APM.Exchange.Database 
(nolock=true) e WHERE ServerName ='LAB-EXCH2013-01' AND InstanceSiteId IN(1)

SWQL Alert Query

SELECT c.Name, CASE WHEN c.Severity = 4 THEN 0 WHEN c.Severity = 0 THEN 1 
WHEN c.Severity = 1 THEN 2 WHEN c.Severity = 3 THEN 3 WHEN c.Severity = 2 
THEN 4 END as Priority, a.InstanceSiteId
  FROM Orion.AlertActive (nolock=true) a
    INNER JOIN Orion.AlertObjects (nolock=true) AS o 
      ON o.AlertObjectID = a.AlertObjectID 
      AND o.InstanceSiteId = a.InstanceSiteId
    INNER JOIN Orion.AlertConfigurations (nolock=true) AS c 
      ON o.AlertID = c.AlertID AND o.InstanceSiteId = c.InstanceSiteId
    INNER JOIN Orion.APM.Exchange.Database (nolock=true) AS d 
      ON d.Uri = o.EntityUri
  WHERE d.ServerName ='LAB-EXCH2013-01' AND d.InstanceSiteId IN(1)

Example 4: Filter entities by vendor and machine type from all sites

The tile displays information about entities with the vendor "Cisco" and machine type "Cisco 3725" from all SolarWinds Sites.

SWQL Tile Query

SELECT Status, InstanceSiteId FROM Orion.Nodes (nolock=true) 
WHERE Vendor='Cisco' AND MachineType='Cisco 3725'

SWQL Asset Explorer Query

SELECT e.Status, e.DisplayName, e.OrionSite.Name as SiteName, e.InstanceSiteId, 
e.DetailsUrl, e.InstanceType as Entity FROM Orion.Nodes (nolock=true) e 
WHERE e.Vendor='Cisco' AND e.MachineType='Cisco 3725'

SWQL Alert Query

SELECT c.Name, CASE WHEN c.Severity = 4 THEN 0 WHEN c.Severity = 0 
THEN 1 WHEN c.Severity = 1 THEN 2 WHEN c.Severity = 3 THEN 3 
WHEN c.Severity = 2 THEN 4 END as Priority, a.InstanceSiteId
  FROM Orion.AlertActive (nolock=true) a
    INNER JOIN Orion.AlertObjects (nolock=true) AS o 
      ON o.AlertObjectID = a.AlertObjectID 
      AND o.InstanceSiteId = a.InstanceSiteId
    INNER JOIN Orion.AlertConfigurations (nolock=true) AS c 
      ON o.AlertID = c.AlertID AND o.InstanceSiteId = c.InstanceSiteId
    INNER JOIN Orion.Nodes (nolock=true) AS n ON n.Uri = o.EntityUri
  WHERE n.Vendor='Cisco' AND n.MachineType='Cisco 3725'

Example 5: Filter entities by group membership and display multiple entity types

The tile displays information about entities that are members of the specified group. The entity set includes nodes, applications, components, and volumes.

SWQL Tile Query

SELECT Status, MemberUri, InstanceSiteId FROM Orion.ContainerMembers (nolock=true) 
WHERE ContainerID = '16' AND InstanceSiteId = '1' AND MemberEntityType 
IN('Orion.Nodes','Orion.APM.Component','Orion.APM.Application','Orion.Volumes')

SWQL Asset Explorer Query

SELECT e.Status, e.MemberUri, e.DisplayName, e.OrionSite.Name as SiteName, 
e.InstanceSiteId, e.DetailsUrl, e.MemberEntityType as Entity 
FROM Orion.ContainerMembers (nolock=true) e 
WHERE ContainerID = '16' AND InstanceSiteId = '1' AND MemberEntityType 
IN('Orion.Nodes','Orion.APM.Component','Orion.APM.Application','Orion.Volumes')

SWQL Alert Query

SELECT c.Name, CASE WHEN c.Severity = 4 THEN 0 WHEN c.Severity = 0 THEN 1 
WHEN c.Severity = 1 THEN 2 WHEN c.Severity = 3 THEN 3 WHEN c.Severity = 2 
THEN 4 END as Priority, a.InstanceSiteId, a.AlertActiveID
  FROM Orion.AlertActive (nolock=true) a
    INNER JOIN Orion.AlertObjects (nolock=true) AS o 
      ON o.AlertObjectID = a.AlertObjectID 
      AND o.InstanceSiteId = a.InstanceSiteId
    INNER JOIN Orion.ContainerMembers (nolock=true) AS m 
      ON o.EntityUri = m.MemberUri AND o.InstanceSiteId = m.InstanceSiteId
    INNER JOIN Orion.AlertConfigurations (nolock=true) AS c 
      ON o.AlertID = c.AlertID AND o.InstanceSiteId = c.InstanceSiteId
  WHERE o.EntityType IN('Orion.Nodes','Orion.APM.Component',
  'Orion.APM.Application','Orion.Volumes') AND m.ContainerID = '16' 
  AND m.InstanceSiteId = '1'
Last modified
23:16, 12 Sep 2017

Tags

Classifications

Public