Updates

The 7 checks in the “Updates” category of a SQL Server audit: what each one verifies, its severity and the versions covered.

Checks in this category

UPD004
End of Support
Critical
Check if the version is still supported by Microsoft
Versions : 2012-2025
UPD006
Non-production edition
High
Checks that the installed edition is licensed for production and lists the Enterprise-only features persisted in each database that would block a downgrade to Standard. Evaluation edition stops starting after 180 days.
Versions : 2012-2025
UPD007
Host operating system end of support
High
Identifies the host operating system and compares it against the vendor end-of-support dates. Complements the engine version checks, which say nothing about the OS underneath.
Versions : 2012-2025
UPD001
SQL Server Version
Info
Identify the major SQL Server version
Versions : 2012-2025
UPD002
Patch level
Info
Reports the patch level declared by the instance (ProductLevel): a Service Pack up to SQL Server 2016, not applicable from 2017 on, where servicing goes through cumulative updates (see UPD003).
Versions : 2012-2025
UPD003
Cumulative Update
Info
Check if the latest CUs are installed
Versions : 2012-2025
UPD005
Build Number
Info
Compare build number with the latest available
Versions : 2012-2025