Custom Query Colouring

Question

I'm attempting to create a custom table which checks for the last update from a Poller,

the idea is to have it so that any poller not updated within the last minute, for it to flag up,

i am attempting here for when minutes > 0 for the writing to show in red to highlight the issue where if not,

then colour remains green,

This currently does not work when attempting

SELECT

ServerName

, [E].ServerType

, [E].Elements AS [Monitored Elements]

, [E].Nodes AS [Monitored Nodes]

, [E].Interfaces AS [Monitored Interfaces]

, [E].Volumes AS [Monitored Volumes]

, [E].Pollers AS [Monitored UnDP]

, MinuteDiff([E].KeepAlive, GETUTCDATE())

,CASE

WHEN MinuteDiff([E].KeepAlive, GETUTCDATE()) = 0 THEN 'color:green;'

ELSE 'color:red;'

END AS [_StyleFor_MinuteDiff([E].KeepAlive, GETUTCDATE())]

FROM Orion.Engines AS [E]

Any advice would be greatly appreciated

jrouviere · Answer

We do this in our reports with simple HTML tags and the CASE statement, here's an example: CASE CustomNodePollerStatus_CustomPollerStatus.Status WHEN 'Normal' THEN 'Normal' WHEN 'NearOverLoad' THEN 'Near Over Load' WHEN 'Overload' THEN 'Over Load' END AS Status,

antonis.athanasiou · Answer

There's actually a way to create a custom table with colours/styles by injecting javascript into the custom SQL and making that column 'HTML friendly'

reference back to Re: Change Row Colors in Reports  which I used previously on a project, unfortunately I do not have a copy of that code anymore.

dgsmith80 · Answer

I'm not aware that you can do this within a Custom Table - But you might look at this post by one of our fellow MVP's antonis.athanasiou​ on how to add colour to Custom Query. Custom Query resource with colors and styles