First, this really isn't a vRealize Automation issue and belongs in the vROps forum. Secondly, there's not going to be any good solution for you without using a combination of the EpOps agents in...
See more...
First, this really isn't a vRealize Automation issue and belongs in the vROps forum. Secondly, there's not going to be any good solution for you without using a combination of the EpOps agents in-guest, or the management packs from Blue Medora. If you have an Advanced license, you can use the Endpoint Operations agents. By default, recent versions of vROps have the SQL plug-in embedded for the EpOps agents, so when you deploy to a system with MSSQL the agent can, after configuration, collect on certain metrics. But to do what you want in the best way really requires an Enterprise license, and Blue Medora pack for SQL is really excellent although not free.