Drive Encryption SQL queries to view users assigned by system

Technical Articles ID: KB77099
Last Modified: 2023-02-20 11:24:14 Etc/GMT

Environment

Drive Encryption (DE) 7.1.x

For details of DE 7.1.x supported environments, see KB79422 - Supported platforms for Drive Encryption 7.x.

Summary

The following queries aren't part of the DE standard reports. The SQL queries provided in this article allow you to perform the following operations:

Check group assignment on the Group Users tab.
Check group assignment on an individual system.
Check user assignment on the Group Users tab.
Check user assignment on an individual system.

Solution

Use the following SQL scripts to obtain group and user details.

NOTE: For assistance on how to run SQL scripts provided by Support using OSQL/SQLCMD with ePO, see KB67591 - How to run a SQL script provided by Technical Support against the ePolicy Orchestrator database.

NOTE: The referenced content is available only to logged in ServicePortal users. To view the content, click the link and log in when prompted.

Group assignment SQL queries

To check group assignment on the Group Users tab:

select EPELDAPGroups.GroupID, EPELDAPGroups.GroupDN, EPOBranchNode.NodeTextPath from EPEBranchGroups, EPOBranchNode, EPELDAPGroups
where EPEBranchGroups.EPOBranchNodeID = EPOBranchNode.AUTOID
AND
EPEBranchGroups.GroupID = EPELDAPGroups.GroupID
To check group assignment on an individual system:

select EPELDAPGroups.GroupID, EPELDAPGroups.GroupDN, EPOLEAFNODE.NODENAME from EPELDAPGroups, EPEMachineGroups, EPOLEAFNODE
where EPELDAPGroups.GroupID = EPEMACHINEGroups.GroupID
AND
EPEMACHINEGroups.EPOLeafNodeID = EPOLEAFNODE.AUTOID
ORDER BY EPELDAPGroups.GroupDN

User assignment SQL queries

To check user assignment on the Group Users tab:

select EPEUsers.UniqueID, EPEUsers.DN, EPOBranchNode.NodeTextPath from EPEBranchUser, EPOBranchNode, EPEUsers
where EPEBranchUser.EPOBranchNodeID = EPOBranchNode.AUTOID
AND
EPEBranchUser.UserID = EPEUsers.UserID
To check user assignment on an individual system:

select EPEUsers.UniqueID, EPEUsers.DN, EPOLEAFNODE.NODENAME from EPEUsers, EPEMACHINEUSER, EPOLEAFNODE
where EPEUSERS.USERID = EPEMACHINEUSER.USERID
AND
EPEMACHINEUSER.EPOLEAFNODEID = EPOLEAFNODE.AUTOID
ORDER BY EPEUSERS.DN

Affected Products

Languages:

This article is available in the following languages:

Knowledge Center

Drive Encryption SQL queries to view users assigned by system

Environment

Summary

Solution

Affected Products

Languages:

Title

Title

Knowledge Center

Drive Encryption SQL queries to view users assigned by system

Environment

Summary

Solution

Affected Products

Languages:

Choose your region

Title

Title