Hi All How to customized reports solarwinds LEM ?
example :
Hi All How to customized reports solarwinds LEM ?
example :
Unfortunately reporting is one of the weaknesses in the LEM product. The Reporting application has some good canned reports but if you want anything beyond what is in those you begin to run into issues. HERE I have submitted a feature request to significantly enhance the experience with support in LEM.
The link for 'expert' is now Creating a Custom Filtered Report - SolarWinds Worldwide, LLC. Help and Support
What this process is doing is filtering the rows returned from the dataset. For example all rows with this field not empty or that field meeting some parameter. What would be better is to also filter by column. That would involve reducing the number of fields pulled out by the underlying SQL. The original poster only wants 6 fields displayed. Log on reports from the LEM report engine have enough default fields to spread the headings over 2 lines making any interpretation of the report hefty work.
Is there a way to get at the SQL and sort that directly by writing and running our own SQL or through the reports engine? There is a post on this board from 2014 using Crystal Reports 2013 but nothing more recent. Are there any leads on running raw SQL on the underlying LEM data to get results? I would look to using PHP to create user friendly reports from this. My experience of the built-in MS SQL reporting engine is that it is less effort to code my own in PHP than fight the MS interface.
Other clients who have wanted custom LEM reports have had Crystal developers on staff. This does not help regular users, as out of 100 clients only 2 have had Crystal developers. You can always hire a contractor to do it.
The closest solution (as others have said) is to apply a filter to the existing report. But that's just for starters, if you want to change the name the report - there is this a procedure we have to go through which involves copying the report to to a 2003 server. How to change name of custom report
I believe we still have to do this with LEM 6.2.1
Thanks
Amit
Hello Byrona,
Was just going through this thread as I am looking for LEM report customization for the rebranding purpose. So can I customize and replace all the stuffs of logo/text of Solarwind in report? As for our customers it should look like that reports are from us and not from Solarwinds..
There is a logo file here: C:\Program Files (x86)\SolarWinds Log and Event Manager Reports\CustomReports
That could be changed and might affect the logo on custom reports only. That is all the customisation that can be done to the look and feel without access to full crystal reports. As your full version crystal reports *.rpt files are going to be accessed by the existing LEM reporting engine I fear that even customised reports may inherit the SolarWinds look and feel. Perhaps someone on THWACK with recent experience in this field will chip in.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.