78 Certification Guide Series: IBM Tivoli Provisioning Manager V5.1
4.6 Reports
Reports are used to retrieve current information about data center inventory,
activity, and system compliance. You find the following report categories in the
Web interface reports:
򐂰 Audit reports
򐂰 Inventory reports
򐂰 Compliance reports
򐂰 Discovery reports
򐂰 Deployment reports
򐂰 Other reports
You can edit existing reports or create new ones. Click Edit Add a Report in a
report category and enter the settings in the wizard:
1. When the Report Description dialog is displayed:
a. Enter a name (required).
b. Enter a description.
c. Select a category.
d. Enter a type.
e. Select an access group from the list.
f. Click Next.
2. When the Report Constraints dialog is displayed:
a. Select one or more views from Available Views to include in the report.
b. Optionally apply report filters using the Available Fields.
c. Click Next.
3. When the Report Layout dialog is displayed:
a. Select the fields to show in the report design.
b. Optionally apply a calculation to any selected field, for example, count.
c. Select the order. This equals the ORDER BY statement in SQL.
d. Select the grouping. This equals the GROUP BY statement in SQL.
e. Select the format from the output drop down list, for example, PDF, HTML,
CSV.
f. Selecting a Drill Down Field enables the option to click the selected field in
the report result. The field then provides a link to the object information
page.
g. Click Next.
4. The Report Summary dialog is displayed.
a. You can modify and verify the SQL statement of the report.
Chapter 4. Configuration 79
b. Click Verify to make sure the report runs successfully and returns a result.
c. Select Now to save and run the report immediately, schedule a time to
run, or select Save without Running.
d. Click Finish.
Table 4-1 shows a selection of available views from the report constraints page,
and how they relate to the actual views and column names in the database.
Table 4-1 Available report views
View name and description Database view Column name
access group: all
The access groups associated
to a user.
accessgroup_cus_view END_USER_ID
NAME
IS_SUPERUSER
INSTANCE_ACCESS_ROLE_ID
ACCESS_DOMAIN_ID
ACCESS_GROUP
ACCESS_GROUP_DESCRIPTION
base_audit: all
Changes to software or
hardware on computers.
base_audit_view SYSTEM_ID
USERNAME
INSTALL_TIME
TYPE
RESOURCE_ID
OPERATION
base_deployment: all
Identifies the software that has
changed on computers.
base_deployment_view MANAGED_SYSTEM_ID
USERNAME
INSTALL_TIME
SOFTWARE_MODULE_ID
INSTALL_STATE
endpoints: all
Tivoli Common Agent status
information.
endpoint_inv_view SERVER_ID
AGENT_UNIQUE_NAME
DESCRIPTION
LAST_CONTACT_TS
LAST_ATTEMPT_TS
AGENT_START_TS
LAST_BOOT_TS
LAST_ERROR_MSG_TS
LAST_ERROR_MSG
LAST_REPORT_TS
80 Certification Guide Series: IBM Tivoli Provisioning Manager V5.1
hardware inventory: all
Details about the hardware on
computers.
hardware_inventory_view SYSTEM_ID
TYPE
RESOURCE_NAME
RESOURCE_ID
GROUP_NAME
MANAGED
PARTITIONABLE
PROPERTY
PROPERTY_VALUE
hardware inventory: all
Details about the hardware on
computers.
hardware_inventory_view SYSTEM_ID TYPE
RESOURCE_NAME
RESOURCE_ID GROUP_NAME
MANAGED PARTITIONABLE
PROPERTY PROPERTY_VALUE
login history: all
Tracks login history.
login_aud_view USERNAME
SUCCESSFULL_LOGIN
ENTRY_POINT
TIME_OF_LOGIN
os: all
Information about operating
systems.
os_info_view MANAGED_SYSTEM_ID
MODULE_ID
OS_NAME
OS_VERSION
software instance: all
The software that is installed on
computers, without details.
instance_on_sys_base_view RESOURCE_ID
MODULE_ID
SYSTEM_ID
IS_PENDING
CURRENT_STATE
DESIRED_STATE
software: all
The available software in
software catalog.
software_info_view MODULE_ID
SOFTWARE
VENDOR
VERSION
DESCRIPTION
TYPE
View name and description Database view Column name

Get Certification Guide Series: IBM Tivoli Provisioning Manager V5.1 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.