
Hi
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
Hi, Mark.
Would you please check a few things for me and let me know what you find?
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.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.
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
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.
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
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.