Use Microsoft Azure with Automation
The Microsoft Azure integration with Automation is only available to Jira Service Management Cloud customers on Premium or Enterprise plans. Find out how to upgrade your plan.
You can connect your Microsoft Azure account with your project to automate the process of managing the code delivery process.
To use these actions, you need to connect the Microsoft Azure app to Atlassian Automation. For most of the automation actions, you’ll get a connection setup message when you select them. Once the connection is established, you can automate actions and set up triggers based on Microsoft Azure events.
Before you begin
To manage project automations, you must have the appropriate project permissions:
Company-managed projects: You’ll need the Administer projects and Browse projects permissions for your project. Learn more about permissions for company-managed projects
Team-managed projects: You’ll need Administrator access for your project. Learn more about permissions for team-managed projects
To manage global automations, you’ll need the Administer Jira permission. Learn more about global permissions in Jira Cloud.
Actions
Microsoft Azure Managed Storage
Revoke access from disk in Azure Managed Storage
You can use this action to remove temporary access to a managed disk in Azure Managed Storage.
Enter the following fields or select using smart values:
Disk name: Enter the name of the managed disk.
Resource group name: Enter the name of the resource group containing the disk.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Get disk information from Azure Managed Storage
You can use this action to retrieve details for a specific managed disk in Azure Managed Storage.
Enter the following fields or select using smart values:
Disk name: Enter the name of the managed disk.
Resource group name: Enter the name of the resource group containing the disk.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Delete disk from Azure Managed Storage
You can use this action to delete a managed disk from Azure Managed Storage.
Enter the following fields or select using smart values:
Disk name: Enter the name of the managed disk.
Resource group name: Enter the name of the resource group containing the disk.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Update disk size in Azure Managed Storage
You can use this action to increase the size of a managed disk in Azure Managed Storage.
Enter the following fields or select using smart values:
Disk name: Enter the name of the managed disk.
Resource group name: Enter the name of the resource group containing the disk.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Disk size (GB): Enter the new disk size in GB.
Grant access to disk in Azure Managed Storage
You can use this action to grant temporary access to a managed disk in Azure Managed Storage.
Enter the following fields or select using smart values:
Disk name: Enter the name of the managed disk.
Resource group name: Enter the name of the resource group containing the disk.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Duration (seconds): Enter the duration in seconds for access.
Access level: Select the access level (read or write).
Get all disks via subscription ID in Azure Managed Storage
You can use this action to list all managed disks in a subscription in Azure Managed Storage.
Enter the following fields or select using smart values:
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Get all disks via resource group in Azure Managed Storage
You can use this action to list all managed disks in a resource group in Azure Managed Storage.
Enter the following fields or select using smart values:
Resource group name: Enter the name of the resource group.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Get snapshot data from Azure Managed Storage
You can use this action to retrieve details for a specific disk snapshot in Azure Managed Storage.
Enter the following fields or select using smart values:
Snapshot name: Enter the name of the disk snapshot.
Resource group name: Enter the name of the resource group containing the snapshot.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Update snapshot size in Azure Managed Storage
You can use this action to increase the size of a disk snapshot in Azure Managed Storage.
Enter the following fields or select using smart values:
Snapshot name: Enter the name of the disk snapshot.
Resource group name: Enter the name of the resource group containing the snapshot.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Disk size (GB): Enter the new snapshot size in GB.
Microsoft Azure Virtual Network
Get public IP address from Azure Virtual Network
You can use this action to get a public IP address from Azure Virtual Network.
Enter the following fields or select using smart values:
Public IP address name: Enter the name of the public IP address resource.
Resource group name: Enter the name of the resource group containing the public IP address.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Expand: Enter a comma-separated list of additional properties to expand in the response.
Delete IP address from Azure Virtual Network
You can use this action to delete a public IP address from Azure Virtual Network.
Enter the following fields or select using smart values:
Public IP address name: Enter the name of the public IP address resource.
Resource group name: Enter the name of the resource group containing the public IP address.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Get DDoS protection status from Azure Virtual Network
You can use this action to get DDoS protection status from Azure Virtual Network.
Enter the following fields or select using smart values:
Public IP address name: Enter the name of the public IP address resource.
Resource group name: Enter the name of the resource group containing the public IP address.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Get network interface from Azure Virtual Network
You can use this action to get a network interface from Azure Virtual Network.
Enter the following fields or select using smart values:
Network interface name: Enter the name of the network interface resource.
Resource group name: Enter the name of the resource group containing the network interface.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Expand: Enter a comma-separated list of additional properties to expand in the response.
List all network interfaces in Azure Virtual Network
You can use this action to list all network interfaces in Azure Virtual Network.
Enter the following fields or select using smart values:
Resource group name: Enter the name of the resource group.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Get effective route table from Azure Virtual Network
You can use this action to get the effective route table from Azure Virtual Network.
Enter the following fields or select using smart values:
Network interface name: Enter the name of the network interface resource.
Resource group name: Enter the name of the resource group containing the network interface.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Get virtual network from Azure Virtual Network
You can use this action to get a virtual network from Azure Virtual Network.
Enter the following fields or select using smart values:
Virtual network name: Enter the name of the virtual network resource.
Resource group name: Enter the name of the resource group containing the virtual network.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Expand: Enter a comma-separated list of additional properties to expand in the response.
List virtual networks in Azure Virtual Network
You can use this action to list virtual networks in Azure Virtual Network.
Enter the following fields or select using smart values:
Resource group name: Enter the name of the resource group.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
List all virtual network DDOS status in Azure Virtual Network
You can use this action to list all virtual network DDOS status in Azure Virtual Network.
Enter the following fields or select using smart values:
Virtual network name: Enter the name of the virtual network resource.
Resource group name: Enter the name of the resource group containing the virtual network.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Top: Enter the maximum number of results to return.
Create virtual network in Azure Virtual Network
You can use this action to create a virtual network in Azure Virtual Network.
Enter the following fields or select using smart values:
Virtual network name: Enter the name of the virtual network resource.
Resource group name: Enter the name of the resource group.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Address prefixes: Enter the address prefixes for the virtual network address space.
Location: Enter the Azure region for the virtual network.
Microsoft Azure DevOps Pipelines
Look up run in Azure DevOps Pipelines
You can use this action to get details for a specific pipeline run in Azure DevOps Pipelines.
Enter the following fields or select using smart values:
Organization: Enter the Azure DevOps organization name.
Pipeline ID: Enter the unique identifier of the pipeline.
Project: Enter the name or ID of the Azure DevOps project.
API version: Enter the API version for this operation.
Run ID: Enter the unique identifier of the pipeline run to retrieve.
Look up log in Azure DevOps Pipelines
You can use this action to get a specific log for a pipeline run in Azure DevOps Pipelines.
Enter the following fields or select using smart values:
Log ID: Enter the unique identifier of the log to retrieve.
Organization: Enter the Azure DevOps organization name.
Pipeline ID: Enter the unique identifier of the pipeline.
Project: Enter the name or ID of the Azure DevOps project.
Run ID: Enter the unique identifier of the pipeline run.
API version: Enter the API version for this operation.
Expand: Enter an OData expand expression.
Look up logs in Azure DevOps Pipelines
You can use this action to get all logs for a specific pipeline run in Azure DevOps Pipelines.
Enter the following fields or select using smart values:
Organization: Enter the Azure DevOps organization name.
Pipeline ID: Enter the unique identifier of the pipeline.
Project: Enter the name or ID of the Azure DevOps project.
Run ID: Enter the unique identifier of the pipeline run.
API version: Enter the API version for this operation.
Expand: Enter an OData expand expression.
Look up artifact in Azure DevOps Pipelines
You can use this action to get a specific artifact for a pipeline run in Azure DevOps Pipelines.
Enter the following fields or select using smart values:
Organization: Enter the Azure DevOps organization name.
Pipeline ID: Enter the unique identifier of the pipeline.
Project: Enter the name or ID of the Azure DevOps project.
Run ID: Enter the unique identifier of the pipeline run.
API version: Enter the API version for this operation.
Expand: Enter an OData expand expression.
Artifact name: Enter the name of the artifact to retrieve.
Look up pipeline in Azure DevOps Pipelines
You can use this action to get details for a specific pipeline in Azure DevOps Pipelines.
Enter the following fields or select using smart values:
Organization: Enter the Azure DevOps organization name.
Pipeline ID: Enter the unique identifier of the pipeline to retrieve.
Project: Enter the name or ID of the Azure DevOps project.
API version: Enter the API version for this operation.
Pipeline version: Enter the version of the pipeline to retrieve.
Microsoft Azure DevOps Pipelines
Look up locations in Azure Resource Management
You can use this action to list all available Azure regions and locations for a subscription.Enter the following fields or select using smart values:
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Include extended locations: Select true to include extended locations such as edge zones.
Look up resource groups in Azure Resource Management
You can use this action to list all resource groups within a subscription.
Enter the following fields or select using smart values:
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Filter: Enter an OData filter expression to apply when listing resource groups.
Look up elastic pools in Azure Resource Management
You can use this action to list all elastic pools associated with a SQL server.
Enter the following fields or select using smart values:
Resource group name: Enter the name of the resource group containing the SQL server.
Subscription ID: Enter the Azure subscription ID.
API version: Enter the API version for this operation.
Server name: Enter the name of the SQL server.
Microsoft Azure DevOps
Look up teams in Microsoft Azure DevOps
You can use this action to get a list of teams in your Azure DevOps organization.
Enter the following fields or select using smart values:
Organization name: Enter the name of your Azure DevOps organization.
Your teams: Select to return only teams you belong to.
Include identity: Select to include detailed identity information for each team.
API version: Enter the Azure DevOps API version.
Look up teams in a project in Microsoft Azure DevOps
You can use this action to get teams within a specific Azure DevOps project.
Enter the following fields or select using smart values:
Organization name: Enter the name of your Azure DevOps organization.
Project ID or name: Enter the project ID or name.
Your teams: Select to return only teams you belong to.
Include identity; Select to include detailed identity information for each team.
API version: Enter the Azure DevOps API version.
Look up projects in Microsoft Azure DevOps
You can use this action to get a list of projects in your Azure DevOps organization.
Enter the following fields or select using smart values:
Organization name: Enter the name of your Azure DevOps organization.
Filter by state: Filter projects by state, such as wellFormed, new, or all.
Include default team image URL: Select to include the default team image URL for each project.
API version: Enter the Azure DevOps API version.
Look up work items in Microsoft Azure DevOps
You can use this action to get work items in your Azure DevOps organization and project.
Enter the following fields or select using smart values:
Organization name: Enter the name of your Azure DevOps organization.
Project name or ID: Enter the project name or ID.
Work item IDs: Enter work item IDs, separated by commas (for example, 123,456,789).
Fields: List the fields to return for each work item (optional). For example, System.Title, System.State.
Expand parameters: Specify expand parameters if you want additional details (optional).
API version: Enter the Azure DevOps API version.
Look up work item data in Microsoft Azure DevOps
You can use this action to get detailed data for specific work items.
Enter the following fields or select using smart values:
Organization name: Enter the name of your Azure DevOps organization.
Work item IDs: Enter work item IDs, separated by commas (for example, 123,456,789).
Fields: List the fields to return for each work item (optional).
Expand parameters: Specify expand parameters if you want additional details (optional).
Project name or ID: Enter the project name or ID (optional).
API version: Enter the Azure DevOps API version.
Get work item categories from Microsoft Azure DevOps
You can use this action to get work item categories for a specific project in your Azure DevOps organization.
Enter the following fields or select using smart values:
Organization name: Enter the name of your Azure DevOps organization.
Project name or ID: Enter the project name or ID.
API version: Enter the Azure DevOps API version.
Get work item types from Microsoft Azure DevOps
You can use this action to get work item types for a specific project in your Azure DevOps organization.
Enter the following fields or select using smart values:
Organization name: Enter the name of your Azure DevOps organization.
Project name or ID: Enter the project name or ID.
API version: Enter the Azure DevOps API version.
Transition work items in Azure DevOps
You can use this action to transition one or more work items in Azure DevOps to a new state or status.
Enter the following fields or select using smart values:
Organization: Enter the Azure DevOps organization name.
API version: Enter the Azure DevOps REST API version.
Work item IDs: Enter comma-separated work item IDs to transition.
Action: Enter the action to perform on the work items.
Get relation types from Azure DevOps
You can use this action to get all work item relation types available in Azure DevOps.
Enter the following fields or select using smart values:
Organization: Enter the Azure DevOps organization name.
API version: Enter the Azure DevOps REST API version.
Get editable fields from Azure DevOps
You can use this action to get editable fields for a project in Azure DevOps.
Enter the following fields or select using smart values:
Organization: Enter the Azure DevOps organization name.
API version: Enter the Azure DevOps REST API version.
Project name or ID: Enter the project name or ID.
Expand options: Enter expand options (None or Fields).
Get processes from Azure DevOps
You can use this action to get all processes in Azure DevOps.
Enter the following fields or select using smart values:
Organization: Enter the Azure DevOps organization name.
API version: Enter the Azure DevOps REST API version.
Expand options: Enter expand options (None or Properties).
Query Azure DevOps by ID
You can use this action to query work items by saved query ID in Azure DevOps.
Enter the following fields or select using smart values:
Organization: Enter the Azure DevOps organization name.
API version: Enter the Azure DevOps REST API version.
Query ID: Enter the saved query ID.
Project name or ID: Enter the project name or ID.
Team name: Enter the team name.
Top (max results): Enter the maximum number of work items to return.
Time precision: Enter true or false to use time precision.
Query Azure DevOps by WIQL
You can use this action to query work items using a WIQL query in Azure DevOps.
Enter the following fields or select using smart values:
Organization: Enter the Azure DevOps organization name.
API version: Enter the Azure DevOps REST API version.
Project name or ID: Enter the project name or ID.
Team: Enter the team name.
Top (max results): Enter the maximum number of work items to return.
Time precision: Enter true or false to use time precision.
WIQL query: Enter the WIQL query string.
Get work item states from Azure DevOps
You can use this action to get all work item states for a project and type in Azure DevOps.
Enter the following fields or select using smart values:
Organization: Enter the Azure DevOps organization name.
API version: Enter the Azure DevOps REST API version.
Project name or ID: Enter the project name or ID.
Work item type: Enter the work item type.
Get work item type fields from Azure DevOps
You can use this action to get all fields for a work item type in Azure DevOps.
Enter the following fields or select using smart values:
Organization: Enter the Azure DevOps organization name.
API version: Enter the Azure DevOps REST API version.
Project name or ID: Enter the project name or ID.
Work item type: Enter the work item type.
Expand options: Enter expand options (None or Fields).
Get Azure async response
You can use this action to get the final response from an Azure asynchronous operation. Use it to poll the URL returned in the Location header and retrieve the result of a long-running Azure request.
Enter the following fields or select using smart values:
Location: Enter the URL from the Azure
Locationheader that points to the async operation result.
Microsoft Azure Blob Storage Spoke
Create Azure blob container
You can use this action to create a new container in an Azure Blob Storage account. Use it to organize and store blobs for your applications or services.
Enter the following fields or select using smart values:
Storage account name
Enter the name of the Azure Storage account (for example,myaccount). This is the account where the container will be created.Container name
Enter the name of the container to create. Use only lowercase letters, numbers, and hyphens. The name must start with a letter or number and be 3–63 characters long.Public access
Select the public access level for this container. Choosecontainerfor full public read access to the container and its blobs, orblobto allow public read access only to individual blobs.Default encryption scope
Enter the encryption scope to set as the default for this container. Use this to control how blobs in the container are encrypted.Deny encryption scope override
Select whether blobs in this container must always use the default encryption scope. Turn this on to prevent blobs from using a different scope.
Get Azure blob
You can use this action to get a blob from Azure Blob Storage. Use it to retrieve the latest or a specific version of a blob.
Instruction
Enter the following fields or select using smart values:
Storage account name
Enter the name of the Azure Storage account (for example,myaccount). This is the account that holds the blob.Container name
Enter the name of the blob container. This is the container where the blob is stored.Blob name
Enter the name of the blob to retrieve. Use the exact name of the blob in the container.Snapshot
Enter the snapshot DateTime value for the specific blob snapshot to retrieve. Use this when you want a point‑in‑time copy.Version ID
Enter the version DateTime value for the specific blob version to retrieve. Use this when versioning is enabled.
You can use either a snapshot or a version ID to get a specific copy of the blob. Leave both empty to get the latest version.
List Azure blobs
You can use this action to list blobs in an Azure Blob Storage container. Use it to explore or audit blobs in a single container.
Enter the following fields or select using smart values:
Storage account name
Enter the name of the Azure Storage account. This is the account that holds the container.Container name
Enter the name of the blob container. This is the container you want to list blobs from.Prefix
Enter a prefix to return only blobs whose names start with this value. Use this to narrow the list to related blobs.Delimiter
Enter a delimiter character to group blobs into a virtual folder hierarchy. Use this when you want to simulate folder‑like views.Marker
Enter the marker value from a previous response to continue listing from where it left off. Use this for paging through large result sets.Max results
Enter the maximum number of blobs to return (1–5000). Use this to control response size and performance.Include
Enter a comma‑separated list of extra datasets to include, such assnapshots,metadata,tags, orversions. Use this to enrich the results with more details.Timeout
Enter the timeout value in seconds for this request. Use this to control how long the operation can run before timing out.
You can use the marker from a previous run to paginate results and adjust max results (up to 5000) to control response size.
Delete Azure blob
You can use this action to delete a blob from Azure Blob Storage. Use it to remove blobs, specific snapshots, or versions you no longer need.
Enter the following fields or select using smart values:
Storage account name
Enter the name of the Azure Storage account (for example,myaccount). This is the account that holds the blob.Container name
Enter the name of the blob container. This is the container where the blob is stored.Blob name
Enter the name of the blob to delete. Use the exact name of the blob in the container.Snapshot
Enter the snapshot DateTime value of the blob snapshot to delete. Use this when you need to delete a specific snapshot.Version ID
Enter the version DateTime value of the blob version to delete. Use this when you need to delete a specific version.Delete type
Enterpermanentto permanently delete a previously soft‑deleted snapshot or version. Use this to remove soft‑deleted data for good.Delete snapshots
Enterincludeto delete the base blob and all snapshots, oronlyto delete only snapshots. Use this when the blob has snapshots and you want to control what’s removed.Lease ID
Enter the active lease ID if the blob currently has a lease. This is required only when the blob is leased.
If the blob has snapshots, set Delete snapshots to include to delete everything or only to delete just the snapshots.
Microsoft Security Response Center Spoke
List Microsoft security updates
You can use this action to list Microsoft security updates from the MSRC CVRF API. Use it to get the latest security bulletins and related CVEs.
Instruction
Enter the following fields or select using smart values:
No input fields
This action doesn’t require any input. Run it to retrieve the latest available security updates.
Get Microsoft security update
You can use this action to get details for a specific Microsoft security update from the MSRC CVRF API. Use it to see in‑depth information about a particular update or CVE.
Instruction
Enter the following fields or select using smart values:
Update ID
Enter the ID of the security update to retrieve, such as a monthly identifier (for example,2024-Jan) or a specific CVE (for example,CVE-2024-12345). This identifies which update’s details to fetch.
You can use a monthly update ID (for example, 2024-Jan) or a specific CVE ID to get its full details.
Microsoft Azure Traffic Manager Spoke
Get Azure Traffic Manager profile
You can use this action to get a Traffic Manager profile in Microsoft Azure. Use it to review routing settings and endpoints for that profile.
Enter the following fields or select using smart values:
Subscription ID
Enter the ID of the target Azure subscription. This identifies where the profile is hosted.Resource group name
Enter the name of the resource group that contains the Traffic Manager profile. This narrows the lookup to a specific group.Profile name
Enter the name of the Traffic Manager profile to retrieve. This is the profile whose details you want to view.
Get Azure Traffic Manager endpoint
You can use this action to get a Traffic Manager endpoint in Microsoft Azure. Use it to check configuration and health for a specific endpoint.
Enter the following fields or select using smart values:
Subscription ID
Enter the ID of the target Azure subscription. This identifies where the endpoint is configured.Resource group name
Enter the name of the resource group that contains the Traffic Manager profile. This helps locate the correct profile.Profile name
Enter the name of the Traffic Manager profile. This is the profile that owns the endpoint.Endpoint type
Enter the type of Traffic Manager endpoint, such asAzureEndpoints,ExternalEndpoints, orNestedEndpoints. Match the type used in Azure.Endpoint name
Enter the name of the Traffic Manager endpoint to retrieve. This is the specific endpoint whose details you need.
Delete Azure Traffic Manager endpoint
You can use this action to delete a Traffic Manager endpoint in Microsoft Azure. Use it to remove endpoints that are no longer in use.
Enter the following fields or select using smart values:
Subscription ID
Enter the ID of the target Azure subscription. This identifies where the endpoint is configured.Resource group name
Enter the name of the resource group that contains the Traffic Manager profile. This helps locate the profile.Profile name
Enter the name of the Traffic Manager profile. This is the profile that owns the endpoint.Endpoint type
Enter the type of Traffic Manager endpoint. Use the same type as defined in Azure (for example,AzureEndpoints).Endpoint name
Enter the name of the Traffic Manager endpoint to delete. Make sure no traffic should be routed through this endpoint before you remove it.
Microsoft Azure Artifacts Spoke
Create Azure Artifacts feed
You can use this action to create a new package feed in Azure Artifacts. Use it to set up a feed at the organization or project level.
Enter the following fields or select using smart values:
Organization
Enter the name of the Azure DevOps organization. This is the organization where the feed will live.Project
Enter the project ID or project name if you want the feed scoped to a specific project. Leave this empty to create the feed at the organization level.Feed name
Enter a name for the feed, up to 64 characters, with no whitespace or illegal characters. Use a short, unique name such asteam-libsorwebapp-packages.Description
Enter a description for the feed, up to 255 characters. Use this to explain what the feed is for or which teams use it.Badges enabled
Select whether this feed can generate package badges. Turn this on if you plan to display package status in README files or dashboards.Hide deleted package versions
Select whether to hide deleted or unpublished package versions. Turn this on to keep the feed view clean for consumers.Upstream enabled
Select whether this feed can fetch packages from upstream sources. Turn this on when you want to cache or mirror external feeds.
Get Azure Artifacts feed
You can use this action to get the settings for a specific feed in Azure Artifacts. Use it to inspect configuration details for one feed.
Enter the following fields or select using smart values:
Organization
Enter the name of the Azure DevOps organization. This identifies where the feed is located.Project
Enter the project ID or project name if the feed is created in a specific project. Leave this empty if the feed is at the organization level.Feed ID
Enter the name or ID of the feed to retrieve. This is the feed whose configuration you want to review.
Microsoft Azure SQL Database Spoke
Create Azure SQL database
You can use this action to create or update a Microsoft Azure SQL database. Use it to provision a new database or change the SKU and settings of an existing one.
Enter the following fields or select using smart values:
Database name
Enter the name of the Azure SQL database. Use a clear, unique name that matches your naming standards.Resource group name
Enter the Azure resource group that contains the SQL server. This is where the database resource will be managed.Server name
Enter the name of the Azure SQL server that will host the database. This must be an existing SQL server.Subscription ID
Enter the Azure subscription ID for this database. This defines where billing and governance apply.API version
Enter the Azure REST API version to use for this request. You can use the default Azure SQL Database API version or match the version used by your existing deployments.Location
Enter the Azure region for the database (for example,eastusorwestus2). Choose a region close to your users or services.SKU name
Enter the Azure SQL SKU name (for example,GP_Gen5_2,S0, orBasic). This defines the performance level.SKU tier
Enter the Azure SQL SKU tier (for example,GeneralPurpose,Standard, orBasic). This sets the overall service tier.SKU capacity
Enter the compute capacity for the SKU, such as the number of vCores. Use this to size the database for your workload.
Get Azure SQL database
You can use this action to get details for a specific Microsoft Azure SQL database. Use it to review configuration, status, and related resources.
Enter the following fields or select using smart values:
Database name
Enter the name of the Azure SQL database to look up. This is the database whose details you want.Resource group name
Enter the Azure resource group that contains the SQL server. This narrows the search to the right group.Server name
Enter the name of the Azure SQL server that hosts the database. This identifies the server to query.Subscription ID
Enter the Azure subscription ID for this database. This specifies the subscription where the database resides.API version
Enter the Azure REST API version to use for this request. Use a version that’s supported by your environment.Expand
Enter any child resources to include in the response. Use this when you want related resources returned alongside the database.Filter
Enter an OData filter expression to narrow the results. You can use filters to limit the data returned based on status or properties.
List Azure SQL server databases
You can use this action to list all Microsoft Azure SQL databases on a specific server. Use it to audit databases or discover what’s running on a server.
Enter the following fields or select using smart values:
Resource group name
Enter the Azure resource group that contains the SQL server. This is where the server resource is managed.Server name
Enter the name of the Azure SQL server to query. This is the server whose databases you want to list.Subscription ID
Enter the Azure subscription ID for this server. This identifies the subscription that owns the server.API version
Enter the Azure REST API version to use for this request. Use a current, supported version.
List Azure SQL pool databases
You can use this action to list all Microsoft Azure SQL databases in an elastic pool. Use it to see which databases share a pool’s resources.
Enter the following fields or select using smart values:
Elastic pool name
Enter the name of the Azure SQL elastic pool. This is the pool whose databases you want to list.Resource group name
Enter the Azure resource group that contains the elastic pool. This helps locate the pool.Server name
Enter the name of the Azure SQL server that hosts the elastic pool. This identifies where the pool is running.Subscription ID
Enter the Azure subscription ID for this elastic pool. This specifies the subscription that owns the resource.API version
Enter the Azure REST API version to use for this request. Use a supported version for Azure SQL.
Pause Azure SQL database
You can use this action to pause a Microsoft Azure SQL database. Use it to temporarily stop compute while keeping data stored.
Enter the following fields or select using smart values:
Database name
Enter the name of the Azure SQL database to pause. This is the database whose compute you want to stop.Resource group name
Enter the Azure resource group that contains the SQL server. This identifies where the server is managed.Server name
Enter the name of the Azure SQL server that hosts the database. This points to the server to operate on.Subscription ID
Enter the Azure subscription ID for this database. This specifies the subscription where the database resides.API version
Enter the Azure REST API version to use for this request. Use a version that supports pause operations.
Resume Azure SQL database
You can use this action to resume a paused Microsoft Azure SQL database. Use it to bring a database back online after a pause.
Enter the following fields or select using smart values:
Database name
Enter the name of the Azure SQL database to resume. This is the database you want to start again.Resource group name
Enter the Azure resource group that contains the SQL server. This identifies where the server is managed.Server name
Enter the name of the Azure SQL server that hosts the database. This points to the server to operate on.Subscription ID
Enter the Azure subscription ID for this database. This specifies the subscription where the database resides.API version
Enter the Azure REST API version to use for this request. Use a version that supports resume operations.
Fail over Azure SQL database
You can use this action to fail over a Microsoft Azure SQL database. Use it to switch the database to another replica for continuity or maintenance.
Enter the following fields or select using smart values:
Database name
Enter the name of the Azure SQL database to fail over. This is the database you want to move to another replica.Resource group name
Enter the Azure resource group that contains the SQL server. This identifies where the server is managed.Server name
Enter the name of the Azure SQL server that hosts the database. This is the server participating in the failover.Subscription ID
Enter the Azure subscription ID for this database. This specifies the subscription where the database resides.API version
Enter the Azure REST API version to use for this request. Use a version that supports failover operations.Replica type
Select the type of replica to fail over to, such asPrimaryorReadableSecondary. ChoosePrimaryfor a primary failover orReadableSecondaryto fail over to a readable secondary, depending on your setup.
Was this helpful?