You are correct that the agent does not have awareness of the cluster, since Hyperic monitors and models at the agent level and does not provide information on objects that extend to multiple agents.
I'm having a hard time understanding what that screenshot provides me. There are other monitoring products that are agent based that can monitor Microsoft failover clusters appropriately. Unfortunately, I do not have that product I have Hyperic. Thanks for the response.
Actually vCenter Operations (vCOPS) is really good solution for your question. Once you has installed hyperic agents on your cluster's nodes and hyperic server point to vCOPS you might monitor whole cluster E2E.
Screenshot above, which Eran posted, shows 2 clusters, list of MSSQL Instances (not specially of that clusters) and list of MSSQL services (e.g. SQL Agent, SSAS and SSRS) . You can drill down to cluster and see which node are active/passive with running instance.