MarkVision Professional 10.2
June 1, 2004
MarkVision Professional 10.2
Page 52
5. Device
Status
MarkVision Professional allows you to collect device status information for a particular printer or
group of printers. With the collected data you can create reports, perform trend analysis, etc. See
Configuring Database Driver
for a description of supported databases.
5.1 Configuring
MarkVision
Professional
Device Status
collection is configurable in the
Job Statistics (Trend Analysis)
task. For more
information on this task, see the
Job Statistics (Trend Analysis)
section.
5.2
Table and Field Descriptions
The tables and descriptions of each field are listed below. The data types listed for each field
listed are specific to Oracle databases. Please reference the
Data Type Conversion
section for
converting to Microsoft Access or SQL Server data types.
5.2.1 RAWDEVICESTATUS
This table contains records of status messages and alerts, along with the times they occurred.
Only the oldest and most significant status condition is populated in this table. Reference the
RAWDSDEVICESTATUS
table for a complete description of all status conditions.
Field Name
Data Type
Supported
MVP Release
Description
Note:
All printers may not support some fields. For more specific information, please contact Lexmark
Customer Support at
http://support.lexmark.com
.
TIME_UTC
NUMBER(10)
MVP 7.1
Time at which this job
was detected by
MarkVision, in seconds
elapsed since 0:00:00,
Jan 1, 1900, GMT.
DEVICE_ID
VARCHAR2(255)
MVP 7.1
String identifier
MarkVision uses to
identify this device.
VERSION
NUMBER(5)
MVP 7.1
Version of the data format
used in this table.
YEAR
NUMBER(4)
MVP 7.1
Year in which this job was
detected by MarkVision.
MONTH
NUMBER(2)
MVP 7.1
Month in which this job
was detected by
MarkVision.
DAY
NUMBER(2)
MVP 7.1
Day of the month on
which this job was
detected by MarkVision.
DAY_OF_WEEK
NUMBER(1)
MVP 7.1
Day of week on which
this job was detected by
MarkVision.
HOURS
NUMBER(2)
MVP 7.1
Hour of the day in which
this job was detected by
MarkVision.
MINUTES
NUMBER(2)
MVP 7.1
Minute of the hour in
which this job was
detected by MarkVision.
