Gathering information about printers and print jobs

Collecting information about print jobs

Using the Job Statistics: Trend Analysis and Job Statistics: Collect From Disk tasks, MarkVision Professional can gather and store information about each print job sent to a specific device. The information includes data such as job size, job duration, output bins used, and so on. Users can view the collected information using a database tool or an application specifically designed to interpret and display the information.

Administrators can use the information gathered by the Job Statistics task to answer questions such as:

When users enable the Job Statistics: Trend Analysis task for a device, MVP registers with the device and then continually collects alert information, writing it to the connected database. However, any alerts that occur when network traffic is heavy or when the MVP server is down may be missed. This task does not require that the selected device contain a built-in hard drive.

When the Job Statistics: Collect From Disk task is scheduled, MVP collects the data from information stored on the device itself. Because it is not affected by heavy network traffic or an interrupted connection with the MVP server, this is generally the more reliable of the two tasks; however, it can only be scheduled on devices containing a built-in hard drive.

Notes:

Supported database management systems in MVP 11.2.1

Type of database

Operating system

CSV

Windows, UNIX/Linux

Oracle1

Windows (10g), UNIX/Linux (10g)

Microsoft Access

Windows (Access 2002, Access 2003, Microsoft Office Access 2007)

Microsoft SQL Server

Windows (SQL Server 2005, SQL Server 2005 Express Edition)


Enabling Job Statistics

  1. From the MarkVision Professional Home screen, select Job Statistics: Trend Analysis from the All Tasks menu.

  2. Select the type of database where the Job Statistics information will be stored.

    Note: MVP supports Access and SQL Server databases, as well as CSV format (comma-separated values). The table below shows the path styles used for each type of database.
  3. Enter or select the appropriate information for the database:

    • Access or SQL Server—Enter the URL, User Name, and Password for the database. The URL is the path to the database used to monitor this server.

    • CSV—Browse to or specify the full path of the directory in which CSV data will be stored.

  4. Select the printers to be monitored. Click All Printers to monitor all devices on the MVP Server, or click Selected Printers to choose specific devices on the MVP Server. Select those devices using the Quick Find or Folders tabs. Use Ctrl + click and Shift + click to select multiple devices.

  5. Select Include Device Status Alerts if you want the database to include information about status events such as paper jams and out-of-paper alerts for the selected device(s).

  6. Click Apply.

  7. Note: To collect Job Statistics at a specific time, select the Job Statistics: Collect From Disk option in the Scheduling task in the All Tasks list.

Database

Description

Access, SQL Server

<database driver>:<DSN>

For example: jdbc:odbc:yourdsn

DSN is a Data Source Name that must be created prior to using Job Statistics or Printer Inventory. Use the ODBC configuration in the Windows Control Panel to create a DSN.

Note: Exporting this information through an ODBC interface is only supported in a Windows environment.

CSV

Using the CSV format allows users to export printer data into a text file formatted to accommodate database fields. Enter the directory address where the text file will be created on the network or computer.

For example: C:\temp\printerinventory\home


Collecting information about printers

Using the Printer Inventory task, MarkVision Professional can gather and store information about the devices on a network. Users can then view the collected information (printer inventory) using a database tool or an application specifically designed to interpret and display the information.

Administrators can use the information gathered during the printer inventory process to answer questions such as:

Enabling Printer Inventory

  1. From the MarkVision Professional Home screen, select Printer Inventory from the All Tasks menu.

  2. Select the type of database where the printer inventory information will be stored.

    Note: MVP supports Access and SQL Server databases, as well as CSV format (comma-separated values). The table below shows the path styles used for each type of database.
  3. Enter or select the appropriate information for the database:

    • Access or SQL Server—Enter the URL, User Name, and Password for the database. The URL is the path to the database used to monitor this server.

    • CSV—Browse to or specify the full path of the directory in which CSV data will be stored.

  4. Select the printers to be monitored:

    • Click All Printers to monitor all devices on the MVP Server.

    • Click Selected Folders to monitor devices in specific MarkVision folders, and then select the appropriate folder(s).

    • Click Selected Printers to choose specific devices on the MVP Server, and then select devices using the Quick Find or Folders tabs. Use Ctrl + click and Shift + click to select multiple devices.

  5. Click Apply.

Database

Description

Access, SQL Server

<database driver>:<DSN>

For example: jdbc:odbc:yourdsn

DSN is a Data Source Name that must be created prior to using Job Statistics or Printer Inventory. Use the ODBC configuration in the Windows Control Panel to create a DSN.

Note: Exporting this information through an ODBC interface is only supported in a Windows environment.

CSV

Using the CSV format allows users to export printer data into a text file formatted to accommodate database fields. Enter the directory address where the text file will be created on the network or computer.

For example: C:\temp\printerinventory\home