topic How to add IP Address to Operations Monitor app? in App Development

How to add IP Address to Operations Monitor app?

nlopedebarrios — Thu, 28 Dec 2023 13:46:44 GMT

The Operations Monitor 7.16 is great to analyze QS usage, but I would like to add the IP address from where the users are logged in for certain activities, such as Exporting overview. I'm struggling trying to add this field, because the data loading is very complex.

I'm just getting started with Qlik Sense, any tips on how can I achieve that?. I know the IP address is in the Proxy Trace Audit Log.

Re: How to add IP Address to Operations Monitor app?

Anil_Babu_Samineni — Fri, 29 Dec 2023 19:11:06 GMT

At the moment, there is no way to find the IP address what i recall according to Qlik GDPR rules.

Anyway, make sure from your QMC this is enabled towards Virtual proxy?

Anyway, this is storing in logs (How much accurate is this, I never tried). from there see if you can grab those logs to your tools.

Re: How to add IP Address to Operations Monitor app?

nlopedebarrios — Tue, 02 Jan 2024 12:57:09 GMT

Hi, and Happy New Year.

According to the documentation, IPAddress can be found in the Qlik Sense Proxy Service (QPS): Service https://help.qlik.com/en-US/sense-admin/November2023/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Server-Logging-Tracing-Log-File-Format-Additional-Fields-Audit-Log.htm

Looking at the server, the file I needed to load is located in \ProgramData\Qlik\Sense\Log\Proxy\Trace, named xyz_audit_proxy.txt (wich is actually in the folder)

I've added this line at the end of the logList:

 Proxy, Trace, Audit, Timestamp, fieldsProxyAudit

following the pattern found for other files.

So far I see this as progress, but I'm getting this error:

Unexpected token: ',', expected one of: '(', '*', 'IDENTIFIER', 'LITERAL_FIELD', 'Yellow',
 'ZTestw_z', 'OPERATOR_PLUS', ...

Error line:

CONCATENATE (working) Load Round(TimeStamp(ConvertToLocalTime(Round("Timestamp",1/86400)))
,1/1440) &'|' & Round(ConvertToLocalTime(Timestamp),1/1440) AS _date_time_link, 
TimeStamp(ConvertToLocalTime(Round("Timestamp",1/86400))) AS LogEntryPeriodStart, 
timestamp(ConvertToLocalTime(Round(Timestamp,1/86400))) AS LogTimeStamp, 
Message, >>>>>>,<<<<<< Id as Id_temp 
// Unique Identifier for Log entry to be used in the WHERE NOT EXISTS () 
clause to avoid loading duplicate log entries
FROM 'lib://ServerLogFolder/Proxy/Trace/TABLEROS_Audit_Proxy.txt' 
(txt, utf8, embedded labels, delimiter is '\t', msq) WHERE isnum(Sequence#)

Re: How to add IP Address to Operations Monitor app?

nlopedebarrios — Tue, 02 Jan 2024 14:49:43 GMT

Added this line into defineFields section and voilá, except now I have a synthetic key:

LET fieldsProxyAudit = 'Timestamp, ActiveUserId, IpAddress, AppId';

Data loads fine, except the IPAddress field is mostly empty.

Further recommendations appreciated!

Re: How to add IP Address to Operations Monitor app?

Felipe02 — Wed, 21 May 2025 19:44:26 GMT

Hello! Where exactly did you add this in the application?

Would this be the IP of the user's machine that accessed the qlik sense user?