
4
Select the devices to be
exported
If the Export Devices wizard is
launched from Tools > Export
devices, the Select Devices page
is displayed for selecting the
devices that are included in the
export. If the Export Devices
wizard is launched by right-
clicking and selecting Export
from the device list, only the
devices that are already selected
in the device list are included in
the export.
Select the destination
After the columns and devices
are selected, the destination for
outputting the data can be
selected (Figure 2). Selections
include the following:
• Local file: Exports to a local file on the client PC. The user is prompted for a file name and
location after the data is collected and is ready to be written.
• Email: Sends the data to an email address. Enter the email address on this page or browse for the
correct email address. For the file format, select CSV or XML. The file is added to the email as an
attachment.
• Server file: Exports the device list to a specific file name and path on the HP Web Jetadmin
server. The location cannot be edited. If a file of the same name already exists in the location, a
timestamp is added to the name of the export file.
• Database: Stores the data in a SQL database view.
Export the data to the database views
If Database is selected as the export destination, HP Web Jetadmin prompts for a database view
name. After the name is entered, a view is created in the SQL database that contains the data for all
the devices and columns selected for the export. Using Microsoft SQL Server Management Studio
Express, log in to the HP Web
Jetadmin instance, open the
Views folder, right-click the view
name that was entered in HP
Web Jetadmin (the name is
preceded by dbo), and select
Open View to see the data that is
stored for each device and
column that was selected for the
export (Figure 3). Enterprise
tools, such as Crystal Reports,
can be easily instructed to open
this view and retrieve the
2—Specify destination settings
3—Database view in SQL Studio Express
Kommentare zu diesen Handbüchern