KNW316 ✭✭✭✭✭

Thank you so much for this! I was able to use this query as a base with Copilot to create the report I needed. :)

SELECT Status,EntityUri, UtcSuppressFrom, UtcSuppressUntil, LocalSuppressFrom, LocalSuppressUntil, Element, DetailsUrl, AE2.AccountID,Comments FROM ( SELECT DISTINCT [EntityUri], [SuppressFrom] AS [UtcSuppressFrom], [SuppressUntil] AS [UtcSuppressUntil], ToLocal([SuppressFrom]) AS [LocalSuppressFrom],…

I should add that the end goal is to email an alert to "application_owner" whenever a server hasn't rebooted in 35 days. We want our app owners to take responsibility for making sure reboots are happening after monthly updates, so our team doesn't have to manually email them every month.