SQL Server : how to read the transaction log file

-- Source : https://www.dsfc.net/infrastructure/base-de-donnees-infrastructure/sql-server-lire-journaux-des-transactions/
WITH
    BT AS
    (
        SELECT
            [Begin Time] AS debut,
            [Transaction Name] AS type,
            Operation AS operation,
            [Transaction ID] AS numtrans
            --AllocUnitName,
        FROM
            sys.fn_dblog(NULL,NULL) AS BT
        WHERE [Begin Time] IS NOT NULL
    ),
    ET AS
    (
        SELECT
            Operation AS operation,
            [End Time] AS fin,
            [Transaction ID] AS numtrans
        FROM
            sys.fn_dblog(NULL,NULL)
        WHERE
            [End Time] IS NOT NULL
    ),
    A AS
    (
        SELECT
            [Transaction ID] AS numtrans,
            AllocUnitName AS objet
        FROM
            sys.fn_dblog(NULL,NULL)
        WHERE
            AllocUnitName IS NOT NULL
    )
    SELECT DISTINCT
        BT.type,
        BT.debut,
        ET.fin,
        BT.operation,
        ET.operation,
        A.objet
    FROM
        BT
        INNER JOIN ET ON BT.numtrans=ET.numtrans
        INNER JOIN A ON ET.numtrans=A.numtrans
WHERE
    ET.operation != 'LOP_ABORT_XACT'
AND
    BT.type IN ('UPDATE','DELETE','TRUNCATE TABLE','INSERT')
ORDER BY
    debut,fin;
GO