background image

MarkVision Professional 10.2

June 1, 2004

MarkVision Professional 10.2

Page 14

3.2.1 RAWPRNINV

This is the master table for Printer Inventory. It contains data such as address, protocol, capability
of the device, revision level, RAM size, etc.

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

.

START_TIME_UTC

NUMBER(10)

MVP 7.1

Time at which this printer
inventory was initiated, in
seconds elapsed since
0:00:00, Jan 1, 1900,
GMT.

DEVICE_ID

VARCHAR2(255)

MVP 7.1

String identifier Granite
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 device
inventory was initiated.

MONTH

NUMBER(2)

MVP 7.1

Month in which this
device inventory was
initiated.

DAY

NUMBER(2)

MVP 7.1

Day of the month in which
this device inventory was
initiated.

DAY_OF_WEEK

NUMBER(1)

MVP 7.1

Day of week on which
this device inventory was
initiated.

HOURS

NUMBER(2)

MVP 7.1

Hour of the day in which
this device inventory was
initiated.

MINUTES

NUMBER(2)

MVP 7.1

Minute of the hour in
which this device
inventory was initiated.

SECONDS

NUMBER(2)

MVP 7.1

Seconds of the minute in
which this device
inventory was initiated.

GMT_OFFSET_IN_SECONDS

NUMBER(5)

MVP 7.1

Offset from GMT of the
current time zone, in
seconds.  This is an
integer from -43200 to
43200.

IS_USING_DST

VARCHAR2(1)

MVP 7.1

Does the current time
zone use Daylight
Savings Time?  Possible
values = "Y" for true, "N"
for false.

DST_OFFSET_IN_SECONDS

NUMBER(4)

MVP 7.1

Offset from Standard
Time of the current time
zone, in seconds.

DATA_SOURCE

VARCHAR2(32)

MVP 7.1

Where did this record
come from?  Possible
Values:  'Granite V.x.x’

Summary of Contents for MarkVision Professional

Page 1: ...MarkVision Professional 10 2 Data Export June 1 2004 Lexmark International Inc 740 New Circle Road Lexington KY 40550...

Page 2: ...information you supply in any way it believes appropriate without incurring any obligation to you You can purchase additional copies of publications related to this product by calling 1 800 553 9727...

Page 3: ...OPTION 22 3 2 9 RAWPIINPUTOPTION 23 3 2 10 RAWPIINPUT 24 3 2 11 RAWPIOUTPUTOPTION 24 3 2 12 RAWPIOUTPUT 25 3 2 13 RAWPIDEVICESTATUS 27 3 2 14 RAWPISTATSJOBS 27 3 2 15 RAWPISTATSPAPER 28 3 2 16 RAWPIST...

Page 4: ...MarkVision Professional 10 2 June 1 2004 MarkVision Professional 10 2 Page 4 6 Data Type Conversion 54...

Page 5: ...7 2000 2002 Comma separated variable CSV NOTE The Oracle database option is only available after installing the up to date MVP Plug in for Oracle JDBC Driver support 2 1 2 UNIX Oracle versions 8i thro...

Page 6: ...System DSN dialog box click Add and the following dialog box will appear Select Microsoft Access Driver mdb and click Finish After clicking Finish the following dialog box will appear Think of a name...

Page 7: ...ready created for this purpose or choose Create to define a new database and location Click on Create and the following dialog box will appear Browse to the desired directory and specify a name to be...

Page 8: ...the path to the actual database file this was defined while creating the connection For the example just described enter jdbc odbc MVP If you have enabled security features while creating the database...

Page 9: ...ng the properties button in Windows 2000 and beyond Select This Account to log on to the new machine as a user with appropriate network access privileges and click OK 2 2 2 SQL Server The method for c...

Page 10: ...r the user name and password and click on OK 2 4 CSV Users may elect to export database information to a CSV format In MarkVision Professional after selecting the CSV database selection the Directory...

Page 11: ...ation gathered by the printer inventory process to answer questions such as How many printers do we have on our server s network What types of printers do we have What options are installed on our pri...

Page 12: ...arkVision Professional 10 2 Page 12 3 1 Configuring MarkVision Professional Open the MarkVision Professional client Select Actions on the toolbar and then Printer Inventory from the drop down list or...

Page 13: ...Follow database specific instructions in the Configuring Database Driver section 3 2 Table and Field Descriptions The tables and descriptions of each field are listed below The data types listed for e...

Page 14: ...ntory was initiated MONTH NUMBER 2 MVP 7 1 Month in which this device inventory was initiated DAY NUMBER 2 MVP 7 1 Day of the month in which this device inventory was initiated DAY_OF_WEEK NUMBER 1 MV...

Page 15: ...VP 7 1 Model name of device SERIAL_NUMBER VARCHAR2 32 MVP 7 1 Device serial number RAM_SIZE NUMBER 10 MVP 7 1 Total amount of main memory on this device SPEED NUMBER 10 MVP 7 1 Speed at which this dev...

Page 16: ...lable on certain older printers WARNING Only valid with job buffering version 1 See the device s capability list IS_COMMUNICATING VARCHAR2 1 MVP 7 1 Always set to Y MAC_ADDRESS VARCHAR2 12 MVP 7 1 The...

Page 17: ...performs SQL queries on the printer inventory data should check the DATA_READY field before displaying that data to the user If DATA_READY N this row should be ignored along with any data correspondin...

Page 18: ...itiated in seconds elapsed since 0 00 00 Jan 1 1900 GMT VERSION NUMBER 5 MVP 7 1 Version of the data format used in this table NAME VARCHAR2 64 MVP 7 1 Physical port name Possible Values Fax n 4 n 1 I...

Page 19: ...is interpreter supports in this printer defined as the resolution in the direction 90 degrees to the feed or motion of the print media VERT_RESOLUTION NUMBER 5 MVP 7 1 This value defines the maximum v...

Page 20: ...the type of supply This attribute is always present Possible Values Container Drum Fuser Ink Oil Process Cartridge Staples Toner Transfer Belt Print Head Thin Coat Fuser Cleaner Pickup Roller COLOR VA...

Page 21: ...is information will not be available on every printer family 3 2 6 RAWPIFONTOPTION This table contains records pertaining to the fonts available on the selected device Field Name Data Type Supported M...

Page 22: ...e data format used in this table NAME VARCHAR2 64 MVP 7 1 Item to which the listed CODE_LEVEL applies e g engine flash panel etc CODE_LEVEL VARCHAR2 50 MVP 7 1 Code version of the item indicated by NA...

Page 23: ...T_TIME_UTC NUMBER 10 MVP 7 3 Time at which this device inventory was initiated in seconds elapsed since 0 00 00 Jan 1 1900 GMT DEVICE_ID VARCHAR2 255 MVP 7 3 String identifier MarkVision uses to ident...

Page 24: ...name CAPACITY NUMBER 10 MVP 7 1 The capacity CAPACITY_UNITS VARCHAR2 40 MVP 7 1 The units CURRENT_LEVEL NUMBER 10 MVP 7 1 The current level FORM_SIZE VARCHAR2 40 MVP 7 1 The form size FORM_TYPE VARCH...

Page 25: ...ome fields For more specific information please contact Lexmark Customer Support at http support lexmark com START_TIME_UTC NUMBER 10 MVP 7 1 Time at which this device inventory was initiated in secon...

Page 26: ...pports this feature Possible values Y for true N for false IS_COLLATION VARCHAR2 1 MVP 7 1 Specifies if this output device supports this feature Possible values Y for true N for false IS_SEPARATION VA...

Page 27: ...Empty Input Low Tray Missing LOCATION_ID VARCHAR2 64 MVP 10 0 Specifies the Input Trays like Tray 1 Tray 2 GRAPHIC_ID NUMBER 3 MVP 10 0 Specifies the graphic Id SEVERITY VARCHAR2 32 MVP 10 0 Specifies...

Page 28: ...the data is expressed Possible Values Pages Percent DATA NUMBER 10 MVP 10 0 Column Column value will exist For Single record Type CAPACITY NUMBER 10 MVP 10 0 Column Column value will exist For List re...

Page 29: ...Plain Paper Colored Paper Transparency Card Stock Labels Letterhead Preprinted Bond Envelope Coated Paper Glossy Paper Iron On Photo Paper Greeting Card Custom Type 1 Custom Type 2 Custom Type 3 Custo...

Page 30: ...please contact Lexmark Customer Support at http support lexmark com DEVICE_ID VARCHAR2 255 MVP 10 0 String identifier MarkVision uses to identify this device START_TIME_UTC NUMBER 10 MVP 10 0 Time at...

Page 31: ...r Statistics 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...

Page 32: ...MVP 10 0 The type of value Possible Values Integer Date Float UNITS VARCHAR2 64 MVP 10 0 The unit in which the data is expressed Possible Values Pages Percent DATA NUMBER 10 MVP 10 0 Column Column val...

Page 33: ...AR2 255 MVP 10 0 String identifier MarkVision uses to identify this device START_TIME_UTC NUMBER 10 MVP 10 0 Time at which this device inventory was initiated in seconds elapsed since 0 00 00 Jan 1 19...

Page 34: ...Inventory is RAWPRNINV with one to many relationships established between the top two fields DEVICE_ID and START_TIME_UTC NOTE The new table for MVP 7 3 RAWPIINPUTOPTION has the same relationship val...

Page 35: ...MarkVision Professional Job Statistics Trend Analysis tells the printer to send an alert to the server each time a job is sent Job Statistics Collect From Disk tells the selected printer s to store t...

Page 36: ...abase Follow database specific instructions in the Configuring Database Driver section The Selected Printers list display any printers you have asked the server to monitor for Job Statistics alerts Th...

Page 37: ...e status tables when an error or warning condition is encountered Please see the Device Status section for more information This will increase network traffic 4 1 2 Job Statistics Collect From Disk Op...

Page 38: ...ng screen should be displayed Select the Add button to add scheduled events for Job Statistics Collect From Disk The Add Schedule Wizard screen should be displayed Select the Job Statistics Collect Fr...

Page 39: ...e scheduling parameters as desired and click Next Step 3 of the Add Schedule Wizard should be displayed Select the appropriate database Follow database specific instructions in the Configuring Databas...

Page 40: ...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 Conversio...

Page 41: ...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 NUMB...

Page 42: ...The sheet count ERROR_CODE VARCHAR2 32 MVP 7 1 Possible Values None No Dial Tone No Answer Busy Line Dropped Error In T30 Protocol Modem Error Out Of Memory Cancelled ACCOUNT_NUMBER VARCHAR2 32 MVP 7...

Page 43: ...device JOB_ID NUMBER 5 MVP 7 1 Job id assigned by 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...

Page 44: ...hat submitted this job FORMAT VARCHAR2 32 MVP 7 1 Possible Values PDF JPEG TIFF COMPOSITION VARCHAR2 32 MVP 7 1 Possible Values 1 Bit 3 Bit 4 Bit 8 Bit 24 Bit 32 Bit DESTINATION_TYPE VARCHAR2 32 MVP 7...

Page 45: ...ected 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 NU...

Page 46: ...n 4 n 1 Internal n 3 n 1 LocalTalk n 4 n 1 Network n 6 n 1 Parallel n 4 n 1 Serial n 4 n 1 USB n 4 n 1 NetworkStd JOB_SIZE_IN_BYTES NUMBER 10 MVP 7 1 The size of the job INTERPRETER_NAME VARCHAR2 32...

Page 47: ...t the time of this job DESTINATION_TYPE NUMBER 3 MVP 7 1 The destination type JOB_NAME VARCHAR2 150 MVP 7 1 Name associated with this job HOST_NAME VARCHAR2 55 MVP 7 1 The name of the host machine USE...

Page 48: ...Failure Staple Too Many Pages Failure Printer Sent Command To Flush Output Bin Changed Failure Paper Jam Failure Staple Jam failure Other Failure PUNCHED VARCHAR2 1 MVP 10 0 Indicates punching status...

Page 49: ...VARCHAR2 64 MVP 7 1 Possible Values Envelope Feeder Feeder 2 Manual Envelope Feeder Manual Paper Feeder Multipurpose Feeder Tray n where 5 n 1 SHEET_COUNT NUMBER 10 MVP 7 1 Number of physical sheets e...

Page 50: ...acity of the supply CURRENT_LEVEL NUMBER 10 MVP 7 1 The current level Used by MarkVision Professional to calculate the percentage full CURRENT_PRINT_LEVEL NUMBER 10 MVP 7 1 The current print level Les...

Page 51: ...Card Stock Labels Letterhead Preprinted Bond Envelope Coated Paper Glossy Paper Iron On Photo Paper Greeting Card Custom Type 1 Custom Type 2 Custom Type 3 Custom Type 4 Custom Type 5 Custom Type 6 SH...

Page 52: ...curred 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 S...

Page 53: ...sion server is running MESSAGE_ID VARCHAR2 255 MVP 7 1 The description of the alert LOCATION_ID VARCHAR2 255 MVP 7 1 The location of the device status alert SEVERITY VARCHAR2 32 MVP 7 1 The severity o...

Page 54: ...he printer s op panel NOTE This information is not available on every printer model 5 3 Field Relationships 6 Data Type Conversion Data types are listed specific to Oracle databases When writing to Mi...

Page 55: ...MarkVision Professional 10 2 June 1 2004 MarkVision Professional 10 2 Page 55 Oracle Microsoft SQL Server NUMBER x NUMERIC x VARCHAR2 x VARCHAR x...

Reviews: