Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Scheduled Reporting from a Non-console unit

I have installed the LEM reporting module on a seperate server without the console(after following the article regarding reports on a unit without the console being installed) and this is connecting too and reporting against the database with no issues.

However I have followed the instructions regarding setting up best practice reports and Task Schedule's but the reports are either no running or the export if failing.

I have also set an individual report task and the same issue occurs.

The Task schedule log shows that the task has started run and completed with no errors but no report exports do not exist in the configured directory.

I also set a rule to send an email when a report has completed and this has also not triggered.

Am I missing a crutial relationship between the reports module and console?

Many Thanks

Mark Van-Kerro

Find more posts tagged with

Reports

lem

Accepted answers

markvk

OK, looks like a permission issue with the user running the reports executable under windows 2008

The executable runs and loads the managers.txt file but is unable to load the datasources.

ODBC datasources are available to be read, and I replicated the datasources as user DSN's but the reports app does not seem to use this type.

When making the user a local admin the datasources are available and the reports application runs, however when not an administator datasources are not loaded and access fails.

Thanks

Mark

All comments

phil3

Hi, Mark.

Would you please check a few things for me and let me know what you find?

Double-check the ExportDest value in each of the INI files in C:\Program Files\SolarWinds Log and Event Manager Reports\SchedINI. This value should match your desired export destination, and the user you assign in Task Scheduler to export the reports should have write access to this folder.
Do an nDepth search in your LEM Console for the time period during which you expected these reports to run. Based on our recommended schedule, a time frame of 1am to 4am should be more than sufficient. You can filter your search by the following alert-field/value combination: InternalInfo.EventInfo = *SWLEM Reports*. This should indicate whether your reports started and/or completed during that time frame.

If #1 is set up correctly and you don't see the expected alerts in #2, let me know.

Thanks.

markvk

Hi, Phil

1) The destination is a remote fileshare e.g. \\<server>\solarwindslem the user used to run the reports has access to this area. (I did run this logging to the local drive, which the same result)

2)I ran this and no entries were found.

Regards

Mark

phil3

Thanks, Mark.

Just one more thing to verify before I refer you to Support:

When you said above that you were able to run reports manually, did you test that with the user account you set up to run the scheduled reports? If not, please log onto your Reports computer with that user account and try running the reports.

If this doesn't work, I'd recommend you open a Support ticket. If you do open a ticket, please post your ticket number and any solution you come to here so we/future users can keep track.

Thanks again.

markvk

OK, looks like a permission issue with the user running the reports executable under windows 2008

The executable runs and loads the managers.txt file but is unable to load the datasources.

ODBC datasources are available to be read, and I replicated the datasources as user DSN's but the reports app does not seem to use this type.

When making the user a local admin the datasources are available and the reports application runs, however when not an administator datasources are not loaded and access fails.

Thanks

Mark

phil3

Thanks for the update, Mark.

I verified the solution with Support and our documentation.

For future readers:

The following are the KB articles Mark and I referenced throughout this discussion.

Configuring LEM Reports on Computers Without the LEM Console

Configuring Default Batch Reports on Vista/7/2008 Computers

Thanks.