How to identify usage of Azure SQL Database 2014-04-01 APIs before retirement

Question

I received a notice about retirement of Azure SQL Database 2014-04-01 APIs, what should I do? How do I identify the resources using the old version?

Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025

You’re receiving this email because you use Azure SQL Database APIs.

To improve performance and security, we’re updating Azure SQL Database APIs. As part of this, all version 2014-04-01 APIs will be retired on 31 October 2025. You’ll need to update your resources, including templates, tools, scripts, and programs, to use a newer API version by then. Any API calls still using the older versions after that date will stop working until you’ve updated them.

Required action 

To avoid potential service disruptions, upgrade [aka.ms] any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version by 31 October 2025.

I found a similar question from 2022 that offered an answer with a query that could be run to do this, but I am not sure where to run such a query. I tried Azure Monitor > Logs but it failed to run.

HttpIncomingRequests  
| where TIMESTAMP > ago(1d)  
| where targetResourceProvider == 'MICROSOFT.SQL'  
| where subscriptionId == 'xxxxxxxxxxxx'  
| where apiVersion == "2014-04-01" or apiVersion == "2014-01-01" or apiVersion == "2014-04-01-preview"

I tried running this in Azure monitor but it does not know what HttpIncomingRequests is.

Answer 1

Hi, @McDonald, Matthew Thanks for sending the email, I have checked the subscription details which you have shared and I don't see any results It means it's good, no old API calls unless you have an application that ran more than 30 days ago and not at all since then, So if you have some application or pipeline that runs once a year or quarterly, then maybe that might still have issues. But that's very unlikely.

I hope this information helps.

Regards

Geetha

Answer 2

I just got the a similar email. I found the "Azure Resource Graph Explorer" at https://portal.azure.com/#view/HubsExtension/ArgQueryBlade

I was able to run this query:

Resources

| project name, type, apiVersion, subscriptionId, resourceGroup

| where type =~ 'microsoft.sql/servers/databases'

| where isnotnull(apiVersion)

| order by type asc

The apiVersion in the result was "2024-05-01-preview" so I guess I am OK.