Returns the specified SQL Server instance.

The response returns information about disk space and other details.

[
  {
    "name": "mySQLServer",
    "uid": "5e6dbff5-5a99-441b-a999-f28265b6c640",
    "endpoint": "467d5f3e13599b70a8f60bcb2808f105.company.com,1433",
    "internalEndpoint": "string",
    "status": "Ready",
    "totalDiskSpaceInMb": 0,
    "availableDiskSpaceInMb": 0,
    "usedDiskSpaceInMb": 0,
    "databaseLimit": 0,
    "pinnedDatabaseLimit": 0,
    "archivedDatabaseStorageUsedInMb": 16316,
    "archivedDatabaseCount": 28,
    "owner": "[email protected]",
    "secured": true,
    "groups": [
        {
            "groupId": "ad422c53-d970-4e90-b50e-c14aa18bb2bd",
            "groupName": "Admin"
        },
        {
            "groupId": "a5d11079-4c73-4863-9de1-0790d316b630",
            "groupName": "Engineering Support"
        }
    ]
  }
]
PropertyDescription
nameName of this SQL Server instance.
uuidUnique ID of this SQL Server instance.
endpointURI of this SQL Server instance.
internalEndpoint"URI of Data Bridge page in the Integration Center?"
statusStatus of this SQL Server instance in cluster. One of Pending, Ready, Creating, Updating, Deleting, Deleted, FailedCreate, FailedUpdate, FailedDelete.
totalDiskSpaceInMbDisk space on this server instance in MB. Defined by licensing agreement.
availableSpaceInMbDisk space available on this server instance in MB.
usedDiskSpaceInMbDisk space used on this server instance in MB.
databaseLimitMaximum number of active databases this server instance will support as defined in the tenant's license agreement.
pinnedDatabaseLimitMaximum number of pinned databases this server instance will support as defined in tenant's license agreement.
archivedDatabaseStorageUsedInMb"total usage of Database Storage in MB."
archivedDatabaseCountNumber of databases archived.
ownerName of the login that owns this server instance. Owner can grant access to one or more groups.
securedIf true, the server is secured and access is restricted based on group membership.
groupsThe groupId and groupName of the group that can access to this server.

🍐

Role-based Permissions

To perform this operation, a principal must belong to a group that has been assigned the appropriate role-based permissions. The table identifies the roles with permission to perform this operation.

ConsumerContributorData Bridge Admin
YESYESNO

To learn more about role-based permissions in Data Bridge, see Access Controls.

Language
URL