Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Log & Event Manager (LEM) > SolarWinds LEM 6.3 User Guide > Additional LEM Configuration and Troubleshooting Information > Report Formats and their corresponding numbers listed in a LEM scheduled report ini file

Report Formats and their corresponding numbers listed in a LEM scheduled report ini file

Table of contents
No headers
Created by Caroline Juszczak, last modified by Caroline Juszczak on Sep 21, 2017

Views: 30 Votes: 0 Revisions: 4

This section describes how to edit a scheduled report that is already in the Task Scheduler of the machine running these reports.

Note: As with custom reports and scheduled reports, SolarWinds recommends that report creation be documented for disaster recovery.

  • Scheduled Report INI files are located in: Program Files\SolarWinds Log and Event Manager Reports\SchedINI
  • Schedule Report INI files generate automatically when scheduling a report using the LEM Reports console.
  • If you need to hand edit a scheduled report ini file, or if you are changing the format of the report, you must add the corresponding number report format after the equal sign to the line: "ExportFormat= "

The following list identifies the number assigned to each possible format for a LEM report:

Number Report Format
1 Excel: MS Excel 97-2000, with headings format
2 Exceldata: MS Excel 97-2000, data only format
3 HTML32: HTML version 3.2 format
4 HTML40: HTML version 4.0 format
5 PDF: Adobe Portable Document format
6 RTF: Rich Text Format
7 CSV: Separated Values Text format
8 TAB: Tab Separated text format
9 Text: Text based report format
10 Word: MS Word Document format
11 XML: XML Document format
12 RPT: Crystal RPT w/ Data format

The following is an example of a LEM Scheduled Report INI file:

[TaskSetup]
Keyword=2009331
Filename=C:\Program Files\SolarWinds Log and Event Manager Reports\Reports\RPT2009-33-1.rpt
[DSNManager]
Manager1=sherman
[RptParams]
RptDateRangeDesc=DAY_P
RptDateRange=2
RptStartTime=12:00:00 AM
RptStopTime=11:59:59 PM
TopN=20
[Export]
DoExport=T
ExportDesc=EXCEL
ExportFormat=1
ExportDest=C:\Program Files\SolarWinds Log and Event Manager Reports\Export
ExportFileName=format1.xls
ExportOverWrite=INCREMENT
Last modified
10:31, 21 Sep 2017

Tags

Classifications

Public