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 SquaredUp DS webinar - Matrix Tile Deep Dive.

We recommend you don't edit the provided SquaredUp DS 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.

Log on to the SquaredUp server and run Notepad as an administrator.
Create a JSON file in the following path in your SquaredUp DS folder:
\User\Packages\Everyone\perspectives\rows
Name of the SquaredUp folder
The default name of the SquaredUp folder is SquaredUp for v6 and above.
For v5 it is SquaredUpv5, and for v4 SquaredUpv4.
Location of the SquaredUp folder
A custom location may have been chosen during the installation.
The default location for the SquaredUp folder is C:\inetpub\wwwroot\SquaredUp
For v5 it is C:\inetpub\wwwroot\SquaredUpv5 and for v4 C:\inetpub\wwwroot\SquaredUpv4.

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

{
        "_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"
                    }
                }
            }
        ]
    }

{
        "_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"
                    }
                }
            }
        ]
    }

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.
Replace NEWGUID with the new GUID you have created.
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.
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:
```
"match": {
    "groupIds": "603c9394-cbf5-a5d1-be77-45c0d6755902",
    "type": "scom/object"
},
```
If you are using a SCOM Class ID:
```
"match": {
    "classIds": "603c9394-cbf5-a5d1-be77-45c0d6755902",
    "type": "scom/object"
},
```
Save your new JSON file.
In SquaredUp DS click on the top right-hand menu ☰ > system > dashboards then click the reload button at the bottom of the page.
Create or edit a Matrix tile scoped to the group or class specified in your row perspective. See How to use the Matrix tile.
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.
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 SquaredUp DS 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

_comment	Provide a unique name which will be seen in the list of row perspectives to choose from when configuring a Matrix tile.
id	Provide a GUID that should be unique to this row perspective. You can generate a new GUID by typing `new-guid` into PowerShell or online here. You should create a new GUID for each row perspective. Altering the existing GUID randomly will not work.
format	row (This property differentiates a row perspective from a regular perspective)
type	scom/object
classIds	ID of the class of objects on which the perspective should apply to. You need to replace this with the ID relevant to you. See How to find the SCOM ID of an object or group.
groupIds	ID of the group of objects on which the perspective should apply to. You need to replace this with the ID relevant to you. See How to find the SCOM ID of an object or group.
name	Unique name for the row perspective
rank	Rank specifies which perspective should be displayed when more than one perspective matches the scoped criteria. 0 is the lowest rank and will be considered the lowest priority. Best practice is to assign numbers with sufficient gap between them (like multiples of 10) so that you can later insert other perspectives of lower ranks in between if you wish to.
columns	Column is an array of cell tile definitions. You need to define cell tiles in the column block. For more information see How to use the Matrix tile

Was this article helpful?

Have more questions or facing an issue?

Submit a ticket