1. Kundendienst
  2. Drucker
  3. Lexmark C748
  4. Interaktives Benutzerhandbuch
  5. How to Configure Lexmark Print Management Full Data Export for MSSQL Database
Lexmark C748

Lexmark C748

Druckerfunktionen: Laser, nur Druck, Farbe

Lexmark C748 Kundendienst

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