Skip to content

[MM-C15] DB User Use

Lists the database user names your Crystal Reports connect with, original and overridden.

Report document

Web Intelligence document [MM-C15] Crystal IA - DB User Use from the MetaMiner standard report pack. It reads the MetaMiner Database (MMDB) through the MetaMiner Standard universe. See Reports and Data.

What it answers

  • Which Crystal Reports log on to the database with a given user?
  • Where a report's stored database user was overridden in the CMS.
  • Which reports are affected when a database account changes or is retired.

Who uses it: BI platform administrators and database administrators managing database accounts.

Report tabs

Tab Shows
Crystal IA - DB User Use One row per report and connection.

Image of MM-C15 refreshed for one environment, Crystal IA - DB User Use tab

../images/reports/mm-c15-layout.png

Legacy image for reference: images/mmsr_layout_MM-C15.png

Columns and measures

Group Columns
Report Environment, Document, Document CUID, Crystal Doc, Crystal Doc CUID, Folder Type, Folder Name, Folder Path Complete
Connection Active Connection Type, Active Server, Active DB User, Original Server, Original Server Type, Original DB User, Custom Server, Custom Server Type, Custom DB User, OLAP Datasource?
Flags Crystal Doc contains a Sub Report?, Crystal Doc has Command Text (directly or in Sub Report)?

Prompts

Prompt Required Answer What it does
Environments No Pick one or more Environments to include, listed by CMSID with their description. Leave empty for all. The prompts below list only values from the environments you pick.
FolderTypes No Pick one or more Folder types to include.
FolderPath Yes Pick one Folder path pattern, matched with LIKE. Enter % for all folders.
Folders No Pick one or more Folders to include. The list depends on the prompts above.
DB Users No Pick one or more Database user names to look for, checked against the original and the custom (overridden) user.

Image of the MM-C15 Prompts dialog with Environments answered

../images/reports/mm-c15-prompts.png

Legacy image for reference: images/mmsr_prompt_MM-C15.png

Input controls

Display controls change how the report shows its data:

Input control What it does
Prompt Selection Shows or hides the block under the header that lists your prompt answers. Spaced (default) shows it with a space between list items, Show shows it without spacing, Hide hides it.
Environment / CMSID Shows environments in the report body by display name or by CMSID. Filters and prompts always list CMSIDs.
Folder / Complete Shows the folder name or the complete folder path.

Filter controls keep only the rows that match the values you pick: Environment, Folder, Active DB User, Original DB User, Document contains a Sub Report?.

Image of the MM-C15 Input Controls panel

../images/reports/mm-c15-input-controls.png

Legacy image for reference: images/mmsr_ICs_C15.png

Link Opens
Document name Opens the report in BI launch pad.
Command Text drill Opens [MM-C17] Command Text Use for that report.

A drill link opens the target report through BI launch pad OpenDocument and passes the environment and the selected item as prompt answers.

Run the report

  1. In BI launch pad, open [MM-C15] Crystal IA - DB User Use from the folder where you imported the standard report pack.
  2. Refresh the document and answer the prompts. Keep FolderPath at % to include all folders.
  3. Use the input controls to change the display or narrow the results.

Data it needs: Crystal Reports document processing (tables, fields, connections, Business Views and prompt groups). See Document Processing.