The SQL query below will list all RA solutions that are installed in the database (from the OBLOB table).
-- List installed RA solutions from OBLOB table
SELECT OBLOB_Name, OBLOB_FileName, OBLOB_Version, OBLOB_ModDate
--, OBLOB_Type, OBLOB_HostAttrType, OBLOB_FileType, OBLOB_SW, OBLOB_HW, OBLOB_Usage, OBLOB_ReplaceVar
FROM OBLOB
WHERE OBLOB_Type = 1
AND OBLOB_Version IS NOT NULL
ORDER BY OBLOB_Name
Sample output
OBLOB_NAME
|
OBLOB_FILENAME
|
OBLOB_VERSION
|
OBLOB_MODDATE
|
ECC-AE-SHEET-RA-BUSINESS-OBJECTS
|
ECC-AE-SHEET-RA-BUSINESS-OBJECTS.jar
|
4.3.0+build.1644328516975
|
2023-03-03 20:55:19.000
|
ECC-AE-SHEET-RA-FTP
|
ecc-ae-sheet-ra-ftp.jar
|
4.1.2+build.1676277975554
|
2023-03-04 10:02:21.000
|
ECC-AE-SHEET-RA-INFORMATICA
|
ECC-AE-SHEET-RA-INFORMATICA.jar
|
5.3.1+build.1652359134648
|
2023-03-04 10:03:11.000
|
ECC-AE-SHEET-RA-WEBSERVICE-REST
|
ecc-ae-sheet-ra-webservice-rest.jar
|
4.6.6+build.1666340538865
|
2023-03-03 20:44:07.000
|
Enjoy!