2
OVERVIEW
HP Web Jetadmin is a printer management solution that gathers information from devices and
presents the data in a multitude of formats to meet customer needs. Information pertaining to device
assets, consumables, and page counts can be displayed in device lists or reports. This same data can
be stored in Microsoft
®
SQL database views if an optional Database Connectivity license is installed.
Through database views, users can directly access exported device list or report data stored in a SQL
database. This allows for building business intelligence reports, such as Crystal Reports, directly on
the device data exposed by the HP Web Jetadmin database views. Administrators can use the
exposed database views of the device data to extract, transform, and load (ETL) the data into an
enterprise’s data warehouse.
DATABASE CONNECTIVITY LICENSE
HP Web Jetadmin 10.2 SR6 and later automatically includes the ability to store data collections to
SQL database views without the need for a license. Data that is collected for reports in HP Web
Jetadmin is written to a database view on a scheduled basis. Either the HP Web Jetadmin
background poller or the scheduled data collections for reports generates the data that is populated in
these database views. However, user-defined exports of column data to database views still require a
license for all versions of HP Web Jetadmin. The license can be obtained by browsing to
www.hp.com/go/wja
, and clicking the Web Jetadmin Extended Modules link. This module allows
HP Web Jetadmin users to do the following:
• Export device lists and store data collections to SQL database views
The licenses are node-locked to an IP address. A separate license is needed for each HP Web
Jetadmin server. A Connectivity Welcome Letter and an Instructions document is supplied when a
license is requested from HP. These documents explain how to obtain and install a license.
DATABASE VIEWS
HP Web Jetadmin collects data from devices and stores the data in SQL database tables. Device lists
display the data the user requires in columns that can be sorted or filtered. Device data can be
exported to .csv or .xml files for viewing and manipulating in applications such as Microsoft Excel.
Device data can be displayed in canned or custom reports that HP Web Jetadmin generates to meet
user needs. In addition, this same data can be written to SQL database views and accessed by asset
and reporting tools if the optional Database Connectivity license is installed. Data in the following
areas can be written to the database views in HP Web Jetadmin:
• Data exports
• Reports data collections
DATA EXPORTS
Device data can be exported from any device list or device group by selecting the devices, right-
clicking the selection, and selecting Export. The Export Devices wizard can also be launched from
Tools > Export devices. Data exports can be scheduled to run at any interval. No matter which
technique is used, the user can dictate the devices, data, and accuracy of the data that is written to a
database view.
Accuracy of exported data
When the Export Devices wizard is launched, a threshold level can be set to specify the accuracy of
the data that is exported (Figure 1). The following threshold levels can be selected:
(278 paginas)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales