Querying Active Directory for specific user data

I would like to have a list (i.e. a table) with all phonenumbers of our users. But not all users are confluence users.

Is there a way to query an actice directory and build a dynamic site in confluence??




3 answers

0 vote
Davin Studer Community Champion Nov 05, 2014

Could you please clarify your question? Are you asking about putting user phone numbers into their profiles from Active Directory?

Hi David,

not putting into their profiles. I am using a LDAP query to get our confluence users from a specific OU.

Now I want to query the whole AD to get the phonenumbers of all users Independent of the confluence users.

In a confluence site I would like to have a table with Names and numbers of all AD users.

So far, I found out that an AD can be queried by Standard SQL Statements and there is a addon called "SQL for Confluence".

0 vote
Davin Studer Community Champion Nov 06, 2014

Yes, you could do it with the SQL plugin by querying AD. One thing to note if you are on a Windows 2008 domain your AD query cannot return more that 901 records or it will fail. I think if it is a 2003 domain it is 1000 records. It is a hard limit in AD that has to do with paging. So, you will need to cut up your query into multiple queries that return 901 or less records. Then you would union all of the queries together. I have done this in our environment by creating a view with multiple select statements unioned together to get the full result. This is also very slow. So, we have created a SQL job that will populate a real table with the information every 15 minutes. So, you could user the slow view that has realtime data or the fast table that is 15 minutes out of date.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Friday in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

292 views 11 10
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you