Symptoms

Dear,

If I run the following query:

SELECT * FROM HostServer]..SecurityCredentialCache]
I get around 500 records

but in black pearl it shows 302 so how come? how can I get the correct list of users?


Regards,


 

Diagnoses

we had a copy of the . SecurityCredentialCache] table

in the workspace the licensed users are the users who have cached passwords and have a value saved in the Password field.

When we eliminated the rows where the password field is blank and also eliminate the rows where PasswordCached is equal to 0 we will get the 302 rows.
 

Resolution

Customer ordered closure of this ticket after the following reply
"
in the workspace the licensed users are the users who have cached passwords and have a value saved in the Password field.

When you eliminate the rows where the password field is blank and also eliminate the rows where PasswordCached is equal to 0 you will get the 302 rows.
"