Application name audit for SQL Server connections

Products

• Clarity PPM On Premise

Issue/Introduction

Customer would like to have an audit trail (application name) on connections from Clarity to SQL server  ( as explained on reference https://www.connectionstrings.com/use-application-name-sql-server/ )

How can this be defined in Clarity configuration?

Environment

Release : 15.x

Component : CLARITY PPM APPLICATION

Resolution

Reference point:

Database server properties in CSA (product documentation)

PPM application does not have any dependency on SQL server optional Application Name parameter.

The customer could test the Database parameter in the CSA by adding the optional parameter in the CSA > Database configuration section.


Sample DB URL:

jdbc:clarity:sqlserver://DBSERVERNAME:1463;DatabaseName=SJ625398_PPM_07070428;InsensitiveResultSetBufferSize=0;ProgramName=Clarity;DateTimeInputParameterType=dateTime;



Sample DB URL with Application Name parameter:

jdbc:clarity:sqlserver://DBSERVERNAME:1463;DatabaseName=SJ625398_PPM_07070428;InsensitiveResultSetBufferSize=0;ProgramName=Clarity;DateTimeInputParameterType=dateTime;Application Name=PPMCLARITY;

Following the DB URL change the PPM services need to be restarted and the new paramter would be considered while starting up PPM services.