---
title: "List all SQL availability groups"
method: GET
path: "/sqlserver/v1/orgs/{OrgID}/reports/availabilitygroup"
tags: ["SQLServer"]
---

# List all SQL availability groups

`GET /sqlserver/v1/orgs/{OrgID}/reports/availabilitygroup`

## Request

- Base URL: `//apis.druva.com/phoenix` (relative, and the document’s source URL is not known)
- URL: `//apis.druva.com/phoenix/sqlserver/v1/orgs/{OrgID}/reports/availabilitygroup`
- Auth: API key in header `Authorization`

Returns all SQL availability groups.

## Path parameters

- `OrgID` integer, required

## Query parameters

- `agID` integer
- `resourceName` string
- `resourceType` string
- `pageToken` string

## Response `200`

Success

- SQLListSQLAvailabilityGroupResponse: ListSQLResourceResponse is the response schema for ListSQLAvailabilityGroup
  - `availabilityGroups` SQLResourceResponse[]
    - `administrativeGroupName` string: The name of the resource group the SQL instance is a part of.
    - `agID` integer: The ID of the availability group.
    - `configurationStatus` boolean: The status indicating whether the SQL resource is configured for backup.
    - `organizationName` string: The name of the organization the SQL instance is a part of.
    - `resourceName` string: The name of the SQL resource.
    - `resourceType` string: The type of the SQL resource.
    - `serverName` string[]: The name of the Windows or Linux server the SQL instance is a part of.
    - `sqlServerVersion` string: The version of the SQL resource.
  - `nextPageToken` string: The token to access the next page of results. This parameter will be empty for the last page of results.

## Other responses

- `400`: Bad Request
- `404`: The requested resource was not found.
- `500`: The request was not processed due to an internal error in the Cloud.

---

[API](https://skmtc.dev/druva/apis/enterprise-workloads.md) - [All operations](https://skmtc.dev/druva/apis/enterprise-workloads/llms.txt) - [OpenAPI document](https://skmtc.dev/druva/apis/enterprise-workloads/revisions/18fc75e8229e?raw)