Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
did
Employee
Employee

loading Audit Log of QV Server

Hello everyone,

could anybody please answer my question:

how come loading the txt Audit log file of QV server into my qvw I get only ca. a half of lines contained in the log?

For example: the audit log contains 7139 lines and after load into QV my table contains always only 3156 lines.

Neither conditons nor other sort of limitations have been set during this load.

Loading events and sessios logs always goes fine: the number of lines in these logs corresponds to the number of lines loaded into QV.

My load script:

Audit:

LOAD

     [Server Started],

     Timestamp,

     Document,

     Type,

     User,

     Message,

     Id,

     Session

FROM $(AuditLogPath).log

(txt, utf8, embedded labels, delimiter is '\t', msq);

Denis

1 Reply
marcus_sommer

I assume you are looking on your data with a tablebox but a tablebox won't be display duplicates. If you want to be sure that everything will be displayed you need to add a counter - most rowno() - within your load and then in the tablebox: Counters in the Load. Further you could check your data within the tableviewer: The Table Viewer.

- Marcus