The following example uses the Forefront Identity Manager Certificate Management (FIM CM) SQL API to show how to retrieve all the smart cards assigned to the specified user with the externalGetUserSmartCards procedure.
 Copy Code |
|
|---|---|
DECLARE @RC int DECLARE @user_nt4name nvarchar(80) -- Set parameter values SET @user_nt4name = 'zaiqx-clm-test\subscriber01' EXEC @RC = [CLM].[dbo].[externalGetUserSmartCards] @user_nt4name PRINT @RC |
|
The smart cards are returned in the SQL query analyzer with the fields shown in the table below.
|
sc_uuid |
sc_manufacturer_id |
sc_serial_number |
sc_status |
sc_flags |
|
566…. |
MSBaseCSP |
{9a9c044a-9c2e-11db-b6c5-00137293d1fe} |
5 |
5 |
|
11A… |
MSBaseCSP |
{9ce50fc0-9081-11db-9cdd-00137293d1fe} |
5 |
1 |
|
457… |
MSBaseCSP |
{09d74454-9082-11db-9cdd-00137293d1fe} |
2 |
1 |
|
83B… |
MSBaseCSP |
{67ca6f24-9081-11db-9cdd-00137293d1fe} |
2 |
2 |