additional-faqs-for-universal-print-driver-version
additional-faqs-for-universal-print-driver-version
Error when Using Copy Printer Settings Feature on Embedded Web Server
Error when Using Copy Printer Settings Feature on Embedded Web Server
List of Printers that Support Link Layer Topology Discovery
List of Printers that Support Link Layer Topology Discovery
snmpv3-password-field-displays-blank-after-submitt
snmpv3-password-field-displays-blank-after-submitt
Configuration of the MarkNet N8050 Internal Wireless Adapter
Configuration of the MarkNet N8050 Internal Wireless Adapter
Printing the Menu Settings Page on most touchscreen printers and MFPs
Printing the Menu Settings Page on most touchscreen printers and MFPs
How to Locate the Serial Number, Machine Type, and Configuration ID on a Lexmark C746, C748 or X746, X748 Printer/MFP
How to Locate the Serial Number, Machine Type, and Configuration ID on a Lexmark C746, C748 or X746, X748 Printer/MFP
how-to-retract-the-autocomp-paper-pick-unit-in-the
how-to-retract-the-autocomp-paper-pick-unit-in-the
how-to-create-a-device-quotas-fac-configuration-fi
how-to-create-a-device-quotas-fac-configuration-fi
how-to-determine-hard-disk-status-and-remotely-act
how-to-determine-hard-disk-status-and-remotely-act
How to Configure Lexmark Print Management Full Data Export for MSSQL Database
How to Configure Lexmark Print Management Full Data Export for MSSQL Database
How to Set Retention Time for Released Jobs via LPM Print Release
How to Set Retention Time for Released Jobs via LPM Print Release
How to Set LDD to discover IP addresses Ending in .0 and .255
How to Set LDD to discover IP addresses Ending in .0 and .255
how-to-set-up-color-print-permission-in-mve-24x-ho
how-to-set-up-color-print-permission-in-mve-24x-ho
How to Print a Booklet Using the PostScript Driver on a Laser Printer
How to Print a Booklet Using the PostScript Driver on a Laser Printer
Creating a peer to peer network connection with standard Ethernet cable
Creating a peer to peer network connection with standard Ethernet cable
How to configure Lexmark devices for Common Access Card when using PIV certificate
How to configure Lexmark devices for Common Access Card when using PIV certificate
device-is-no-longer-discoverable-by-ldd-server-so7
device-is-no-longer-discoverable-by-ldd-server-so7
Printer Driver Configuration Unchecked when Computer Hibernates or Sleeps
Printer Driver Configuration Unchecked when Computer Hibernates or Sleeps
MVE Errors when Adding a Database from Lower to Newer Versions
MVE Errors when Adding a Database from Lower to Newer Versions
Secure Held Print Jobs Icon Does Not Display on the Control Panel After Installation
Secure Held Print Jobs Icon Does Not Display on the Control Panel After Installation
Testing Printer to Server Communication with the Use of Telnet on Certain Product Generations
Testing Printer to Server Communication with the Use of Telnet on Certain Product Generations
Scan to Network: Browsing Folders from the Printer Display Is Slow
Scan to Network: Browsing Folders from the Printer Display Is Slow
lexmark-support-for-microsoft-ldap-channel-binding
lexmark-support-for-microsoft-ldap-channel-binding
Padding Oracle on Downloaded Legacy Encryption 'POODLE' Vulnerability
Padding Oracle on Downloaded Legacy Encryption 'POODLE' Vulnerability
Enabling the generate postscript in driver or disabling the postscript passthrough
Enabling the generate postscript in driver or disabling the postscript passthrough
E-mail and FTP settings configuration topics as seen via the Embedded Web Server
E-mail and FTP settings configuration topics as seen via the Embedded Web Server
Identifying if the computer is running Windows or macOS
Identifying if the computer is running Windows or macOS
Slow Driver Responsiveness when Opening Printing Preferences or Print Dialog
Slow Driver Responsiveness when Opening Printing Preferences or Print Dialog
Installing the MarkNet N8150, N8250, or N8350 a/b/g/n wireless print server
Installing the MarkNet N8150, N8250, or N8350 a/b/g/n wireless print server
Exporting and importing user-defined configuration settings
Exporting and importing user-defined configuration settings
Capturing the Device Description (DEVD) and Output Queue (OUTQ) settings in AS/400
Capturing the Device Description (DEVD) and Output Queue (OUTQ) settings in AS/400
capturing-the-lpma-printer-discovery-tool-logs-ho4
capturing-the-lpma-printer-discovery-tool-logs-ho4
The Difference Between Power Saver (Sleep) Versus Hibernation on a Lexmark Printer/MFP
The Difference Between Power Saver (Sleep) Versus Hibernation on a Lexmark Printer/MFP
Maximum number of shortcuts that can be used on Lexmark multifunction printers
Maximum number of shortcuts that can be used on Lexmark multifunction printers
Setting up an e-mail server for scanning to e-mail
Setting up an e-mail server for scanning to e-mail
How to use the Service Restore Tool to retrieve previously deployed licenses
How to use the Service Restore Tool to retrieve previously deployed licenses
Serial Number, Machine Type, and Configuration ID Location for the Lexmark MS, MX, XM, CS, CX, XC, 91X - 92x Series Printers and MFPs
Serial Number, Machine Type, and Configuration ID Location for the Lexmark MS, MX, XM, CS, CX, XC, 91X - 92x Series Printers and MFPs
How to Determine the Version of Your Installed Printer Driver
How to Determine the Version of Your Installed Printer Driver
How to Copy/Upgrade the Printer Base Code via USB Cable
How to Copy/Upgrade the Printer Base Code via USB Cable
How to Copy/Upgrade the Printer Base Code via Parallel Cable
How to Copy/Upgrade the Printer Base Code via Parallel Cable
How to Configure Lexmark Print Management Full Data Export for MSSQL Database
Overview
This article provides the steps required to configure a full data export for
Lexmark Print Management
(LPM
) with Microsoft SQL
(MSSQL
) database
.Procedure
Step
| Action
|
1
| Open a web browser, then go to http:// <loadbalancer IP address>:9780/lmc to open the Lexmark Management Console (LMC ). |
2
| Click on the System tab, select Reports , and then click Add . |
3
| Type a Report Name . |
4
| Set Jasper Report File Name to FullDataExport.jasper . |
5
| Set Default Output Format to CSV . |
6
| Set Data Source to EXTERNAL . |
7
| Use the following values: Database Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver Database URL: jdbc:sqlserver:// <sqlserverhostname>:1433;databasename= <lpm database name>;" Username: <Username> Password: <Password>
Note: The values for <sqlserverhostname>, <lpm database name>, <username>, and <password> depend on your setup. Click here to view sample image. |
Still need help?
If you need additional assistance, please close this window, go to your product's support page and locate 
Get In Touch with Lexmark!
for contact information.
NOTE:
In order to expedite the support process, please be prepared to provide information regarding your issue, e.g., name and version of solution
, problem description
, and affected printer models
.The support agent may request additional information.
LEGACY ID:
HO3987
Feedback gesendet! Vielen Dank für geschätztes Feedback!