SQL Monitor 11

Exported Variables

A number of useful variables are exported by the PowerShell Module to aid in script writing.

AlertTypes

Dictionary converting the alert name to alert type. Contains all applicable alert types to SQL Monitor.

ClusterAlertTypes

Dictionary converting the alert name to alert type. Contains alert types that are applicable to configure at the cluster level.

StandaloneMachineAlertTypes

Dictionary converting the alert name to alert type. Contains alert types that are applicable to configure at the standalone machine level.  Equivalent to ClusterAlertTypes.

ClusterMachineAlertTypes

Dictionary converting the alert name to alert type. Contains alert types that are applicable to configure at the cluster machine level.

DatabaseAlertTypes

Dictionary converting the alert name to alert type. Contains alert types that are applicable to configure at the database level.

DiskAlertTypes

Dictionary converting the alert name to alert type. Contains alert types that are applicable to configure at the disk level.

JobAlertTypes

Dictionary converting the alert name to alert type. Contains alert types that are applicable to configure at the job level.

InstanceAlertTypes

Dictionary converting the alert name to alert type. Contains alert types that are applicable to configure at the instance level.

AgAlertTypes

Dictionary converting the alert name to alert type. Contains alert types that are applicable to configure at the availability group level.

AzureSqlServerAlertTypes

Dictionary converting the alert name to alert type. Contains alert types that are applicable to configure at the Azure SQL Server level.

AzureSqlDatabaseAlertTypes

Dictionary converting the alert name to alert type. Contains alert types that are applicable to configure at the Azure SQL Database level.

ElasticPoolAlertTypes

Dictionary converting the alert name to alert type. Contains alert types that are applicable to configure at the Azure Elastic Pool level.


Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?