Report refresh status – HP Storage Essentials Enterprise Edition Software User Manual
Page 240
Configuring the Management Server
202
Report Refresh Status
The management server has two types of views for its reports. During a report cache refresh, these
views are updated. You can check the status of the following views as described in this section:
•
MVIEWCORE_STATUS - This table keeps track of the refresh status of the core views. The core
views are the views starting with mvc, mvca and mvcs as shown in
on page 461. To
obtain detailed information of MVIEWCORE_STATUS, see
•
MVIEW_STATUS - This table keeps track of the refresh status of the regular views, which are
views starting with mv_, as shown in
on page 461. To obtain detailed information
about the MVIEW_STATUS, see
To query the MVIEW_STATUS table:
1.
Enter the following at the command prompt:
Sqlplus appiq_system/password
where password is the password for the appiq_system account.
2.
Enter the following at the command prompt:
Sql>col lastRefresh format a30
This command ensures that 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 mview_status
6.
Enter the following at the command prompt:
order by 2;
To query the MVIEWCORE_STATUS table:
1.
Enter the following at the command prompt:
Sqlplus appiq_system/password
where password is the password for the appiq_system account.
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