How to find the IP address of a QlikView client accessing documents

Sonja_Bauernfeind — Mon, 01 Feb 2021 11:15:13 GMT

QlikView does not offer an out of the box way to easily track all client IP addresses, but a combination of the Session and WebServer log can be used to track them.

Environment

Resolution

Internet Explorer Plugin and QlikView Desktop Client Users

For these two clients, the IP address of the end-user is logged in the QlikView Server Session log, unless an IP translation/masking is performed on the network level.
By default, the Session Log can be found in %ProgramData%\QlikTech\QlikViewServer and is written in the format of Sessions_SERVERNAME.

A simplified example (not all columns displayed):

Timestamp | Document | Session Start | Authenticated user | Client machine identification | Client Type | Client Address

AJAX/Full Browser Client

The QlikView Full Browser Client is our web-based client. The Session log cannot be used to identify the IP address of the end-user from the Session log. Instead, the QlikView Server IP address will be listed as the client address. This can be misleading. If it is necessary to trace the IP address, then the user and timestamp of the session recorded in the Session log can be used to match against a WebServer log file.

To find the IP address of this access, the QlikView WebServer log can be used. It needs to be logging at a high enough level to record Information.

To configure the log level, go to the QlikView Management Console > System > Setup > QVWS@servername > General Tab > Logging Level.

The WebServer log can be found in %ProgramData%\QlikTech\WebServer\Log, unless otherwise configured. If Microsoft IIS is used, please refer to Microsoft's documentation on where to locate the service's log files.

WebServer log entries are single strings without columns. The data is not uniform, therefore no columns can be provided. An example entry would look like this, however:

YMDTime Information Create client: Mode=Authenticate, Host=qlikserver2:4747, ClientIP=172.16.16.103,

Here the Host is the QlikView Server that is being used to serve the document, and the ClientIP is the IP address of the client.

article How to find the IP address of a QlikView client accessing documents in Official Support Articles

How to find the IP address of a QlikView client accessing documents

Environment

Resolution

Internet Explorer Plugin and QlikView Desktop Client Users

AJAX/Full Browser Client

Related Content: