SQL function to check the Data Collection status for specific cluster in VRA 7.X

Often there are situation where data collection will get stuck and I felt very hard to check different tables in Database to check what is the current value and how can we compare for working cluster.

To check the data collection basically we need to check in 4 Tables
Host, DataCollectionStatus,FilterSpec and FilterSpecGroup
As per the result we would need to pass the different values to see what is set, which i found very tedious task and I have come up with SQL function which can be utilize to view result by just providing the clustername

Continue reading