
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to find the IP address of a QlikView client accessing documents
Feb 1, 2021 6:15:13 AM
Feb 1, 2021 6:07:51 AM
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
YMDTime | DOCUMENT.qvw | YMDTime | DOMAIN\user | ComputerName [ID] | Windows Exe | IP address of the client
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.
Timestamp | Document | Session Start | Authenticated user | Client machine identification | Client Type | Client Address
YMDTime | DOCUMENT.qvw | YMDTime | DOMAIN\user | [ID] | Ajax QvWS + version number | IP address of the Server
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.