Jun 22, 2020

vRealize Automation DataCollection schedules

Arun Nukula
Jun 22, 2020
1 min read

Rated NaN out of 5 stars.

Data Collection Status information is stored under dbo.DataCollectionStatus table of IaaS Database

select * from DataCollectionStatus

This table contains AgentID , LastCollectedTime , LastConnectedStatus,EntitiyID,DataCollectionStatusID,FilterSpecID and so on …

FilterSpec refers to the type of endpoint we are collecting data from. dbo.DataCollectionStatus has this FilterSpecID which is coming from dbo.FilterSpec table

dbo.FilterSpec table has FilterSpecName,FilterSpecGroupID,AgentCapabilityName

in it

Let’s take the only vSphereEndpoint into consideration and then filter dbo.FilterSpec w.r.t to this endpoint only

Since we selected vSphere the AgentCapabilityName will only be vSphereHypervisor

select * from dbo.FilterSpec where FilterSpecName = 'vSphere';

Each FilterSpecGroupID belongs to a certain type of data collection task for a specific endpoint.

This information is stored under dbo.FilterSpecGroupID table

Now let’s identify what these FilterSpecGroupID from dbo.FilterSpec table and check what it refers to from dbo.FilterSpecGroup table

select * from FilterSpecGroup where FilterSpecGroupID in ( select FilterSpecGroupID from dbo.FilterSpec where FilterSpecName = 'vSphere')

As one can see in the above screenshot each FilterSpecGroupID belongs to a FilterSpecGroupName which is eventually a task under DataCollection

What’s this ScheduleID then inside dbo.FilterSpecGroup table ?

ScheduleID comes from dbo.CollectionSchedule where default collection schedules are defined and is associated with an ID.

This is the ID that is present under dbo.FilterSpecGroup

So here’s the flow

dbo.CollectionSchedule --> dbo.FilterGroupSpec --> dbo.FilterSpec --> dbo.DataCollectionStatus

If one wants to find out the LastCollectedTime and LastCollectedStatus of data collection from the database for a specific cluster, they can use below query

select LastCollectedTime,LastCollectedStatus,HostName from DataCollectionStatus dc, host h
where dc.EntityID=h.hostID and h.HostName='ClusterName'
order by h.HostName

Note: Replace ClusterName with your specific Compute Resource Name appropriately.