Forum Discussion

keiransteele's avatar
keiransteele
Icon for Neophyte rankNeophyte
10 months ago

Get historical values for alerting

I would like to alert when an MSSQL database ( Microsoft_SQLServer_Databases ) has increased in size by 10GB or more over 24h. I tried support but was told it wasn’t possible to alert on historical ...
alerts
api
Anonymous's avatar
Anonymous
10 months ago

Another option is you can create a clone of Microsoft_SQLServer_Databases, that is setup to only run once a day (which wasn’t an option 6 years ago) and use a Delta threshold for the size. Would only work for 24hr or less though.

There is a potential downside to this: if a poll is missed, like the device doesn’t response to that once-a-day poll, you’re out of luck.