SSIS Components for Azure Active Directory

Build 24.0.9060

DeviceLocalCredentials

Retrieves the local administrator account credential of a device object.

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 id of the deviceLocalCredential.
credentials String The credentials of the deviceLocalCredential.
deviceName String The deviceName of the deviceLocalCredential.
lastBackupDateTime Datetime The lastBackupDateTime of the deviceLocalCredential.
refreshDateTime Datetime The refreshDateTime of the deviceLocalCredential.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060