1 Reply Latest reply on Jan 20, 2016 10:39 PM by sea_pancake

    Reporting customisation issues

    sea_pancake

      We are in the process of moving custom reporting functionality created due to limitations in Solarwinds reporting back into Solarwinds however we are running into a number, I'm confident I should be able to resolve the issues but from browsing the forums I can see the community has put together some incredible solutions on their own in this area. I also figure it would be best to talk with those who seem to be battling the numerous limitations in Solarwinds like we have.

       

      Reporting resource titles


      Admittedly this is fairly pedestrian but I have found no way to remove these redundant titles, one of these comes from the fact the resource is querying the Last month and I assume the second is the zoom level which only shows up to the current date. All of these titles are redundant and I'd much prefer to be able to insert the graph itself and use HTML formatting to add titles where required. This issue is across pretty much all resources and it's preventing us making much progress in moving reporting across.


      2016-01-13 14_20_50-Edit Report.png

       

      HTML links in SQL queries

       

      One of the other reports we use is used internally by staff to determine Down / degraded noes at a glance, while I have been able to migrate the report in the form of SQL I'm not able to get HTML links working correctly, I'm trying to link the output of various custom fields within the SQL query.

       

      SELECT

      <Other queries here>

      '<img src=/Orion/images/StatusIcons/'+ CAST(Nodes.StatusLED AS varchar(256)) + '/>' AS 'Status',

      '<a href=https://customers.crm.local/'+ ClientID +'/>' AS ClientID,+

      <Other queries here>

      FROM Nodes

       

      The above works as intended in 'Preview' mode showing a html link with the description as the output of ClientID however when viewing the report the link is not present. ClientID id enabled for HTML links so I'm not sure what's going on, have also tried terminating the HTML (</a>) but no luck. I'm also using status icon link as above and that renders without issue. Looking at other forum posts I could find this should work but I couldn't find anyone who was linking off-site in this manner.

       

      I have considered just using a Custom HTML resource as I haven't had any issues using HTML links in there.

       

      Report styling


      The Solarwinds reporting format is fairly ugly and provides no real way to apply style information, is it possible to customize the page style? I assume calling a graph via a custom resource is not feasible due to what is involved in drawing the graph and summarising the data.



      Any help or direction is appreciated!

        • Re: Reporting customisation issues
          sea_pancake

          I raised the report title issue with Solarwinds support and they put me in contact with a developer who gave us a solution to this.

           

          Assuming your iis site is in default location you can create a custom CSS file in C:\inetpub\Solarwinds\Orion\styles\OrionMinReqs.css

           

          Below are the customization I have made but you can obviously change anything that has some kind of CSS styling (Doesn't work on The field ordering output on reports):

           

          /* Removes  Unnecessarily duplicated date ranges */

           

           

          div.sw-rpt-cell-header 

          {

              display: none;

          }

           

          /* Removes the datasource at the top of the report  */

           

          table.sw-rpt-summary-dataSources

          {

              display: none;

          }

           

          /* Removes the report timeframe at the top of the page. */

           

          table.sw-rpt-summary-timeFrames

           

          {

              display: none;

          }