How to know our current Azure SQL Database resource API version

Question

How to know our current Azure SQL Database resource API version

Ernest Basamot 5

How do I check on our current Azure SQL Database resource API version? We have received an email from Microsoft Azure saying that "Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025" and that we must update to a newer version to avoid any problems.

I've taken a look about this online and found running the script below on Azure Resource Graph Explorer will determine if we have such APIs being used, and that if we received a result of "Query is invalid" like the one indicated on the screenshot below, that would mean that we are not using any Azure SQL database APIs and that the email notification we received can be ignored.

HttpIncomingRequests

| where TIMESTAMP > ago(30d)

| where targetResourceProvider == 'MICROSOFT.SQL'

| where subscriptionId == 'update-this-to-your-subid' //make sure you update this

| where apiVersion == "2014-04-01" or apiVersion == "2014-01-01" or apiVersion == "2014-04-01-preview"

User's image We currently have three subscription IDs and ran the said script on all of them, with all having the same result. Is this already good for us to consider on ignoring the email notification we received from MS Azure?

Mahesh Kurva 5,025 Reputation points Microsoft External Staff Moderator

2024-09-02T07:08:55.2+00:00
Hi @Ernest Basamot,

Welcome to the Microsoft Q&A platform, thanks for posting the question.
As I understand you want to check your current Azure SQL Database resource API version
In addition to @Stanislav Zhelyazkov,

You can try running the following query in Azure Resource Graph Explorer.

Resources | distinct type, apiVersion | where isnotnull(apiVersion)

I tried to repro the scenario by using the above code and successfully retrieved the API.

As suggested, please refer to document: Show API version for each resource type

I hope this information helps. Please do let us know if you have any further queries.
Mahesh Kurva 5,025 Reputation points Microsoft External Staff Moderator

2024-09-03T09:52:54.79+00:00

Hi @Ernest Basamot,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mahesh Kurva 5,025 Reputation points Microsoft External Staff Moderator

2024-09-04T09:30:47.3733333+00:00

Hi @Ernest Basamot,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

2 answers

Your answer

Mahesh Kurva 5,025 Reputation points Microsoft External Staff Moderator

2024-09-02T07:08:55.2+00:00

Hi @Ernest Basamot,

Welcome to the Microsoft Q&A platform, thanks for posting the question.
As I understand you want to check your current Azure SQL Database resource API version
In addition to @Stanislav Zhelyazkov,

You can try running the following query in Azure Resource Graph Explorer.

Resources | distinct type, apiVersion | where isnotnull(apiVersion)

I tried to repro the scenario by using the above code and successfully retrieved the API.

As suggested, please refer to document: Show API version for each resource type

I hope this information helps. Please do let us know if you have any further queries.
Mahesh Kurva 5,025 Reputation points Microsoft External Staff Moderator

2024-09-03T09:52:54.79+00:00

Hi @Ernest Basamot,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mahesh Kurva 5,025 Reputation points Microsoft External Staff Moderator

2024-09-04T09:30:47.3733333+00:00

Hi @Ernest Basamot,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

Hi,

I am not sure from where you've took this query but it seems incorrect to me or at least it is not for Azure Resource Graph. I am not aware of Azure resource graph having table with name HttpIncomingRequests. But back to the questions those APIs versions could be used if you are using automation tools like like Bicep, Azure SDKs, Az PowerShell, Az CLI, Terraform, etc. For most tools you will need to be using some old version of the tool as they do not expose the version directly for you to configure but if you have some Bicep code that code can be configured with that version. So I would check in your organization what tools are being used to automate the deployment of Azure SQL database. If they are too old update them. If you have Bicep you can check directly which API version is used. Most likely the message is general for anyone who has Azure SQL database deployed but it does not necessary says that you are using old API versions.

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

Answer 2

RahulRandive 10,486 Volunteer Moderator

Hi @Ernest Basamot

I believe HttpIncomingRequests is a backend query that can be executed by the support agent.

Below query you can try running in Azure Resource Graph Explorer from Azure portal

resources

| where type == 'Microsoft.Sql/servers/databases'

| project apiVersion

Let me know if this help!

Thank You!

Stanislav Zhelyazkov 28,186 Reputation points MVP Volunteer Moderator

2024-08-31T06:44:32.8666667+00:00

That query is misleading as it does not lists the API version used to create/update resources. This is the API version that Azure Resource Graph uses to get the information from resources in order to put that information in Graph.

"Resource Graph primarily uses the most recent non-preview version of a Resource Provider API to GET resource properties during an update. In some cases, the API version used has been overridden to provide more current or widely used properties in the results. The following query details the API version used for gathering properties on each resource type:"

Source.

Share via

How to know our current Azure SQL Database resource API version

2 answers

Your answer