HP Web Jetadmin Software Manual do Utilizador descarregar pdf (Página 6)

USE THE DATABASE VIEWS

After data resides in the database views, SQL Server Studio Express can be used to browse the

contents of each view (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. For a schema to

match programmatic names to names as they are displayed in the HP Web Jetadmin user interface,

see Appendix C—Naming schema.

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. For more information, see Appendix

B—Data dictionaries for database views.

• 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

1 2 3 4 5 6 7 8 9 10 11 ... 26 27

Sem comentários

HP Web Jetadmin Software Manual do Utilizador Página 6