Database ttlogin
The Cisco Login Datastore is a real-time database for storing client sessions to the Cisco Client Profile Agent.

  Table clientsessions
    column name        type     example                                XML field
    ???                string   00000001:5f11ae70:0008e4cc:00001e61    0  <--- shared key?
    pkid               string   263671a1-36eb-4172-9234-41560382ff6f   1
    ???                string   268004d4-e1b6-44e1-989d-c26e5d3fb843   2
    sessionid          string   04aae18a-66e6-317d-227d-b0098fe42de3   3
    ???                ???      null                                   4
    clienttype         int      1                                      5
    clientversion      string   11.5.3.34931                           6  <---  **useful**
    
                                                    
  Table onetimepassword
    column name        type      example                               XML field                   
    ???                string    00000001:5f11b1c8:000625c5:0000201e   0  <--- shared key?
    pkid               string    46b844aa-c24b-4360-9159-86c9164e55aa  1
    userid             string    trgibsa                               2  <---  **useful**
    password           int       94062276                              3
    tmstamp            unixtime  1595008089077                         4    
    
    
  Table typesysreplication
    column name        type      example                               XML field
    ???

Examples:    
run pe sql ttlogin select count(*) from clientsessions

  counts the jabber sessions

run pe sql ttlogin select * from clientsessions where clientversion like '11.'

  lists everyone running any version of jabber 11.x

================================================================================
 
Database ttroute 
  
  Table validendusers
    column name       type      example                                XML field 
    ???               string    00000001:5f0cd116:0007c052:000004c6    0
    pkid              string    b546040a-dec0-4675-9ea7-ccf87548bb28   1
    userid?           string    trgibsa                                2
    ??                string    trgibsa                                3
    ??                string    trgibsa@ilstu.edu                      6