Query: Ensure that 'Java version' is the latest, if used as a part of the Web app

Description

Periodically, newer versions are released for Java software either due to security flaws or to include additional functionality. Using the latest Java version for web apps is recommended in order to take advantage of security fixes, if any, and/or new functionalities of the latest version. Currently, this policy only applies to Linux web apps.

Query

Tables used in this query:

• azure_app_service_web_app
• azure_subscription

Controls using this query:

• 9.7 Ensure that 'Java version' is the latest, if used to run the Web App
• 9.9 Ensure that 'Java version' is currently supported (if in use)
• Ensure that 'Java version' is the latest, if used as a part of the Web app

SQL