how do I find all the machine with failed MCS profiles?

Document ID : KB000102375
Last Modified Date : 18/06/2018
Show Technical Document Details
How can I find all the hosts with profiles in error status, where the Monitoring tab in USM shows a red cross?
This query will return the name of the device that have profiles with the red cross:
select name from CM_COMPUTER_SYSTEM where cs_id IN (select cs_id from SSRV2profile where status = 'error')