query the SQL SERVER Audit output

v2008R2, I recently implemented a SQL Server Audit, designed to monitor object changes, as well as server/database level setting changes.  It's been in place for about a week, and I like what I am seeing -- but, I am having a few problems reading the data.

The audit dumps the sqlaudit file to disk, and I upload it once daily to a table.  I then have a little reporting procedure which looks for the new audit events, and sends a summary email to me, briefly noting the changes.  All of the audit events are being captured correctly in the files, but my reporting procedure isn't returning them all to me.  Also, some of the events in the file are being loaded to the table in chunks, rather than in a single records.  For example, one record will have the first part of an alter or create statement, and the next record holds the rest of it.  (maybe my datalength is insufficient?)

The sql server audit is still fairly new to me, and I was hoping for some EE advice for how to properly reference the audit events - server and database separately -- and how to better filter, or manage the data, once i've loaded the sqlaudit file to my table, and am trying to report on the events.  Below I have pasted the piece that writes the file to a table, and the piece that I am using to read from it.


THIS IS THE PIECE THAT COLLECTS THE sqlaudit FILE AND LOADS TO TABLE
NOTE: My WHERE clauses are trying to separate server from database audit events.  I was also getting duplicates in my result-set, so they are geared to elimiate dupes.  Possibly not correct. You can see my case statement, this is to get the bulk out of the larger events, and just quickly reference the action and the object, rather than putting the whole create or alter statement in there.  It seems correct.
-----------------------------------------------------------------------------------------------------------
INSERT dbo.myTable (EventTime,AuditType,ActionID,ServerName,DatabaseName,SchemaName,ObjectName,ActionPerformed,UserName,AuditFile)
SELECT EventTime,AuditType,ActionID,ServerName,DatabaseName,SchemaName,ObjectName,ActionPerformed,UserName,AuditFile
FROM
(      
      -- Database Audit
      SELECT af.event_time [EventTime],aa.class_desc [AuditType],af.action_id [ActionID],af.server_instance_name [ServerName],af.database_name [DatabaseName],af.[schema_name] [SchemaName],af.[object_name] [ObjectName],af.[statement] [ActionPerformed],af.server_principal_name [UserName],af.[FILE_NAME] [AuditFile]
      FROM sys.fn_get_audit_file ('C:\Audit\SQLServer*.sqlaudit',NULL,NULL) af INNER JOIN sys.dm_audit_actions aa
        ON af.action_id = aa.action_id INNER JOIN sys.dm_audit_class_type_map ctm
            ON aa.class_desc = ctm.securable_class_desc
      WHERE af.[statement] <> ''
      AND aa.class_desc <> 'SERVER'
      AND af.database_name <> 'master'
      AND ctm.class_type_desc = 'DATABASE'
      AND af.action_id IN('AL','DR')
      AND af.[OBJECT_NAME] NOT IN ('dbo','')
      GROUP BY af.event_time,aa.class_desc,af.action_id,af.server_instance_name,af.database_name,af.[schema_name],af.[object_name],af.[statement],af.server_principal_name,af.[file_name]
            
UNION

      -- Server Audit
      SELECT af.event_time [EventTime],aa.class_desc [AuditType],af.action_id [ActionID],af.server_instance_name [ServerName],af.database_name [DatabaseName],af.[schema_name] [SchemaName],af.[object_name] [ObjectName],af.[statement] [ActionPerformed],af.server_principal_name [UserName],af.[FILE_NAME] [AuditFile]
      FROM sys.fn_get_audit_file ('C:\Audit\SQLServer*.sqlaudit',NULL,NULL) af INNER JOIN sys.dm_audit_actions aa
        ON af.action_id = aa.action_id INNER JOIN sys.dm_audit_class_type_map ctm
            ON aa.class_desc = ctm.securable_class_desc
      WHERE af.[statement] <> ''
      AND aa.class_desc <> 'DATABASE'
      AND ctm.class_type_desc = 'SERVER AUDIT'
      AND af.database_name = 'master'
      AND af.[OBJECT_NAME] NOT IN ('dbo','')
      GROUP BY af.event_time,aa.class_desc,af.action_id,af.server_instance_name,af.database_name,af.[schema_name],af.[object_name],af.[statement],af.server_principal_name,af.[file_name]
) x
WHERE
      x.EventTime > @MaxEventTime


THIS IS WHAT I USE TO CAPTURE NEW EVENTS AND EMAIL THEM
--------------------------------------------------------------------------------------------
DECLARE @dt DATETIME = CONVERT(VARCHAR(10),GETDATE(),101)
DECLARE @QueryOut NVARCHAR(MAX),
      @Header VARCHAR(1000),
      @List VARCHAR(1000),
      @Subject NVARCHAR(155) = (SELECT @@SERVERNAME + '  ' + '  Server Audit'),
                        @tableHTML NVARCHAR(MAX)

SELECT @QueryOut = CAST(
            (
            SELECT
            td = CONVERT(VARCHAR(16),DATEADD(minute, DATEDIFF(minute,GETUTCDATE(),GETDATE()),EventTime)),'',
                                    td = AuditType,'',
                                    td = ServerName,'',
                                    td = DatabaseName,'',
                                    td = SchemaName,'',
                                    td = ObjectName,'',
                                    td = CASE WHEN ActionPerformed LIKE 'CREATE TABLE%' THEN SUBSTRING(ActionPerformed,1,31)  
                                                  WHEN ActionPerformed LIKE '%CREATE PROCEDURE%' THEN SUBSTRING(ActionPerformed,1,50)
                                                  WHEN ActionPerformed LIKE 'CREATE LOGIN%' THEN SUBSTRING(ActionPerformed,1,27)
                                                  ELSE ActionPerformed END,'',
                                    td = UserName
                              FROM
                                    dbo.MyTable sa
                              WHERE
                                    sa.Time >= @dt            
                              FOR XML PATH('tr'), TYPE)
                              AS NVARCHAR(MAX))

                  SET @tableHTML =
                        N'<STYLE TYPE="text/css">' +
                        N'TD{font-family: Verdana; font-size: 8pt; color:Black;}' +
                        N'table {border-width:4px; border-style:outset; text-align:left; color:Black;}' +
                        N'th {border-width:1px; border-style:inset; font-size:16px; font-weight:bold; padding:5px 20px 5px 20px;color:Black;}' +
                        N'td {border-width:1px; border-style:inset; font-size:12px; white-space:nowrap; padding:3px 20px 3px 20px;color:DarkBlue;}' +
                        N'H3 {font-size:16px; white-space:nowrap; color:Black;}' +
                        N'</STYLE>' +
                        N'<table border="1">' +
                        N'<tr>' +
                        N'<th>EventTime</th>' +
                        N'<th>AuditType</th>' +
                        N'<th>Server</th>' +                  
                        N'<th>Database</th>' +
                        N'<th>Schema</th>' +
                        N'<th>Object</th>' +
                        N'<th>Action</th>' +
                        N'<th>ByWhom</th>' +
                        @QueryOut +
                        + N'</table>';

                        IF(@tableHTML IS NULL)
                        BEGIN
                              RETURN;
                        END
                        ELSE
                        BEGIN
                              EXEC msdb.dbo.sp_send_dbmail
                                @profile_name = 'Profile',
                                @recipients = 'email',
                                @subject = @Subject,
                                @body = @tableHTML,
                                @body_format = 'HTML' ;
                        END