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.
"