Hello Everyone,
I am trying to create Usage analysis for my organization using Session and Audit log.
The frequency of logging is set to be yearly.
in the full year log file i can we one filed named "Session" which seems to be the unique session id.
this field is common in Audit and session log.
How ever most of the Session field is blank in my yearly audit and Session log file.
the strange thing is, this field is only present in Yearly log file not in monthly file.
Please Qlikview Geeks help me out.
Thank you in advance!!!
below is the file structure of Session log :
[Exe Type],
[Exe Version],
[Server Started],
Timestamp,
Document,
[Document Timestamp],
[QlikView User],
[Exit Reason],
[Session Start],
[Session Duration],
[CPU spent (s)],
[Bytes Received],
[Bytes Sent],
Calls,
Selections,
[Authenticated user],
[Identifying user],
[Client machine identification],
[Serial number],
[Client Type],
[Client Build Version],
[Secure Protocol],
[Tunnel Protocol],
[Server Port],
[Client Address],
[Client Port],
[Cal Type],
[Cal Usage Count],
Session
Audit Log:
LOAD [Server Started],
Timestamp,
date(Timestamp) as Date,
Document,
Type,
User,
Message,
Id,
Session
