SCOM Maintenance Mode - Current count

[Jelly]

Looks like this has already been discussed here:

SQL Query - Maintenance Mode History

I'm sure we've all seen it all over the internet, the query below (slightly modified) can pull the MMode history from the OpsMgr DW. What I'm looking for is someone who's already done this, or can help refine it to provide better results in the SquaredUp SQL tile. Specifically, I'm looking for a way to translate the numerical values into actual date/time. SELECT ManagedEntity.DisplayName, MaintenanceModeHistory.* FROM ManagedEntity WITH (NOLOCK) INNER JOIN MaintenanceMode ON ManagedEntity.M…