cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

FEATURE REQUEST - Colors in Orion Web based Reports.

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.

6 Comments
Product Manager
Product Manager

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="https://thwack.solarwinds.com/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + 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="https://thwack.solarwinds.com/Orion/UDT/PortDetails.aspx?NetObject=UP:' + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-up.gif"'

WHEN 2 THEN

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

ELSE

'<a href="https://thwack.solarwinds.com/Orion/UDT/PortDetails.aspx?NetObject=UP:' + 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="https://thwack.solarwinds.com/Orion/UDT/PortDetails.aspx?NetObject=UP:' + cast(dbo.UDT_port.PortID as nvarchar) + '"><img src="/orion/images/StatusIcons/Small-up.gif"'

WHEN 2 THEN

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

ELSE

'<a href="https://thwack.solarwinds.com/Orion/UDT/PortDetails.aspx?NetObject=UP:' + 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

.

It would help, but only in case of reports which we are pulling with SQL queries, anyway thanks for sharing this idea.

But still this would come from the product as built in feature

Bump

Level 16

A black background would also be nice (dark theme - bump)

Level 9

As we struggle to adopt a ticketing cadence, having this functionality within the reports would be great. I am not a SQL expert and having this built into the tool would be super helpful.

MVP
MVP

I'd love to see this implemented.