Where to find the stored SAML SSO configuration in the Database ?

The SAML SSO configurations are splitted in different versions, based on the SAML SSO Plugin version. Please find your correct version in the table:

JIRA

Database explorer:

* Open table PROPERTYENTRY and search in the column "property_key" for "com.resolution.atlasplugins.samlsso:3:xmlConfiguration" 
* Check the "ID" column for this this row.
* Open table PROPERTYTEXT and there you should find the column "propertyvalue".
* Search for the specific row, based on the ID found one step above and there you should find the SAML SSO plugin configuration informations as XML text.

SQL statement:

SELECT propertyentry.property_key, propertytext.propertyvalue
FROM propertyentry
INNER JOIN propertytext ON propertyentry.id=propertytext.id
WHERE property_key='com.resolution.atlasplugins.samlsso:3:xmlConfiguration';

Confluence

Database explorer:

Table BANDANA → Column "bandanakey": "com.resolution.atlasplugins.samlsso:3:xmlConfiguration" → Column "bandanavalue" → SAML SSO plugin configuration informations as XML text

SQL statement:

SELECT bandanakey, bandanavalue
FROM bandana
WHERE bandanakey = 'com.resolution.atlasplugins.samlsso:3:xmlConfiguration';

Bitbucket

Database explorer:

Table PLUGIN_SETTING → Column "key_name": com.resolution.atlasplugins.samlsso:3:xmlConfiguration → Column "key_value" → SAML SSO plugin configuration informations as text

SQL statement:

SELECT key_name, key_value
FROM plugin_setting
WHERE key_name = 'com.resolution.atlasplugins.samlsso:3:xmlConfiguration';