Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I suggest you have a look on the governance dashboard where others have already done this job:
QlikView Governance Dashboard 1.1 SR1 Available for Download
QlikView Governance Dashboard 2.0 Beta is now available
- Marcus
Priya, I suggested install the Qlikview Governance dashboard to review your Qlikview environment.
Thank you Marcus and Dathu.qv for your response..