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

The SAML SSO configurations are splitted in different versions, based on the version of the SAML SSO plugin for Atlassian Data Center / Server application. Please find your correct version in the table:

Jira Data Center / Server

Database explorer:

• Open table PROPERTYENTRY and search in the column "property_key" for the values that start with "com.resolution.atlasplugins.samlsso:".

• You should see all the configuration records if you have previous versions installed already, check the latest one as per the table above.

• Check the "ID" column for that 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 information as text

SQL statement:

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

Single SQL query to retrieve the data

Confluence Data Center / Server

Database explorer:

Table BANDANA → Column "bandanakey": values that start with "com.resolution.atlasplugins.samlsso:" → Column "bandanavalue" → SAML SSO plugin configuration information as text

SQL statement:

SELECT bandanakey, bandanavalue
FROM bandana
WHERE bandanakey LIKE 'com.resolution.atlasplugins.samlsso:%';

Bitbucket Data Center / Server

Database explorer:

Table PLUGIN_SETTING → Column "key_name": values that start with com.resolution.atlasplugins.samlsso: → Column "key_value" → SAML SSO plugin configuration information as text

SQL statement:

SELECT key_name, key_value
FROM plugin_setting
WHERE key_name LIKE 'com.resolution.atlasplugins.samlsso:%';