Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

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

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
14:46, 13 Nov 2015

Tags

Classifications

Public