Skip to Content
0
Jan 22, 2021 at 03:23 PM

How to retrieve mta information by SQL?

33 Views Last edit Jan 22, 2021 at 03:24 PM 2 rev

I'm looking for the table(s) where is stored mta information that can be retrieved with the xs command "xs mta MyAppName". I'm specially interested by the version number.
I have succeeded to retrieve part of the information using the following statement but I'm still missing the version number.
SELECT * FROM "SYS_XS_RUNTIME"."STOREDAPPLICATION" WHERE "NAME" = 'MyAppName'