For TIBCO Spotfire Server 7.5 and above:From 7.5 and higher version the parameter session-number has been renamed to spotfire.session-number format and the pattern would be as follows.
log4j.appender.sqllog.layout.ConversionPattern=%X{client.ip};%X{spotfire.session-number};%X{principal.name};%d{yyyy-MM-dd'T'HH:mm:ss,SSSZ};%m%n
For TIBCO Spotfire Server 7.0 and below:
log4j.appender.sqllog.layout.ConversionPattern=%X{client.ip};%X{session-number};%X{principal.name};%d{yyyy-MM-dd'T'HH:mm:ss,SSSZ};%m%n