ComputerRoleMembership View

The ComputerRoleMembership view lists all computer members for each Computer Role. The view includes computers that have been added into the zone.

Column Name

Description

Refers to

ADComputer_CnName

The Active Directory computer’s common name.

 

ADComputer_DnsHostName

The dns host name of the Active Directory Computer

 

ADComputer_DomainId

The domain ID of the Active Directory computer

Domains.Id

ADComputer_GUID

The GUID of the Active Directory computer

ADComputes.ADComputer_GUID

ADComputer_ObjectName

The object name of the computer, in the format of <computer CN>.<computer domain>.

 

ComputerRole_ComputerRoleName

The name of the Computer Role

 

ComputerRole_GUID

The object GUID of the computer role

 

ComputerRole_ZoneId

The ID of the zone where this computer role is defined

Zones.Zone_Id

ZoneComputer_AgentVersion

The agent version of the computer

 

ZoneComputer_Id

The ID of the computer

 

ZoneComputer_IsOrphan

If the computer is orphaned

1 – Yes, 0 – No

 

ZoneComputer_JoinDate

The date when the computer joined zone (UTC time)

 

ZoneComputer_Name

The name of the computer

 

ZoneComputer_Platform

The computer platform

1 – Windows, 2 – Unix

 

ZoneComputer_PlatformDesc

The display value of ZoneComputer_Platform

(Windows/Unix)

 

ZoneComputer_ZoneId

The ID of the zone where the computer is joined to

Zones.Zone_Id