Get userID, password, PIN

TEST S.p.A. Posts: 1 Join Date: 10/2/09 Recent Posts	Get userID, password, PIN Answer 1/22/13 4:18 PM Mark as an Answer Submit Reply with Quote Quick Reply Hello, I want to retrieve from the database all the userID, passwords and PIN (for EndUsers). I'm trying to do it with the AXLsqltoolkit, inserting the sql query in the input file, but I don't know what is the right query to get the information. Reading the data dictionary I found out that the tables I'm interested in are "EndUser" and "credential", which are connected through "EndUser.pkid" and credential.fkenduser". Am I right or more tables need to be involved in the query? I was hoping that someone had the same problem and already found the solution. Thank you very much, best regards Denis Roman Fulin
	Sign in to vote. Flag Please sign in to flag this as inappropriate. Top

Florian Kroessbacher Posts: 32 Join Date: 2/27/09 Recent Posts	RE: Get userID, password, PIN Answer 1/25/13 7:46 PM as a reply to TEST S.p.A.. Mark as an Answer Submit Reply with Quote Quick Reply Hy Out There, i think u are on the right way, but the password and pin are stored encrypted u can get the type of the credential through the tkcredential which is the enum from the table typecredentials in there u get the type From CUC: 1 = Windows (not used), 2 = Domino (not used), 3 = Password, 4 = PIN cheers Floh
	Sign in to vote. Flag Please sign in to flag this as inappropriate. Top

AXL Developer