catalog.master_properties (SSISDB Database)

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

Displays the properties of the Integration Services Scale Out Master.

Column name	Data type	Description
property_name	nvarchar(256)	The name of the scale out master property.
property_value	nvarchar(max)	The value of the scale out master property.

Remarks

This view displays a row for each scale out master property. The properties displayed by this view include the following:

Property Name	Description
CLUSTER_LOGDB_SERVER	The SQL Server that log database locates in.
LAST_ONLINE_TIME	The last time when Scale Out Master is online.
MACHINE_IP	The IP of the machine.
MACHINE_NAME	The name of the machine.
MASTER_ADDRESS	The endpoint of Scale Out Master.
MASTER_SERVICE_PORT	The port in the endpoint of Scale Out Master.
SSLCERT_THUMBPRINT	The thumbprint of Scale Out Master certificate.

All members of public database role have read permission for this view.