Get health status of all storage providers