Find the User list of who logged into TDMService or GTService successfully

Products

• CA Agile Requirements Designer

Issue/Introduction

ARD users use either ARD hub or TDM repository to save their flows. Since the users list is not known who requested access to the TDM repository, the users cannot be notified about the TDM repository upgrade.

Is there a way to find out who is logged in to the repository?

ARD Hub version: 3.1.1
ARD version : 3.0.5.5

 

Environment

Release : 3.1

Component : Hub (Windows)

Cause

NA

Resolution

Run the below query against GTREP database. This will give you information on who logged in successfully to either TDMService or GTService

SELECT sul_su_name, *
  FROM [gtrep].[dbo].[gtrep_su_log] where sul_result = 'Success' and (sul_program = 'TDMService' or sul_program = 'GTWCF')