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:

In the following descriptions, we are retrieving all the available configuration records if you have previous versions installed already.

To know which exact one that is currently being used, check the table above for the corresponding configuration version to your current plugin version.

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

select* 
from propertytext 
join propertyentry  on propertyentry.id  = propertytext.id 
where propertyentry.property_key  like 'com.resolution.atlasplugins.samlsso:%' 

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:%';