Skip to content

mssqlDatabases

Paginated list of Microsoft SQL Databases.

Arguments

Argument Type Description
first Int Returns the first n elements from the list.
after String Returns the elements in the list that occur after the specified cursor.
sortBy HierarchySortByField Sort hierarchy objects according to the hierarchy field.
sortOrder SortOrder Sorts the order of results.
filter [Filter!] Hierarchy object filter.

Returns

MssqlDatabaseConnection!

Sample

query {
  mssqlDatabases(first: 10) {
    nodes {
      authorizedOperations
      cdmId
      cdmLink
      cdmOnDemandSnapshotCount
      cdmPendingObjectPauseAssignment
      copyOnly
      dagId
      hasLogConfigFromSla
      hasPermissions
      hostLogRetention
      id
      isInAvailabilityGroup
      isLogShippingSecondary
      isMount
      isOnline
      isRelic
      isReplica
      logBackupFrequencyInSeconds
      logBackupRetentionInHours
      name
      numWorkloadDescendants
      objectType
      onDemandSnapshotCount
      postBackupScript
      preBackupScript
      recoveryModel
      replicatedObjectCount
      slaAssignment
      slaPauseStatus
      unprotectableReasons
      version
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}

{}

{
  "data": {
    "mssqlDatabases": {
      "nodes": [
        [
          {
            "authorizedOperations": [
              "ACCESS_CDM_CLUSTER"
            ],
            "cdmId": "example-string",
            "cdmLink": "example-string",
            "cdmOnDemandSnapshotCount": 0,
            "cdmPendingObjectPauseAssignment": "NO_PENDING_PAUSE_ASSIGNMENT",
            "copyOnly": true
          }
        ]
      ],
      "pageInfo": {
        "endCursor": "example-string",
        "hasNextPage": true,
        "hasPreviousPage": true,
        "startCursor": "example-string"
      }
    }
  }
}