Peter Ghofrany (US Department of Transportation) asked a question.
How to list of windows servers that uses a specific credential
Good Afternoon,
I would like to know how we can get list of windows that using specific credential. we have thousands of servers, and few servers are assigned incorrect credential that cause account lock up.
If there is a sql query that shows what server uses what credential, it will help resolve the issue.
Thank you again.
Sincerely,
Peter
Hi Peter
Here is a query below that i have created. You can use this in SQL MGMT Studio to display the devices using a specific credential name
select * from Device
inner join PivotCredentialTypeToDevice on device.nDeviceID = PivotCredentialTypeToDevice.nDeviceID
inner join CredentialType on CredentialType.nCredentialTypeID = PivotCredentialTypeToDevice.nCredentialTypeID
where CredentialType.sDisplayName like 'CredentialName'
You could also create a WUG dynamic group to display the devices in the Web UI. You could use a query similiar to below to do so
SELECT DISTINCT Device.nDeviceID FROM Device
inner join PivotCredentialTypeToDevice on device.nDeviceID = PivotCredentialTypeToDevice.nDeviceID
inner join CredentialType on CredentialType.nCredentialTypeID = PivotCredentialTypeToDevice.nCredentialTypeID
where CredentialType.sDisplayName like 'CredentialName'
Andrew