vCollectionMember

Lists all collections each machine ID is a member of (if any).

Column Name

Type

Purpose

Machine_GroupID

varchar(201), null

A concatenated representation of the machine id and the group id it is associated with.

agentGuid

numeric(26,0), not null

A globally unique identifier for a machine ID.group ID account and its corresponding agent.

machName

varchar(100), null

Machine Name used for each agent

groupName

varchar(100), null

Organization, then machine group the machine is assigned to.

collectionName

varchar(100), not null

Collection Name