System Information¶
System Info gives fixed, tested listings for the standard BusinessObjects administration questions: inventory, users, groups, logons, reports, usage, data sources, report contents, schedules, instances, folder security, audit and servers.
Image of the System Info Overview tab with the Data as of table and the Environment inventory listing
../../images/web-console/insights/sysinfo-overview.png
What it answers¶
Each listing states its question at the top. Examples:
- What is in each environment, and when did each object type last change?
- Which accounts never logged on, and what would be orphaned if they were removed?
- Which reports were created or changed between two dates, and by whom?
- Which reports use free-hand SQL, on which connection?
- Who receives what from every schedule?
- Which users and groups hold which access level on each folder?
Open it¶
In the BusinessObjects console, select System Info. Each theme is a tab; inside a tab a segmented control picks the listing.
Filters¶
The page header has only the environment buttons. Each listing adds the filters it needs:
| Filter | Effect |
|---|---|
| Search box | Free-text filter on the listing's main column (the placeholder says what it searches). Some listings add a second search box. |
| Folder path | "Folder path starts with", with suggestions. |
| Date window | Presets 30, 60, 90, 180, 365 days, or from / to dates (local time; start inclusive, end exclusive). |
| People + service accounts / People only | Hides the service accounts named under How this list is built. |
| Chips | Listing-specific choices, such as object kind, status or authentication type. |
| Page size | 100 or 500 rows per page, with paging. |
How this list is built opens a sheet with the question, the filters in effect, constants, how current the data is, and the SQL behind the list.
Listings¶
| Tab | Listings |
|---|---|
| Overview | Data as of (per environment: version, latest metadata change, users, security pull, latest audit event and logon, server metrics); Environment inventory |
| Users | All users; Never logged on; Aliases and authentication; Active sessions |
| Logons | Users who logged on; Logon / logoff events |
| Groups | User groups; Members (direct and nested) |
| Reports | All reports and documents; Created or modified; Not used |
| Report usage | Usage between dates; Activity by user |
| Data sources | Report -> universe / connection; Universes; Connections; Free-hand / custom SQL; Crystal DB logons |
| Report contents | Universe objects used; Variables and formulas; Filters and input controls; Prompts |
| Schedules | Recurring schedules; Destinations and recipients |
| Instances | Instances between dates |
| Folders & access | Folder tree; Folder security entries; Folders a user can view (opens Who can see on Security) |
| Audit | Audit events; Event summary; Client applications |
| Servers | Servers (host, running, enabled, needs restart, process id, request port, cores, RAM, disk, CPU, audit queue, server groups); Server metrics (latest value plus minimum, average and maximum over the window) |
Image of the Users tab on the Never logged on listing with the search box and People only chip
../../images/web-console/insights/sysinfo-users.png
Image of the Data sources tab on the Free-hand / custom SQL listing
../../images/web-console/insights/sysinfo-fhsql.png
Image of the How this list is built sheet for one listing
../../images/web-console/insights/sysinfo-how-built.png
Data freshness¶
Listings read what MetaMiner last pulled from each environment. Data as of on the Overview tab shows, per environment, the latest captured change of each kind; an environment with auditing off says no audit data (auditing off). Times on this page are in your local time; MetaMiner stores them in UTC and converts the window exactly.
Export¶
Every listing has Excel and CSV export of the full filtered list, and the SQL is available under How this list is built. See Insights Dashboards.
Related¶
- Common
- Security
- Meta Query on the Web - run your own SQL
- SQL Script Catalog