Supported Alert Custom Macros
Customise the alert subject and description with below macros then it will generate alert based on customisation.
| ${resource.name} | ${resource.ip} | ${resource.mac} |
| ${resource.aliasname} | ${resource.os} | ${resource.type} |
| ${resource.dnsname} | ${resource.alternateip} | ${resource.make} |
| ${resource.model} | ${resource.serialnumber} | ${resource.systemId} |
| ${Custome Attributes in the resource} | ${parent.resource.name} |
Resource Filter Input keys
MS SQL Integration’s resources are filtered and discovered based on the following keys.
Note: You can filter the resources with the discoverable keys only.
| Resource Type | Supported Input Key |
|---|---|
| All Types | resourceName |
| hostName | |
| aliasName | |
| dnsName | |
| ipAddress | |
| macAddress | |
| os | |
| make | |
| model | |
| serialNumber | |
| MSSQL Windows Failover Cluster | Configured Nodes Count |
| Owner Node | |
| MSSQL Windows Failover Cluster Node | Root Resource IPAddress |
| Root Resource HostName | |
| Root Resource Name | |
| Root Resource UUID | |
| MSSQL Windows Failover Cluster Role | Root Resource IPAddress |
| Root Resource HostName | |
| Root Resource Name | |
| Root Resource UUID | |
| MSSQL Windows Failover Cluster Storage Disk | Root Resource IPAddress |
| Root Resource HostName | |
| Root Resource Name | |
| Root Resource UUID | |
| MSSQL Cluster Shared Volume | FileSystem |
| FriendlyVolumeName | |
| Owner Node | |
| Root Resource IPAddress | |
| Root Resource HostName | |
| Root Resource Name | |
| Root Resource UUID | |
| MSSQL Server Instance | Port |
| Root Resource IPAddress | |
| Root Resource HostName | |
| Root Resource Name | |
| Root Resource UUID | |
| MSSQL Node | BuildNumber |
| Version | |
| Caption | |
| Hard Disk Size | |
| OSArchitecture | |
| Root Resource IPAddress | |
| Root Resource HostName | |
| Root Resource Name | |
| Root Resource UUID | |
| MSSQL Node Server Instance | Port |
| Root Resource IPAddress | |
| Root Resource HostName | |
| Root Resource Name | |
| Root Resource UUID | |
| MSSQL Server Database | Port |
| Owner Sid | |
| User Access Description | |
| Recovery Model Description | |
| Physical Database Name | |
| Delayed Durability | |
| Root Resource IPAddress | |
| Root Resource HostName | |
| Root Resource Name | |
| Root Resource UUID |