How to obtain the encrypted disk state directly from the ePolicy Orchestrator database

Technical Articles ID: KB92072
Last Modified: 2023-04-11 06:44:30 Etc/GMT

Environment

Drive Encryption (DE) 7.x

Summary

This article helps obtain the following:

The DE status using a query provided by DE
Descriptions of the encryption disk status codes

You can use the tables from the query to export the DE data when it's integrated with a third-party tool. For example, Splunk, SolarWinds, LogPoint, and Qualys.

Problem

You're unable to obtain the status of an encrypted drive.

Solution

You can obtain a system's State from a table created using the dbo.EPEsystems query in the ePO database.

Descriptions of the encryption disk status codes:

Active = 0
Inactive = 1
ActivationInProgress = 2
DeactivationInProgress = 3
Unsupported = 4
Recovery = 5
UnsupportedVersion = 6
Upgradable = 7
Failure = 8
SafeFailActive = 9

The code is provided in the State column after you run the dbo.EPEsystems query:

Screenshot showing the "State" column

Affected Products

Languages:

This article is available in the following languages:

Knowledge Center

How to obtain the encrypted disk state directly from the ePolicy Orchestrator database

Environment

Summary

Problem

Solution

Affected Products

Languages:

Title

Title

Knowledge Center

How to obtain the encrypted disk state directly from the ePolicy Orchestrator database

Environment

Summary

Problem

Solution

Affected Products

Languages:

Choose your region

Title

Title