Hi Mark,
The drill-down uses the same row perspective as you will find when scoping databases into a matrix tile. You can edit this file on disk to add the path property to the row.
C:\inetpub\wwwroot\SquaredUpV5\User\Packages\Everyone\perspectives\rows
Where SquaredUpV5 is the name of your deployment (could be SquaredUpv4 if you upgraded).
You’ll notice there are a number of SQL related rows:
Depending on which management pack and dashboard pack you have, it will be one of the ones that contains “database” (if the donut tile is scoped to SQL 2016 Databases, locate the appropriate json file).
The Matrix tile is a collection of cell tiles and each has a specific purpose. The Custom Text Template is what you need and you can use a property SCOM has discovered against the class to add what you need to the view. The property is dependant on which MP you have installed.
To find the property, drilldown into one of the databases, then move to the Monitored Entity Perspective, and locate the property name you require from the list.
In our case, it’s MachineName, though we need to ensure it is added in camelCase, rather than the displayed PascalCase.
So with this in mind, we can add a new text tile at the top of the file, adding our column Title and our Property to be displayed in row.
{
"title": "Path",
"_type": "celltile/text",
"config": {
"display": {
"contentTemplate": "{{properties.machineName}}"
}
}
}
Ensure you’re json is correct with a comma after the block and then save the file.
Alternatively, you can adjust the existing Status tile to show the MachineName: and the DisplayName: - Simply locate the status block in the json file and make your change:
{
"_type": "celltile/status",
"config": {
"display": {
"cellWidth": "30%",
"labelTemplate": "{{properties.machineName}}: {{properties.displayName}}"
}
},
"title": "Status"
}
This should just work, though you may need recycle the SquaredUp application pool for the changes to take effect.
More info on the Matrix tile here: