Yearly and Monthly Session log file

Wed, 20 Jan 2016 06:31:19 GMT

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

Re: Yearly and Monthly Session log file

marcus_sommer — Wed, 20 Jan 2016 15:43:34 GMT

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

Re: Yearly and Monthly Session log file

Wed, 20 Jan 2016 16:06:01 GMT

Priya, I suggested install the Qlikview Governance dashboard to review your Qlikview environment.

Re: Yearly and Monthly Session log file

Fri, 22 Jan 2016 11:44:44 GMT

Thank you Marcus and Dathu.qv for your response..

topic Re: Yearly and Monthly Session log file in QlikView

Yearly and Monthly Session log file

Re: Yearly and Monthly Session log file

Re: Yearly and Monthly Session log file

Re: Yearly and Monthly Session log file