• Arun Nukula

vRealize Automation DataCollection schedules

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.






38 views

Recent Posts

See All

Subscribe Now

  • Twitter
  • Facebook Social Icon

Copyright © 2019 nukescloud