# Generating Report listing all the Data owners (File access manager 8.2)

**URL:** <https://community.sailpoint.com/discuss/t/generating-report-listing-all-the-data-owners-file-access-manager-8-2/29713>\
**Category:** Administration & Troubleshooting\
**Tags:** governance, compliance, search-reports\
**Created:** [April 1, 2023, 8:49am UTC](https://community.sailpoint.com/discuss/t/generating-report-listing-all-the-data-owners-file-access-manager-8-2/29713 "2023-04-01T08:49:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![hrushi23](https://avatars.discourse-cdn.com/v4/letter/h/ce7236/32.png) [@hrushi23](https://community.sailpoint.com/discuss/u/hrushi23)\
**Post date:** [April 1, 2023, 8:49am UTC](https://community.sailpoint.com/discuss/t/generating-report-listing-all-the-data-owners-file-access-manager-8-2/29713/1 "2023-04-01T08:49:10Z")

</div>

Hello, I’m currently using File Access Manager (FAM) version 8.2 and I have a requirement to generate a **report that lists all the data owners in our system**. However, I’m unable to find any out-of-the-box option or customizable reports that fulfill this requirement. Can anyone suggest a solution or guide me on how to generate such a report?&nbsp; Thank you in advance !!

---

<div class="post-metadata">

**Author:** ![ranjith\_koppu](https://sea3.discourse-cdn.com/sailpoint2/discuss/user_avatar/community.sailpoint.com/ranjith_koppu/32/17482_2.png) [@ranjith\_koppu](https://community.sailpoint.com/discuss/u/ranjith_koppu)\
**Post date:** [April 3, 2023, 2:53pm UTC](https://community.sailpoint.com/discuss/t/generating-report-listing-all-the-data-owners-file-access-manager-8-2/29713/2 "2023-04-03T14:53:26Z")

</div>

You will have to create a data source based on SQL Server to achieve this.

Below are the tables that contain the information.

You will have to join the whiteops.business\_service\_owner table with whiteops.ra\_user to get the user details and also join this with whiteops.business\_service to get the name of the folder.

**Whiteops.business\_service\_owner** -- Table holds the business service id (Resource id) and the ra\_user\_id mapping

**Whiteops.business\_service\_path\_owner** -- Only used for DFS -- Table holding the DFS resource and owner details.

Once you have the query ready, follow the steps to create a data source and you can schedule the report to run periodically.

Cheers,

Ranjith

---

<div class="post-metadata">

**Author:** ![brent\_peterson](https://sea3.discourse-cdn.com/sailpoint2/discuss/user_avatar/community.sailpoint.com/brent_peterson/32/17284_2.png) [@brent\_peterson](https://community.sailpoint.com/discuss/u/brent_peterson)\
**Post date:** [April 3, 2023, 4:25pm UTC](https://community.sailpoint.com/discuss/t/generating-report-listing-all-the-data-owners-file-access-manager-8-2/29713/3 "2023-04-03T16:25:00Z")

</div>

The “Resources by User Scope” report may have what you are looking for.

---

<div class="post-metadata">

**Author:** ![hrushi23](https://avatars.discourse-cdn.com/v4/letter/h/ce7236/32.png) [@hrushi23](https://community.sailpoint.com/discuss/u/hrushi23)\
**Post date:** [September 14, 2023, 1:56pm UTC](https://community.sailpoint.com/discuss/t/generating-report-listing-all-the-data-owners-file-access-manager-8-2/29713/4 "2023-09-14T13:56:43Z")

</div>

Thank you ,&nbsp; @ranjith_koppu &nbsp; @brent_peterson &nbsp;for your valuable responses !!