Besreporting database

Reporting
1

Hi,
Can anyone clear my understanding that which type of data is stored in besreporting database?

I guess the actual data is only displayed when the report is opened and not stored in besreporting db, as db itself doesn’t have that much information and tables.

All the data will be stored in bfenterprise db.

Thank you in advance.

2

Well Web Reports caches the data locally so all queries actually run against a cached copy of the data and never against the bfenterprise database. I outline this process here: Bigfix Web Reports Data Flow

The besreporting database holds the following:

  1. User Configuration
  2. Role Configuration
  3. LDAP Configuration
  4. Session Information
  5. Report formatting and information (not results)
  6. Scheduled report information
2 Likes
3

thank you @strawgate :blush:

1 Like