• Below is the result snippet about audit specification which we enabled on all databases,

    Query :

    =====

    select audit_action_id,audit_action_name,class,audited_result from sys.database_audit_specification_details

    Result :

    =====

    audit_action_idaudit_action_name classaudited_result

    DL DELETE 0SUCCESS AND FAILURE

    IN INSERT 0SUCCESS AND FAILURE

    UP UPDATE 0SUCCESS AND FAILURE

    Reply back if you need any more. Thanks for your effort.