Open for Voting

FEATURE REQUEST - Colors in Orion Web based Reports.

This feature request is to have coloring options in Orion Web Based Reports, SolarWinds Case # 1084316 - Colors in Reports was opened and closed as SolarWinds support mentioned this feature is not currently in the product and they will be submitting it as a feature request.

1.       When Generating/Viewing reports in Orion web console and exporting to PDF

1.1. Component / Service status of any application is showing the colors based on status - this is OK.

1.2. Any utilization thresholds reached like (CPU, Memory, HDD space) are NOT showing colors, we should have some ability to show colors in case of utilization are high or above set thresholds.

2.       Emailing the same reports as PDF attachments in the email NO COLORS at all (for components status even if down as well as any utilization thresholds)

3.       Emailing the same reports as message body using HTML, there are NO COLORS at all (for components status as well as any utilization thresholds).

I know that we can generate separate reports and schedule them in case of any high thresholds reached, but these reports are daily basis reports and operations team when seeing the report will have an eye on infrastructure, and in case there are no coloring options they need to go through detail in each report twice daily.

Parents
  • Hi Abdul,

    +1 For the Feature Request.

    A Possible solution could be to leverage Orions reporting ability to use HTML and custom SQL in reports. A quick example of this:

    1. The SQL Query with HTML String output for the 'HTML'

    select caption,[status],

    CASE

    WHEN [STATUS] = 1 THEN '<table bgcolor="GREEN"><TR><TD>UP</TD></TR></table>'

    WHEN [STATUS]= 2 THEN '<table bgcolor="RED"><TR><TD>DOWN</TD></TR></table>'

    END AS 'HTML'

    from nodes

    .2. Check the Allow HTML in the advanced column properties

    2016-12-08 11_56_59-Edit Resource_ Custom Table.png

    The end result will look like this

    2016-12-08 11_54_38-HTML Custom Report.png

    Note you can also link to images and icons in the orion web folder. Try the following if you have UDT installed.

    2016-12-08 12_09_38-Add Report.png

    SELECT 

    dbo.nodesdata.Caption,   

    '<a href="thwack.solarwinds.com/.../NodeDetails.aspx + cast(dbo.NodesData.NodeID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-' + cast(dbo.NodesData.StatusLED as nvarchar) +'"</a>' + dbo.NodesData.Caption  AS[Node Status],

    dbo.UDT_Port.Name as [Port Name],

    CASE dbo.UDT_Port.OperationalStatus

    WHEN 1 THEN

    '<a href="thwack.solarwinds.com/.../PortDetails.aspx + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-up.gif"'

    WHEN 2 THEN

    '<a href="thwack.solarwinds.com/.../PortDetails.aspx + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-down.gif"'

    ELSE

    '<a href="thwack.solarwinds.com/.../PortDetails.aspx + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-unknown.gif"'

    END as [Operational Status],

    CASE dbo.UDT_Port.AdministrativeStatus

    WHEN 1 THEN

    '<a href="thwack.solarwinds.com/.../PortDetails.aspx + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-up.gif"'

    WHEN 2 THEN

    '<a href="thwack.solarwinds.com/.../PortDetails.aspx + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-down.gif"'

    ELSE

    '<a href="thwack.solarwinds.com/.../PortDetails.aspx + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-unknown.gif"'

    END as [Administrative Status],

    dbo.UDT_Port.MACAddress,

    dbo.UDT_PortToEndpointCounts.EndpointCount

    FROM          

    dbo.NodesData

    left JOIN dbo.UDT_Port ON dbo.NodesData.NodeID = dbo.UDT_Port.NodeID

    left JOIN dbo.UDT_PortToEndpointCounts ON dbo.UDT_PortToEndpointCounts.PortID = dbo.UDT_Port.PortID

    where dbo.udt_port.ismonitored =1 and dbo.udt_port.OperationalStatus=2 and dbo.udt_port.AdministrativeStatus=1 and NodesData.NodeID=35

    .

Comment
  • Hi Abdul,

    +1 For the Feature Request.

    A Possible solution could be to leverage Orions reporting ability to use HTML and custom SQL in reports. A quick example of this:

    1. The SQL Query with HTML String output for the 'HTML'

    select caption,[status],

    CASE

    WHEN [STATUS] = 1 THEN '<table bgcolor="GREEN"><TR><TD>UP</TD></TR></table>'

    WHEN [STATUS]= 2 THEN '<table bgcolor="RED"><TR><TD>DOWN</TD></TR></table>'

    END AS 'HTML'

    from nodes

    .2. Check the Allow HTML in the advanced column properties

    2016-12-08 11_56_59-Edit Resource_ Custom Table.png

    The end result will look like this

    2016-12-08 11_54_38-HTML Custom Report.png

    Note you can also link to images and icons in the orion web folder. Try the following if you have UDT installed.

    2016-12-08 12_09_38-Add Report.png

    SELECT 

    dbo.nodesdata.Caption,   

    '<a href="thwack.solarwinds.com/.../NodeDetails.aspx + cast(dbo.NodesData.NodeID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-' + cast(dbo.NodesData.StatusLED as nvarchar) +'"</a>' + dbo.NodesData.Caption  AS[Node Status],

    dbo.UDT_Port.Name as [Port Name],

    CASE dbo.UDT_Port.OperationalStatus

    WHEN 1 THEN

    '<a href="thwack.solarwinds.com/.../PortDetails.aspx + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-up.gif"'

    WHEN 2 THEN

    '<a href="thwack.solarwinds.com/.../PortDetails.aspx + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-down.gif"'

    ELSE

    '<a href="thwack.solarwinds.com/.../PortDetails.aspx + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-unknown.gif"'

    END as [Operational Status],

    CASE dbo.UDT_Port.AdministrativeStatus

    WHEN 1 THEN

    '<a href="thwack.solarwinds.com/.../PortDetails.aspx + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-up.gif"'

    WHEN 2 THEN

    '<a href="thwack.solarwinds.com/.../PortDetails.aspx + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-down.gif"'

    ELSE

    '<a href="thwack.solarwinds.com/.../PortDetails.aspx + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-unknown.gif"'

    END as [Administrative Status],

    dbo.UDT_Port.MACAddress,

    dbo.UDT_PortToEndpointCounts.EndpointCount

    FROM          

    dbo.NodesData

    left JOIN dbo.UDT_Port ON dbo.NodesData.NodeID = dbo.UDT_Port.NodeID

    left JOIN dbo.UDT_PortToEndpointCounts ON dbo.UDT_PortToEndpointCounts.PortID = dbo.UDT_Port.PortID

    where dbo.udt_port.ismonitored =1 and dbo.udt_port.OperationalStatus=2 and dbo.udt_port.AdministrativeStatus=1 and NodesData.NodeID=35

    .

Children