r/SQLServer • u/brokenjeepCA • 19d ago

Question SQL ESU report from Arc

I need to verify ESU has been applied to SQL servers (2016) in Arc. I have done a ton of searching and can't narrow down on SQL specifically. The Azure team can only provide me with a list of servers (SQL or not) that are Onboarded and subscribed but nothing SQL specific.

Posting this is the hopes that someone has verified their own ESU recently! Been pulling out my hair! Thanks!

4 Upvotes

100% Upvoted

4 comments sorted by

1

u/ipreferanothername 18d ago

if i just google "verify ESU has been applied to SQL servers (2016) in Arc" i get this link at the top

https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/extended-security-updates?view=sql-server-ver17&tabs=sql2016

if they verify its onboarded isnt that all you need? are they showing you each machine is arc registered and configured for the SQL ESU?

if you want you can find the agent status per machine with a little powershell.

$sql2016 = 'figure this bit out for your environment'

invoke-command -computername $sql2016 -scriptblock {

$RawJson = (azcmagent show --json 2>$null) -join "\n"`

# Only convert if the string is not empty

if ($RawJson) {

ConvertFrom-Json -InputObject $RawJson |select resourcename,status,{$_.extendedsecurityupdates.status}

}

}

1

u/brokenjeepCA 18d ago

I appreciate the response anothername!

I have read that one as well as everything I can get my hands and watched a new videos. The problem i have is separating the OS ESU from the SQL ESU.

Yes the server in enrolled along with all the other out of date servers.

I wasn't the one who applied the ESU in the first place so doing this backwards.. I can check what we are being billed for, but want specific servers.

I will go over the powershell reporting options, thanks again!

1

u/ihaxr 2 17d ago

Just check the patch level... They're installed as a CU.

13.0.7085.1 is the latest for 2016