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. |
Permissions
All members of public database role have read permission for this view.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for