Home > Forum > Data sources > Active Directory department query as datasource

Active Directory department query as datasource

0

25.07.2022

15:49

Hi.

Is there a way to query the Active Directory only for the department column and add this as a datasource.
What I'm seaking is a list of all departments we have in the company.

Kind regards
Klaus

25.07.2022

16:09

Hi Klaus, you could create a SQL data source which reads from the [BPS_Content].[dbo].[CacheOrganizationStructure] table and shows only distinct values from the department column. Hope this helps.

Solution (0)

Helpful (0)

Wrong answer (0)

25.07.2022

17:18

In reply to: Martin Meze (Freelancer)

Hi Klaus, you could create a SQL data source which reads from the [BPS_Content].[dbo].[CacheOrganizationStructure] table and shows only distinct values from the department column. Hope this helps.

Hi Martin,

so easy and very effective.

Thanks a lot!

Cheers Klaus

Solution (1)

Helpful (0)

Wrong answer (0)