Checks/Azure/Test-SqlserverAuditingRetention90Days.ps1

function Test-SqlserverAuditingRetention90Days {
    <#
    .SYNOPSIS
        SQL server has auditing enabled with retention greater than 90 days

    .DESCRIPTION
        **Azure SQL Server auditing** settings are evaluated to ensure **auditing is enabled** and log retention is greater than `90` days. It considers the auditing policy state and the configured `retention_days` value.

    .PARAMETER Check
        CIEMCheck object containing check metadata.
    #>

    [CmdletBinding()]
    [OutputType([PSCustomObject[]])]
    param(
        [Parameter(Mandatory)]
        [CIEMCheck]$Check
    )

    $ErrorActionPreference = 'Stop'

    # TODO: Implement check logic based on Prowler check: sqlserver_auditing_retention_90_days

    [CIEMScanResult]::Create($Check, 'MANUAL', 'This check requires manual implementation. See Prowler check sqlserver_auditing_retention_90_days for reference.', 'N/A', 'sqlserver Resources')
}