Returns the number of devices where backup status is complete or completed with errors. This is a useful metric when reconciling services in the Gradient MSP billing module.
Devices[?Type ==
Office365
&& TotalStatus ==
Completed
|| TotalStatus ==
CompletedWithErrors
] | length(@)