How to make a Custom table.

[RobertWengewicz]

I pulling from a oracle DB, and one of the fields has a bunch of data that I would like to break up.

__65__RES_TK_TYPE=RSA SecurID Key Fob;;__65__RES_TK_NUM_DIGITS=6;;

__65__RES_TK_ASSIGNED_TO=xxxxxxx;;__65__RES_TK_LOST=N;;

__65__RES_TK_ENABLED=Y;;__65__RES_TK_NEW_PIN_MODE=N;;__65__RES_TK_LAST_LOGIN=20080812135300;;

__65__RES_TK_TOKEN_BIRTH=20071204190000;;__65__RES_TK_TOKEN_DEATH=20130330190000;;

What I need out of this string is;

 __65__RES_TK_ASSIGNED_TO=xxxxxxx

__65__RES_TK_LAST_LOGIN=20080812135300

the __65__RES_TK_ASSIGNED_TO=xxxxxxx, will need to be tied back to another table that when the data is updated in the parent table this table is updated also. Is there a way of doing this.

[RSAAdmin]

Hi Robert,

Unfortunately, each event can only parse data into one table, regardless of the number of fields. 

Although it would be possible to modify the XML such that you could parse the "__65__RES_TK_ASSIGNED_TO=xxxxxxx" or "__65__RES_TK_LAST_LOGIN=20080812135300" data to specific fields, those fields must be within the table that the rest of the MESSAGE has been assigned to.