Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I check data tables in Confluence?

Jeremy Price
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 26, 2018

I was asked by an Atlassian helpdesk team member to check the  "AO_9412A1_AOREGISTRATION" table in the database. I'm not sure where i need to go to access this information or how I would run queries from it wither which is listed below. 

 

select * from "AO_9412A1_AOREGISTRATION";

 Any information would be helpful. 

1 answer

1 accepted

2 votes
Answer accepted
Moses Thomas
Community Champion
July 26, 2018

@Jeremy Price

You need to  know which  host your database server is running , if you  use my sql  then you  can  install  the  Mysql work  bench  and ,  then user that  has read permission to  all  tables,  then you  can  type  this query in  the workbench to obtain the result  you need.

I suggest you contact your database administrator.

 

Best!

Jonathan Smith
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 26, 2018

Path for the DBA: Databaseserver/Confluence/Tables/dbo.AO_9412A1_AOREGISTRATION

Like Jeremy Price likes this
Jeremy Price
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 26, 2018

Thanks for this information. I will pass it along and try to get that information. 

Suggest an answer

Log in or Sign up to answer