HP Web Jetadmin - Database Views in HP Web Jetadmin

16
Consumables utilization view (PUBLIC_CONSUMABLES_USE_VW)
Attribute name
Data type
Description
device_guid
varchar(36)
A GUID that serves as a unique identifier for the device.
connection_guid
varchar(36)
A GUID that serves as a unique identifier for a
communication interface.
consumable_info_id
int
An integer that identifies the entry in the
PUBLIC_CONSUMABLES_INFO_VW view that contains the
information about this consumable for this device.
collection_time
datetime
The time (based on server time) when the consumables
data was collected.
level_value
int
The estimated level of the consumable in the same units as
the maximum_capacity attribute of the
PUBLIC_CONSUMABLES_INFO_VW view. This attribute
might also contain negative values that have the following
meanings: level value empty (-1), level value low (-2), level
value unknown (-3), level value out (-4), level value failure
(-5), level value OK (-6).
percent_remaining
int
The estimated percentage of the consumable remaining.
This attribute might also contain negative values that have
the following meanings: level value empty (-1), level value
low (-2), level value unknown (-3), level value out (-4), level
value failure (-5), level value OK (-6).
supply_coverage
decimal(5,2)
The estimated percent average coverage of the
consumable per page.
pages_remaining
int
The estimated number of pages remaining before the
consumable must be replaced.
current_page_count
int
The number of page impressions that have been printed
using this consumable while it has been in this device.
Consumables information view (PUBLIC_CONSUMABLES_INFO_VW)
Attribute name
Data type
Description
device_guid
varchar(36)
A GUID that serves as a unique identifier for the device.
connection_guid
varchar(36)
A GUID that serves as a unique identifier for a
communication interface.
consumable_info_id
int
A unique integer that identifies a row view that can be
used to identify the consumables information for an entry in
the PUBLIC_CONSUMABLES_USE_VW view.
install_date
datetime
The date that the consumable was installed in the device.