HP Web Jetadmin - Database Views in HP Web Jetadmin

8
USING THE DATABASE VIEWS
Once data resides in the database views, SQL Server Studio Express can be used to browse the
contents of each view (see Figure 5). Simply log in to the HPWJA SQL instance and navigate to the
Databases, HPWJA, Views folder. Any views created by using the export feature of HP Web Jetadmin
are displayed by the name that was provided for the view during the export. Right-clicking a view
and selecting Open View displays the contents of that view. Each column that was set to be included
in the export is displayed with a programmatic name as the column header. See “Appendix C” for a
schema to match programmatic names to names as they are displayed in the HP Web Jetadmin user
interface.
The following database views also appear in the list of views as a result of data being collected either
by the background poller or, optionally, reports data collections (see “Appendix B” for more
information):
 PUBLIC_CON_INFO
 PUBLIC_CONSUMABLES_INFO—Requires Supplies Utilization data collections
 PUBLIC_CONSUMABLES_USE—Requires Supplies Utilization data collections
 PUBLIC_DEV_CON_INFO
 PUBLIC_DEV_INFO
 PUBLIC_DEVICE_GROUP_PUBLIC_JOB_TYPE_USE—Requires Data Utilization data collections
 PUBLIC_MEDIA_CHARGE—Requires Data Utilization data collections
 PUBLIC_MEDIA_COLOR_USE—Requires Data Utilization data collections
Figure 5—SQL Studio Express database views