ComputerRoleEffectiveMembers View

This view lists the effective members of a computer role.

Column Name

Description

Refers to

ComputerRole_GUID

The GUID of the Computer Role

 

ComputerRole_ZoneId

The zone ID where the Computer Role is defined

Zones.Zone_Id

ComputerRole_ComputerRoleName

The name of the Computer Role

 

ADComputer_GUID

The object GUID of the Active Directory computer

ADComputes.ADComputer_GUID

ADComputer_DomainId

The ID of the computer’s domain

Domains.Id

ADComputer_ObjectName

Format:

<AD computer CN>.<AD computer domain>

This field is mainly used by the default reports.

 

ADComputer_CnName

The Active Directory computer’s cnName

 

ADComputer_DnsHostName

The DNS host name of the Active Directory computer

 

ZoneComputer_Id

The ID of the computer

 

ZoneComputer_ZoneId

The ID of the zone that the computer is managed by

Zones.Zone_Id

ZoneComputer_Name

The name of the computer

 

ZoneComputer_AgentVersion

The agent version of the computer

 

ZoneComputer_Platform

The platform of the computer

1 – Windows, 2 – UNIX

 

ZoneComputer_Platform_Desc

The description string of the ZoneComputer_Platform

(Windows/UNIX)

 

ZoneComputer_IsOrphan

If the computer is orphan

1 – Yes, 0 – No

 

ZoneComputer_JoinDate

The date when the computer joined zone (UTC time)