cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1475
Views
0
Helpful
0
Comments
TCC_2
Level 10
Level 10

Resolution

To find a user in the TTDAS perform these steps:

  1. Log in as dsuser to the machines where TimesTen (TT) is located for the specific POP to which the user exists.

  2. Navigate to TT install directory. For example, cd /opt/TimesTen/5_0_30/bin directory.

  3. Issue the proper command to get into sql command line for a specific instance. For example, ./ttIsql -connStr DSN="POP_0".

    Type ? or help for help, type exit to quit ttIsql. All commands must end with a semicolon character.

  4. There are three main tables to find a subscriber that exists in the database:

  • NRS_MAPPING

    Command> select * from SIP.NRS_MAPPING where sub_uri='test_0@cisco.com';

    < test_0@cisco.com, 4767269464969809936, 1, 0, KCI ,1109966415, 4228BE520005D627 >

    1 row found.

    Note: The next two commands use the internal_id, which is pulled from the previous command.

  • SUBSCRIBER

    Command> select * from SIP.SUBSCRIBER where internal_id=4767269464969809936;

    < 4767269464969809936, 66feecfe567af0c42f5502f461f272e0, 102,2121112200, 1109966415, 1109966415, 1109966415, 4228BE520005D87F >

    1 row found.

  • REGISTRATIONINFO

    Command> select * from SIP.REGISTRATIONINFO where internal_id=4767269464969809936;

    < 4767269464969809936, 0, 

The above commands should be issued on both schemas 0,1, and on the primary and buddy POPs.


Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: