How to query the KUAF table for user data ? (KB488901 related)

Matthew_Hinton

Content Server 10 Update 2014-12 (version 10.0.0.3187)

I'm attempting to run the following SQL query using sqlplus against our Oracle database.

SELECT * FROM KUAF WHERE Name = "[UserID]"

1) What should the above statement return?
2) Can someone expand on the syntax of "[UserID]"? i.e. do I need the quotation mark, brackets?
3) The UserID comes from the URL portion of http://...&userID=999999" ?

This KB is what I'm trying to understand:
https://knowledge.opentext.com/knowledge/llisapi.dll/kcs/kbarticle/view/KB488901

Thanks in advance.

Appu_Nair1

The easiest way to understand that is go to your Livelink and fnd yourself in the users &groups command in the GUI then if you have an EDIT link look at that Link.Copy the URL into notepad and look at it it may resemble this http://livelink/llisapi.dll?func=user.edituser&userID=171173493&ntab=LivelinkUsersAndGroupsGeneral&nextURL=%2Fllisapi%2Edll%3Ffunc%3Duser%2Elistusers if you now go into SQLplus or a liverport and say select * from kuaf where ID=171173493 you will probably recognize what you say in the GUI coming from that row in the table

Obviously you are seeing that because you are in a un deleted state.For a deleted state users the artcle is sying how does one "recover something in a deleted users' pws" so they are basically saying,once you have the userid of a deleted user you can construct a URL to a deleted user and then click on a PWS link ,if you area  SA and take ot from there.

select * from kuaf where ID=171173493 that is looking at KUAF by the ID of a user in the kuaf table

select * from kuaf where NAME='knair' that is looking at KUAF by the Name of a user in the kuaf table

Note there is a single quote in that query and most Oracle databases are case sensitive so if you really want it to return in any which way

select * from kuaf where lower(name) like 'knair'; or

select * from kuaf where upper(name) like 'KNAIR';

I belive the OT article is written for a LL Administartor and those queries need not be executed in SQLplus it can be done a LR's aas well