HP Storage Essentials V5.1 User Guide Second Edition (Linux Release) (T4283-96056, November 2006)

Configuring the Management Server212
2. Enter the following at the command prompt:
Sql>col lastRefresh format a30
This command ensures the data is displayed in a readable format.
3. Enter the following at the command prompt on one line with a space between the closing
parenthesis and lastRefresh:
Sql> select mviewname, to_char(last_refresh_time,'mm/dd/yyyy hh24:mi:ss')
lastRefresh,
4. Enter the following at the command prompt:
status
5. Enter the following at the command prompt:
from mviewcore_status
6. Enter the following at the command prompt:
order by 2;
Managing Collectors for Reports
The management server uses statistics collectors to gather information for reports. To view a report
you must have its corresponding collector running.
IMPORTANT: All collectors are stopped during Get Details/Discovery Data Collection. This means
that during Get Details/Discovery Data Collection data, such as for reports is not updated.
NOTE: It is not possible to run data collectors on quarantined elements. Attempting to run data
collectors on quarantined elements will result in exceptions in the appiq.log file.
To view collectors for reports, click Reports > Storage Essentials > Report Configuration in HP
Systems Insight Manager. Then, click the Data Collection tab.
Table 23 About Collectors for Reports
Column Heading Description
Element The name of the element from which this collector gathers information.
Element Type The type of element from which the collector gathers information.
Reports The reports the collector is responsible for providing information.
Next Scheduled
Run
Displays the date and time when the collector is scheduled to run.
Interval The interval in minutes the collector runs.
Running? Gives the status of the collector. Collectors that are running display a
check mark in this column.