I currently have a failure notification built in the TS so when a device fails it sends a card populated with a bunch of values such as IP, SN, model, failed step, last dp, mac, start time, etc, which helps us identify major imaging issues pretty quickly.

As I can't really find any good way of getting the granular OSD metrics I would like through SCCM, I was thinking on expanding on the Teams notification and writing all success/failures to a custom DB table. This way I could easily just query a single table for all the values I want.

I believe it would help in seeing trends and making better decisions such as if I can see if a subnet's imaging times are much slower compared to all others or a certain model only failing at a specific site.

Has anyone done anything similar?