How to track prior TIBCO Data Virtualization Studio users from events log?

How to track prior TIBCO Data Virtualization Studio users from events log?

book

Article ID: KB0074550

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 8.0 and higher

Description

If there is a need to audit and track prior Studio users who logged into the TIBCO Data Virtualization (TDV) server, a view of the Studio's Sessions console may not be enough as it only displays the current users in the system.

Issue/Introduction

This concerns auditing of Studio users.

Resolution

To track prior users who are no longer logged in

To search for prior Studio login sessions, theĀ  /logs/cs_server_events.log and its archived logfiles can be utilized by scanning its contents for lines containing a:
"START session="
and then ending with:
"WEB_API"


Here is an example of a single entry from the cs_server_events.log, which represents the start of a Studio login session.

2020-10-07 16:06:48.299 -0700 INFO START session=2400622 started for user=admin in domain=composite 7 admin composite 20701 6408448033197 6408448033197 2400622 admin composite bshao-P51.na.tibco.com 10.98.51.111 WEB_API

Another way to find the same result conveniently in the Studio UI would be to run this query in Sql Scratchpad or in a view:
select * from /services/databases/system/LOG_EVENTS where detail like '%web_api%' and type_name = 'start' and category = 'session'

but this result is limited to the most recent 100000 entries by default.

To increase the event log capacity, you could alter the file logging by modifying these lines from: /conf/server/log4j.properties:

log4j.appender.EVENTS.layout=org.apache.log4j.PatternLayout
# no conversion pattern, event log has its own format
log4j.appender.EVENTS=org.apache.log4j.RollingFileAppender
log4j.appender.EVENTS.File=C:/Program Files/TIBCO/TDV Server 8.0/logs/cs_server_events.log
log4j.appender.EVENTS.MaxFileSize=10000KB
log4j.appender.EVENTS.MaxBackupIndex=10


However, you need to consider how much you want to retain, in respect to disk storage usage. The file size capacity will in no way determine the number of exact days it can store.