How to create and modify row perspectives

A row perspective can display health state, performance metrics, properties, and SLA information for each object. They work in a similar way to dashboard perspectives in that they are stored in dashboard packs, they use a match criteria that defines which class, group or particular object they apply to, and they have a rank that specifies which row perspective should be displayed when multiple row perspectives match. A row perspective is made up of 'cell tiles' of various types, such as Status, Sparkline, Bar, Health State History etc.

Row perspectives are used by the Matrix tile, Surface tile, VADA analyze mode, and Status Donut drill down pages.

You may like to watch the Dashboard Server webinar -  Matrix Tile Deep Dive.

We recommend you don't edit the provided Dashboard Server row perspectives. A good way to start is by copying the JSON from an existing row perspective and amending as you require.

Where row perspectives are used

Row perspectives in the Matrix tile

Walkthrough: Creating a row perspective

FAQs

Reference

Where row perspectives are used

A row perspective defines the data to be shown, as seen here on the Matrix tile:

And here on VADA analyze view:

Row perspectives in the Matrix tile

When configuring the Matrix tile How to use the Matrix tile) you can choose which row perspective to use in the columns section. When dynamic is selected you can either leave the setting as auto which will automatically use the row perspective with the highest rank, or you can click on the row perspective you want to use. The walkthrough below describes how to add a new row perspective to appear on this list.

Walkthrough: Creating a row perspective

New row perspectives can be created on the SquaredUp server by creating a new a row perspective JSON file. A good way to start is by copying the JSON from an existing perspective and amending as you require.

1. Log on to the SquaredUp server and run Notepad as an administrator.

2. Create a JSON file in the following path in your Dashboard Server folder:

   \User\Packages\Everyone\perspectives\rows

   Where to find the Dashboard Server folder

   Name of the Dashboard Server folder

   The name of the Dashboard Server folder is SquaredUpv followed by the product version number.

   Location of the Dashboard Server folder

   The default location for the Dashboard Server folder is C:\inetpub\wwwroot\SquaredUpv[Version Number], but a custom location may have been chosen during the installation.
   For example, for Dashboard Server v5 the default folder location is C:\inetpub\wwwroot\SquaredUpv5 and for v4 C:\inetpub\wwwroot\SquaredUpv4

3. Below is the JSON configuration template for a row perspective. You can copy this into the JSON file you have created.

   JSON if you are using a SCOM Group ID

   Copy

   {
           "_comment": "My new row perspective",
           "format": "row",
           "id": "NEWGUID",
           "match": {
               "groupIds": "SCOMID",
               "type": "scom/object"
           },
           "name": "My new row perspective",
           "rank": 40,
           "columns": [
               {
                   "_type": "celltile/status",
                   "title": "State"
               },
               {
                   "_type": "celltile/text",
                   "title": "IP Address",
                   "config": {
                       "display": {
                           "contentTemplate": "{{(properties.ipAddress || '').split(',')[0]}}"
                       }
                   }
               },
               {
                   "_type": "celltile/signalstrength",
                   "title": "#CPUs",
                   "config": {
                       "display": {
                           "valueProperty": "properties.logicalProcessors"
                       }
                   }
               },
               {
                   "_type": "celltile/scomperf-as-sparkline",
                   "title": "CPU",
                   "config": {
                       "display": {
                           "height": 30,
                           "width": 120
                      },
                      "source": {
                          "objectname": "Processor Information",
                          "countername": "% Processor Time"
                      }
                   }
               },
               {
                   "_type": "celltile/bar",
                   "title": "Logical Disk Free Space",
                   "config": {
                       "source": {
                           "objectname": "LogicalDisk",
                           "countername": "% Free Space"
                       }
                   }
               }
           ]
       }

   JSON if you are using a SCOM Class ID

   Copy

   {
           "_comment": "My new row perspective",
           "format": "row",
           "id": "NEWGUID",
           "match": {
               "classIds": "SCOMID",
               "type": "scom/object"
           },
           "name": "My new row perspective",
           "rank": 40,
           "columns": [
               {
                   "_type": "celltile/status",
                   "title": "State"
               },
               {
                   "_type": "celltile/text",
                   "title": "IP Address",
                   "config": {
                       "display": {
                           "contentTemplate": "{{(properties.ipAddress || '').split(',')[0]}}"
                       }
                   }
               },
               {
                   "_type": "celltile/signalstrength",
                   "title": "#CPUs",
                   "config": {
                       "display": {
                           "valueProperty": "properties.logicalProcessors"
                       }
                   }
               },
               {
                   "_type": "celltile/scomperf-as-sparkline",
                   "title": "CPU",
                   "config": {
                       "display": {
                           "height": 30,
                           "width": 120
                      },
                      "source": {
                          "objectname": "Processor Information",
                          "countername": "% Processor Time"
                      }
                   }
               },
               {
                   "_type": "celltile/bar",
                   "title": "Logical Disk Free Space",
                   "config": {
                       "source": {
                           "objectname": "LogicalDisk",
                           "countername": "% Free Space"
                       }
                   }
               }
           ]
       }

4. Each row perspective JSON file must use a unique "id". Create a new GUID ready to use for the row perspective. You can do this simply by typing new-guid into PowerShell.

5. Replace NEWGUID with the new GUID you have created.

6. Find the SCOM ID of the group or class you want this row perspective to be displayed for. See How to find the SCOM ID of an object or group.

7. Replace SCOMID with the SCOM ID of the group or class you want this row perspective to be displayed for.
   For example, for the IIS Computer Group:

   

   If you are using a SCOM Group ID:

   Copy

   "match": {
       "groupIds": "603c9394-cbf5-a5d1-be77-45c0d6755902",
       "type": "scom/object"
   },

   If you are using a SCOM Class ID:

   Copy

   "match": {
       "classIds": "603c9394-cbf5-a5d1-be77-45c0d6755902",
       "type": "scom/object"
   },

   
   

8. Save your new JSON file.
9. In Dashboard Server click on the top right-hand menu ☰ > system > dashboards then click the reload button at the bottom of the page.
10. Create or edit a Matrix tile scoped to the group or class specified in your row perspective. See How to use the Matrix tile.

11. In the columns section your new row perspective should be available for you to select. It is the name you put in the _comment that is displayed here.

    

12. You can now edit the row perspective JSON file and re-save as required. See the Reference section at the end of this article and the Matrix tile article (How to use the Matrix tile) for more information about the cell tile options available.

FAQs

How can I edit the drill down page for a Status Donut?

When drilling down on a Donut tile you will see a Matrix tile view. This view uses the highest ranked row perspective defined for the Donut tile scope.

How can I edit the row perspective shown in VADA analyze mode?

The row perspective shown in VADA analyze mode is the highest ranked row perspective defined for the object.

Can I edit the existing row perspectives?

We recommend you don't edit the Dashboard Server perspectives. Instead copy an existing row perspective JSON file and edit as you require. Don't forget to replace the "id" with a new GUID. You can create a new GUID simply by typing new-guid into PowerShell.

Reference