Modern Dashboard Node down widget

Question

I have created KPI widget showing Nodes status. When I click on Nodes down widget it should redirect me to the page where showing nodes down status but unfortunately it doesn't.

Need expert advice , an SWQL query for this will be great help.

Ramsundar · Answer

You can use Widget url to redirect to the alert page or NPm summary page.

tony.johnson · Answer

This is possible with some database work. It is possible to add additional elements to the JSON configuration of the widget to define the link for each cell.

Here is an example widget configuration

{
    "header": {
        "properties": {
            "title": "KPI Link",
            "subtitle": "",
            "url": "",
            "description": "",
            "collapsible": false,
            "collapsed": true
        }
    },
    "tiles": {
        "properties": {
            "nodes": [
                "kpi_73be5ecc-15e0-45e3-b6aa-8a130d38aa60"
            ]
        }
    },
    "kpi_73be5ecc-15e0-45e3-b6aa-8a130d38aa60": {
        "id": "kpi_73be5ecc-15e0-45e3-b6aa-8a130d38aa60",
        "providers": {
            "dataSource": {
                "providerId": "KpiSwqlDatasourceService",
                "properties": {
                    "swql": "SELECT 2 as Cpu, 'https://www.google.ie' as kpiLink
FROM Orion.Nodes n",
                    "dataFields": [
                        {
                            "id": "Cpu",
                            "label": "Cpu",
                            "dataType": "System.Int32"
                        },
                        {
                            "id": "kpiLink",
                            "label": "kpiLink",
                            "dataType": "System.String"
                        }
                    ],
                    "type": "hand-edit"
                }
            },
            "adapter": {
                "providerId": "NOVA_KPI_DATASOURCE_ADAPTER",
                "properties": {
                    "componentId": "kpi_73be5ecc-15e0-45e3-b6aa-8a130d38aa60",
                    "propertyPath": "widgetData",
                    "dataSource": {
                        "properties": {
                            "swql": "SELECT 2 as Cpu, 'https://www.google.ie' as kpiLink
FROM Orion.Nodes n",
                            "dataFields": [
                                {
                                    "id": "Cpu",
                                    "label": "Cpu",
                                    "dataType": "System.Int32"
                                },
                                {
                                    "id": "kpiLink",
                                    "label": "kpiLink",
                                    "dataType": "System.String"
                                }
                            ],
                            "type": "hand-edit"
                        }
                    },
                    "thresholds": {
                        "criticalThresholdValue": 0,
                        "showThresholds": false,
                        "reversedThresholds": false
                    }
                }
            },
            "kpiColorPrioritizer": {
                "providerId": "NOVA_KPI_COLOR_PRIORITIZER",
                "properties": {
                    "rules": []
                }
            }
        },
        "properties": {
            "configuration": {
                "interactive": true
            },
            "widgetData": {
                "label": "Widget Config Created in DB",
                "backgroundColor": "var(--nui-color-bg-secondary)",
                "units": ""
            }
        }
    },
    "/": {
        "providers": {
            "refresher": {
                "properties": {
                    "enabled": true,
                    "interval": 3600,
                    "overrideDefaultSettings": true
                }
            },
            "interactionHandler": {
                "providerId": "NOVA_URL_INTERACTION_HANDLER",
                "properties": {
                    "url": "${data.rowData.kpiLink}",
                    "newWindow": true
                }
            }
        }
    }
}

To use this, you could create a new dashboard with a new KPI widget. Open your Orion database and look at the widgets table to find the new widget. Update the configuration field with the example above.

I appreciate this is not an ideal solution but it may help for now.