DeviceLocalCredentials
Offers information on local administrator account credentials for specific device objects.
Table Specific Information
Select
Most filters are handled server side, but the specific field of Id will change the endpoint we use to retrieve the data. It must be specified with an '=' or IN condition.
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. |