I see there is there are metrics for a backup running and its length however is there a way just to simply see if a backup ran and if it completed successfully or not at all for Microsoft SQL? We are looking to eventually put together a dashboard that you can look at the server and see if the backup that was supposed to run that night ran and if it completed successfully or not.
If none of the available metrics meet your requirement, try creating a "custom checkpoint" which could suffice wherein you can have your own SQL query to monitor the backup status.
Below link should give a fair idea for creating a custom checkpoint :https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-im-configuration#sqlserverIMConfiguration-(Optional)CreateCustomCheckpoint
You might also find some Event IDs that can come in handy to track this.