Summary
Sometimes we need to check accounts activities related to recovery, to analyze what were good.
Question
Description:
The SQL query below will show all the successful account recoveries, the Server ID
which the account had assigned at the moment of the recovery, the account number
that was recovered and the date when the recovery took place.
Restriction: You must have to have access as administrator of CBk repository
Answer
Procedure:
1. Log in into CBk repository as top user or owner or high privileged user.
2. Execute the following query:
|
--Database where to look for is: Use Registry --Query to execute is: Select ServerId, Account, ActDate from Activity Where Type = 'S' and SessionStatus = 1 |
3. Now with the information outcome then analyze according your needs.
Note:
|
You can use a specific account just adding the condition to where statement Account = <your account #>
|