MAX Records - Entitlement Report

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

MAX Records - Entitlement Report

L4 Transporter

Hello, I am now running over 1 million MaximumRecords for the entitlement report, and will need to gather the report a different way, either putting it together in parts or using a third party tool?

5 REPLIES 5

L7 Applicator

Try Power BI perhaps

L4 Transporter

Hello,

Another option would be to export vault data to SQL using EVD and then run SQL queries.

Reference - https://docs.cyberark.com/pam-self-hosted/latest/en/content/evd/exporting-data-to-mssql-databases.htm

L1 Bithead

Use REST API to pull data on PowerBI https://docs.cyberark.com/pam-self-hosted/latest/en/content/webservices/implementing%20privileged%20account%20security%20web%20services%20.htm

L4 Transporter

Hi @Shawn M​ 

Several community members have shared answers to your question. Could you let us know if any of these resolved your issue?

If so, please mark the appropriate answer as “Select as Best” to help other members find the solution easily.

If the issue remains unresolved, I recommend submitting a ticket with our support team for further assistance.

Thank you,

Shaked

L4 Transporter

Hello,

I decided to filter the entitlement reports by user type. I now gather all reports (20 in total , most are currently empty, but I will schedule them to run quarterly since they are required for audit purposes) and use a PowerShell script to consolidate them into a single workbook.

The script sorts the reports by size (largest to smallest) and renames the relevant tabs (e.g., EVUSER, PSM, Built-In Admins, etc.) based on their corresponding filters.

In the end, this approach provides a much cleaner and more structured view of the entitlement data, compared to generating one very large, consolidated report.

Field_Content_versions_oct20__068Vy00001CAB4QIAX.png

  • 129 Views
  • 5 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!