1

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.ManagedEntityRowId = MaintenanceMode.ManagedEntityRowId
INNER JOIN
MaintenanceModeHistory ON MaintenanceMode.MaintenanceModeRowId = MaintenanceModeHistory.MaintenanceModeRowId

Blake@TeamCDS selected answer