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

SAML SSO Plugin version SAML SSO Configuration version
0.14.7 and less com.resolution.atlasplugins.samlsso:xmlConfiguration
0.15.0 - 0.15.7 com.resolution.atlasplugins.samlsso:2:xmlConfiguration

2.0.0 - 2.0.12

com.resolution.atlasplugins.samlsso:3:xmlConfiguration

2.1.0 - 2.2.0

com.resolution.atlasplugins.samlsso:4:xmlConfiguration
2.3.0 and higher com.resolution.atlasplugins.samlsso:5:xmlConfiguration


In the following descriptions, we use the newest configuration version "com.resolution.atlasplugins.samlsso:5:xmlConfiguration". Please replace the configuration version, if you use an older one.

JIRA

Database explorer:

* Open table PROPERTYENTRY and search in the column "property_key" for "com.resolution.atlasplugins.samlsso:5: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:5:xmlConfiguration';

Confluence

Database explorer:

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

SQL statement:

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

Bitbucket

Database explorer:

Table PLUGIN_SETTING → Column "key_name": com.resolution.atlasplugins.samlsso:5: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:5:xmlConfiguration';