To show a usage chart of how many emails have been sent from Kaseya each day use the SQL query below and refine it to your needs.
Change the To email address to the address you want to see usage of, and change the date range to show more/less than 30 days if required.
Additional filtering can be applied in the gauge to show only specific types of alerts (filtered by subject line).
SELECT [id],[from],[to],[subject],[created],[sent],[sendTime],[sendStatus]
FROM [ksubscribers].[dbo].[email]
WHERE [To] LIKE '%monitoring@managed%' AND [created] >= DATEADD(d, -30, GETDATE())
Comments
0 comments