How to query for element_name in DSUSER.APPLICATIONSYSDATA in SA 2.0

[TCC_2]

Resolution

Perform these steps to query for element_name in DSUSER.APPLICATIONSYSDATA in Service Agent (SA) 2.0:

1. Log into Oracle through SQLPlus, or log into TimesTen Data Authority Server (TTDAS) through TTLSQL.
    
2. Execute this SQL command:
   
   Command> select element_id from elementdata where element_name = 'xyz';
   
   For example,
   
   Command> select element_id from elementdata where element_name = 'PTT:1370';
   < 2369 >
   1 row found.
   Command>