List of disabled users in livelink

Baber_Amin

Hi,

I want to create a report to list disable users (i.e. not having Log-in enabled privelege).

Please help me in that.

regards,

Baber.

Walt_Ruppar

This should do what you desire...

select ID, NAME, LASTNAME, FIRSTNAME, DELETED, USERPRIVILEGES from KUAF where Type=0 and Deleted=0 and userprivileges = 2062

 

Baber_Amin

Hi,

Thanks very much.

There is a small problem in it as if a user is disabled and having privelege enabled other than public has some other privelege code. How to handle that?

regards,

Baber.

Lindsay_Davies

Hi Baber

 

You need to check a specific bit.

How you do it is DB specific, so my question is…

Are you using SQL server or Oracle for your DB?

 

Regards

Lindsay

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2012 July 10, Tue 09:01
To: eLink Recipient
Subject: List of disabled users in livelink

 

List of disabled users in livelink

Posted bybaber.amin@dolphinenergy.com (Amin, Baber) On 07-10-2012 03:58

 

Hi, Thanks very much. There is a small problem in it as if a user is disabled and having privelege enabled other than public has some other privelege code. How to handle that? regards, Baber.

---

[To post a comment, use the normal reply function]
Topic:	List of disabled users in livelink
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

 

Baber_Amin

we have oracle.

Lindsay_Davies

OK these queries are for Oracle.

SQL server would use a slightly different technique.

 

Bit 1 is used for Login Enabled / Disabled.

 

These two queries will check to disabled users and enabled users respectively.

 

The first query would show names with “(delete)” appended for deleted users because they are disabled as well as users with other privileges who are disabled.

 

select id,name,userprivileges

  from kuaf

where type = 0

   and bitand(userprivileges,1) = 0

 

 

 

select id,name,userprivileges

  from kuaf

where type = 0

   and bitand(userprivileges,1) = 1

 

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2012 July 10, Tue 11:02
To: eLink Recipient
Subject: RE List of disabled users in livelink

 

RE List of disabled users in livelink

Posted bybaber.amin@dolphinenergy.com (Amin, Baber) On 07-10-2012 05:59

 

we have oracle.

---

[To post a comment, use the normal reply function]
Topic:	List of disabled users in livelink
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center