Excel Add-In for Microsoft Entra ID

Build 26.0.9770

DeviceLocalCredentials

Offers information on local administrator account credentials for specific device objects.

View-Specific Information

SELECT

Id must be filtered using either the = or IN operator. For example:
SELECT * FROM DeviceLocalCredentials WHERE Id = '2183313c-ac52-4772-8482-7b2eb2a5d7c9_LBZWQ_311068785'
SELECT * FROM DeviceLocalCredentials WHERE Id IN ('2183313c-ac52-4772-8482-7b2eb2a5d7c9_LBZWQ_311068785')
SELECT * FROM DeviceLocalCredentials WHERE DeviceName LIKE '%Desktop%'

Columns

Name Type Description
id [KEY] String The unique identifier for the device's local credentials, used for secure identification.
credentials String Encrypted or hashed representation of the device's local credentials used for authentication or access.
deviceName String The name assigned to the device, often used for identification or management purposes.
lastBackupDateTime Datetime The timestamp indicating when the device's credentials were last successfully backed up.
refreshDateTime Datetime The timestamp indicating the next scheduled refresh or expiration of the device's credentials.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770