Default query 'Permission set details' shows incomplete results

Technical Articles ID: KB95119
Last Modified: 12/29/2021

Environment

ePolicy Orchestrator (ePO) 5.10.x

Problem

You observe the following after you open Queries & Reports, search using the default query Permission set details, and click Run:

The results don’t show the expected complete details from all available permission sets.

You observe the following after you open User Management, Permission sets and have more custom permission sets created (example 80–100):

The data for each permission set contains more lines than what the default limit is set to.

Cause

The default query Permission Set Details is created with the Result Type Multi-group Summary Table.

The Multi-group Summary Table uses the Bar chart as the source. The Bar chart by default is limited to 200 lines in console.

Solution

You can increase the default setting for 'Chart Type' after you upgrade to ePO 5.10 Update 10 or later.

To change the default values:

Log on to the ePO console.
Click Menu, Server Settings, Queries, Edit.

NOTES:
- ePO 5.10, or Update 1–9, doesn't have this Queries tab in Server Settings.
- The table below are the default settings. The maximum supported value is 2000 for each category.

You can increase the default setting for 'Chart Type' after you upgrade to ePO 5.10 Update 10 or later.

To change the default values:

Log on to the ePO console.
Click Menu, Server Settings, Queries, Edit.

NOTES:
- ePO 5.10, or Update 1–9, doesn't have this Queries tab under 'Server Settings'.
- The table below shows the default settings. The maximum supported value is 2000 for each category.

Single-Line Chart	500
Bar Chart	1000
Stacked Bar Chart	200
Single Group Summary Table	1000
Bubble Chart	200

Change the Bar Chart value (1000, or 2000).
To show the complete details, run the same query Permission set details.

Affected Products

ePolicy Orchestrator 5.10.x
Known Issue/Product Defect
Reporting

Languages:

This article is available in the following languages:

English United States
Spanish Spain
French
Italian
Portuguese Brasileiro
Chinese Simplified

Knowledge Center

Default query 'Permission set details' shows incomplete results

Environment

Problem

Cause

Solution

Affected Products

Languages:

Title

Title

Knowledge Center

Default query 'Permission set details' shows incomplete results

Environment

Problem

Cause

Solution

Affected Products

Languages:

Choose your region

Title

Title