Auto-Delete Users Who Haven't Logged in for > 190 Days

Robert_Anderson_(robanderson_-_(deleted))

Right now, we have a report that brings up every user that hasn't logged in for 190 days:select k.id, k.name, k.lastname, k.firstname, g.name groupname from livelink.kuaf k, livelink.kuaf g, ( ( SELECT kuaf.id kid FROM livelink.kuaf kuaf, livelink.dtree dtree WHERE kuaf.id = dtree.userid AND dtree.subtype = 142 AND kuaf.userpwd IS NOT NULL AND kuaf.deleted = 0 AND dtree.createdate < sysdate-190 ) MINUS ( select userid kid from (SELECT da.userid userid, max(da.auditdate) maxdate FROM livelink.daudit da WHERE da.event = 'LOGIN' GROUP BY da.userid ) where maxdate > sysdate - 190 ) ) badkuaf where badkuaf.kid=k.id and k.groupid=g.id and k.name not like ('bl%%') order by g.name, k.nameWe also have an undelete user report:update KUAF set NAME = substr(NAME,1,instr(NAME,'(Delete)',1)-2),DELETED=0 where ID = %1Which I have changed into a delete user report:update KUAF set NAME = CONCAT(NAME," (Delete)"),DELETED=1 where ID = %1What I want to do is somehow combine the two, but all I've gotten are sql errors.Any suggestions? We're running 9.2 (unfortunately).

Find more posts tagged with

Comments

volvostephen

Message from Fisher, Stephen via eLinkWhere possible, I would avoid doing any kind of user management straightin SQL. A Delete is more then just a 1 or 0 + the word 'Delete'.On that note - I did want something to 'Delete' disabled users in thesystem so rather then using SQL, I created a VBS script that usedXMLHTTP to click the 'Delete User' button effectively for each userreturned via a SQL Statement. So - you could just alter the SQL in thisVBS and potentially run it do accomplish the same thing (note - theProvider is SQL Server and it used single sign on - you will need tochange this to be appropriate for your DB). This is a true 'Delete'.To re-create these users, you should really create new logins - not'undelete' them.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: June 5, 2007 8:35 AMTo: eLink RecipientSubject: Auto-Delete Users Who Haven't Logged in for > 190 DaysAuto-Delete Users Who Haven't Logged in for > 190 DaysPosted by Anderson, Robert on 06/05/2007 08:13 AMRight now, we have a report that brings up every user that hasn't loggedin for 190 days:select k.id, k.name, k.lastname, k.firstname, g.name groupname fromlivelink.kuaf k, livelink.kuaf g, ( ( SELECT kuaf.id kid FROMlivelink.kuaf kuaf, livelink.dtree dtree WHERE kuaf.id = dtree.useridAND dtree.subtype = 142 AND kuaf.userpwd IS NOT NULL AND kuaf.deleted =0 AND dtree.createdate < sysdate-190 ) MINUS ( select userid kid from(SELECT da.userid userid, max(da.auditdate) maxdate FROM livelink.dauditda WHERE da.event = 'LOGIN' GROUP BY da.userid ) where maxdate > sysdate- 190 ) ) badkuaf where badkuaf.kid=k.id and k.groupid=g.id and k.namenot like ('bl%%') order by g.name, k.nameWe also have an undelete user report:update KUAF set NAME =substr(NAME,1,instr(NAME,'(Delete)',1)-2),DELETED=0 where ID = %1Which I have changed into a delete user report:update KUAF set NAME = CONCAT(NAME," (Delete)"),DELETED=1 where ID = %1What I want to do is somehow combine the two, but all I've gotten aresql errors.Any suggestions? We're running 9.2 (unfortunately).[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Srini_Venkataramani

Message from Venkataramani, Srini via eLinkWe have SQL that is very similar to Robert's also. However, this SQLdoes not work in v9.5. I noticed that they have a dauditnew table (notsure if that was added in 9.5). Does anyone have the SQL to get the users that have not logged in thelast n days FOR v9.5 SP1?Also, is there a way to find out when a user was deleted? I could notfind a "deleted_date" field anywhere.Thanks!Srini-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Tuesday, June 05, 2007 10:22 AMTo: eLink RecipientSubject: RE Auto-Delete Users Who Haven't Logged in for > 190 DaysRE Auto-Delete Users Who Haven't Logged in for > 190 DaysPosted by Fisher, Stephen J on 06/05/2007 01:21 PMMessage from Fisher, Stephen via eLinkWhere possible, I would avoid doing any kind of user management straightin SQL. A Delete is more then just a 1 or 0 + the word 'Delete'.On that note - I did want something to 'Delete' disabled users in thesystem so rather then using SQL, I created a VBS script that usedXMLHTTP to click the 'Delete User' button effectively for each userreturned via a SQL Statement. So - you could just alter the SQL in thisVBS and potentially run it do accomplish the same thing (note - theProvider is SQL Server and it used single sign on - you will need tochange this to be appropriate for your DB). This is a true 'Delete'.To re-create these users, you should really create new logins - not'undelete' them.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: June 5, 2007 8:35 AMTo: eLink RecipientSubject: Auto-Delete Users Who Haven't Logged in for > 190 DaysAuto-Delete Users Who Haven't Logged in for > 190 DaysPosted by Anderson, Robert on 06/05/2007 08:13 AMRight now, we have a report that brings up every user that hasn't loggedin for 190 days:select k.id, k.name, k.lastname, k.firstname, g.name groupname fromlivelink.kuaf k, livelink.kuaf g, ( ( SELECT kuaf.id kid FROMlivelink.kuaf kuaf, livelink.dtree dtree WHERE kuaf.id = dtree.useridAND dtree.subtype = 142 AND kuaf.userpwd IS NOT NULL AND kuaf.deleted =0 AND dtree.createdate < sysdate-190 ) MINUS ( select userid kid from(SELECT da.userid userid, max(da.auditdate) maxdate FROM livelink.dauditda WHERE da.event = 'LOGIN' GROUP BY da.userid ) where maxdate > sysdate- 190 ) ) badkuaf where badkuaf.kid=k.id and k.groupid=g.id and k.namenot like ('bl%%') order by g.name, k.nameWe also have an undelete user report:update KUAF set NAME =substr(NAME,1,instr(NAME,'(Delete)',1)-2),DELETED=0 where ID = %1Which I have changed into a delete user report:update KUAF set NAME = CONCAT(NAME," (Delete)"),DELETED=1 where ID = %1What I want to do is somehow combine the two, but all I've gotten aresql errors.Any suggestions? We're running 9.2 (unfortunately).[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.[To reply to this thread, use your normal E-mail reply function.]============================================================Attachment link: UserCleanupUtil.txthttps://knowledge.opentext.com/knowledge/llisapi.dll/open/12475610============================================================Topic: Auto-Delete Users Who Haven't Logged in for > 190 Dayshttps://knowledge.opentext.com/knowledge/llisapi.dll/open/12473635Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

I don't have SQL for users who have not logged in for Livelink 9.5, but I have some related Livelink 9.5.x SQL you can use as a starting point:

User logouts are not audited in Livelink 9.2.x and earlier, but they are audited in Livelink 9.5.x and later; in those versions you can check logouts like this:

select * from DAuditNew where AuditStr='Logout';

However, if a user closes his browser, that counts as a logout as well but wouldn't be registered by the Livelink server. A 'Logout' audit event is recorded if the user logs out using the Livelink Tools menu, Logout option.

With regards to finding out when a user was deleted, try this:

1. Login to Livelink as the Admin user.

2. Go to the Livelink Administration pages using the ?func=admin.index URL extension.

3. In the "System Administration" section, click the "Administer Event Auditing" hyperlink.

4. Click the "Query Audit Log" hyperlink.

5. In the "Target Items" section, select "By Type" and choose "User or Group" from the associated dropdown list..

6. In the "Event Type" section choose "Delete"

7. Click the "Submit Query" button.

Hope that helps...

- Bhupinder

------------------------------------------------------
Bhupinder Singh, B.Math., B.Ed.
Senior Product Specialist, Customer Support
Open Text Corporation, Waterloo, Ontario, Canada
Customer support e-mail: support@opentext.com
Customer Support Telephone: 800-540-7292
------------------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, June 05, 2007 1:34 PM
To: eLink Recipient
Subject: RE RE Auto-Delete Users Who Haven't Logged in for > 190 Days

RE RE Auto-Delete Users Who Haven't Logged in for > 190 Days		Posted by amecas01user4 (Venkataramani, Srini) on 06/05/2007 01:33 PM
In reply to: RE Auto-Delete Users Who Haven't Logged in for > 190 Days		Posted by stephenfisher (Fisher, Stephen J) on 06/05/2007 01:21 PM

Message from Venkataramani, Srini <srini.venkataramani@ameristar.com> via eLink

We have SQL that is very similar to Robert's also. However, this SQL
does not work in v9.5. I noticed that they have a dauditnew table (not
sure if that was added in 9.5).

Does anyone have the SQL to get the users that have not logged in the
last n days FOR v9.5 SP1?

Also, is there a way to find out when a user was deleted? I could not
find a "deleted_date" field anywhere.

Thanks!
Srini

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion
[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, June 05, 2007 10:22 AM
To: eLink Recipient
Subject: RE Auto-Delete Users Who Haven't Logged in for > 190 Days

RE Auto-Delete Users Who Haven't Logged in for > 190 Days
Posted by Fisher, Stephen J on 06/05/2007 01:21 PM

Message from Fisher, Stephen <sfisher@hatch.ca> via eLink

Where possible, I would avoid doing any kind of user management straight
in SQL. A Delete is more then just a 1 or 0 + the word 'Delete'.

On that note - I did want something to 'Delete' disabled users in the
system so rather then using SQL, I created a VBS script that used
XMLHTTP to click the 'Delete User' button effectively for each user
returned via a SQL Statement. So - you could just alter the SQL in this
VBS and potentially run it do accomplish the same thing (note - the
Provider is SQL Server and it used single sign on - you will need to
change this to be appropriate for your DB). This is a true 'Delete'.
To re-create these users, you should really create new logins - not
'undelete' them.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion
[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: June 5, 2007 8:35 AM
To: eLink Recipient
Subject: Auto-Delete Users Who Haven't Logged in for > 190 Days

Auto-Delete Users Who Haven't Logged in for > 190 Days
Posted by Anderson, Robert on 06/05/2007 08:13 AM

Right now, we have a report that brings up every user that hasn't logged
in for 190 days:

select k.id, k.name, k.lastname, k.firstname, g.name groupname from
livelink.kuaf k, livelink.kuaf g, ( ( SELECT kuaf.id kid FROM
livelink.kuaf kuaf, livelink.dtree dtree WHERE kuaf.id = dtree.userid
AND dtree.subtype = 142 AND kuaf.userpwd IS NOT NULL AND kuaf.deleted =
0 AND dtree.createdate < sysdate-190 ) MINUS ( select userid kid from
(SELECT da.userid userid, max(da.auditdate) maxdate FROM livelink.daudit
da WHERE da.event = 'LOGIN' GROUP BY da.userid ) where maxdate > sysdate
- 190 ) ) badkuaf where badkuaf.kid=k.id and k.groupid=g.id and k.name
not like ('bl%%') order by g.name, k.name

We also have an undelete user report:

update KUAF set NAME =
substr(NAME,1,instr(NAME,'(Delete)',1)-2),DELETED=0 where ID = %1

Which I have changed into a delete user report:

update KUAF set NAME = CONCAT(NAME," (Delete)"),DELETED=1 where ID = %1

What I want to do is somehow combine the two, but all I've gotten are
sql errors.

Any suggestions? We're running 9.2 (unfortunately).

[To reply to this thread, use your normal E-mail reply function.]

============================================================

Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677

Livelink Server:
https://knowledge.opentext.com/knowledge/llisapi.dll

To Unsubscribe from this Discussion, send an e-mail to
unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

[To reply to this thread, use your normal E-mail reply function.]

============================================================

Attachment link: UserCleanupUtil.txt
https://knowledge.opentext.com/knowledge/llisapi.dll/open/12475610

============================================================

Topic: Auto-Delete Users Who Haven't Logged in for > 190 Days
https://knowledge.opentext.com/knowledge/llisapi.dll/open/12473635

Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677

Livelink Server:
https://knowledge.opentext.com/knowledge/llisapi.dll

To Unsubscribe from this Discussion, send an e-mail to
unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Eric_Saavedra

Message from Eric Saavedra <esaavedr@opentext.com> via eLink

eLink

Here are the basics for both Oracle andSQL Server. You can add bells and whistles as you need fairly easily based onthese core SQL statements:

ORACLE:

/* USERS WHO HAVENOT LOGGED IN FOR THE PAST 190 DAYS */
SELECT FIRSTNAME, LASTNAME, NAME
FROM KUAF WHERE TYPE = 0 AND DELETED = 0 AND ID NOT IN
(SELECT PERFORMERID FROM DAUDITNEW WHERE AUDITSTR = 'Login' AND AUDITDATE >CURRENT_DATE – 190)

/* USERS WHO HAVEBEEN DELETED AND WHEN */
SELECT * FROM DAUDITNEW
WHERE AUDITSTR = 'Delete' AND USERID IN (SELECT ID FROM KUAF WHERE DELETED = 1AND TYPE = 0)

SQL Server:

/* USERS WHO HAVEBEEN DELETED AND WHEN */
SELECT * FROM DAUDITNEW
WHERE AUDITSTR = 'Delete' AND USERID IN (SELECT ID FROM KUAF WHERE DELETED = 1AND TYPE = 0)

From: eLinkDiscussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, June 05, 2007 10:34AM
To: eLink Recipient
Subject: RE RE Auto-Delete UsersWho Haven't Logged in for > 190 Days

RE RE Auto-Delete Users Who Haven't Logged in for > 190 Days		Posted by amecas01user4 (Venkataramani, Srini) on 06/05/2007 01:33 PM
In reply to: RE Auto-Delete Users Who Haven't Logged in for > 190 Days		Posted by stephenfisher (Fisher, Stephen J) on 06/05/2007 01:21 PM

Steve_McDonough

Here's SQL (MS SQL) to list users who have not logged in to the system within the last 30 days. They needed to log in at least once into the system in order for the report to work unlike Robert's which compares creation date to the system date. The report format is Auto LiveReport.select k.firstname + ' ' + k.lastname "User Name", k.name "Login Name", convert (char(10), max(d.auditdate), 111) "Last Login Date" from kuaf k, dauditnew d where d.performerid = k.id and not exists (select performerid from dauditnew where (performerid = k.id) and (auditid = 23) and (auditdate >= (getdate()-30))) and k.deleted <> 1 and k.type = 0 group by k.lastname, k.firstname, k.name order by k.lastnameHope it helps!

Srini_Venkataramani

Message from Venkataramani, Srini via eLinkThat worked like a charm for me. I am sure this will help many othersout there also.Srini-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Tuesday, June 05, 2007 12:02 PMTo: eLink RecipientSubject: Here's SQL (MS SQL) to list users who have not logged in to thesystem within...Here's SQL (MS SQL) to list users who have not logged in to the systemwithin...Posted by Kish, Leon S on 06/05/2007 02:59 PMHere's SQL (MS SQL) to list users who have not logged in to the systemwithin the last 30 days. They needed to log in at least once into thesystem in order for the report to work unlike Robert's which comparescreation date to the system date. The report format is Auto LiveReport.select k.firstname + ' ' + k.lastname "User Name", k.name "Login Name",convert (char(10), max(d.auditdate), 111) "Last Login Date" from kuaf k,dauditnew d where d.performerid = k.id and not exists (selectperformerid from dauditnew where (performerid = k.id) and (auditid = 23)and (auditdate >= (getdate()-30))) and k.deleted <> 1 and k.type = 0group by k.lastname, k.firstname, k.name order by k.lastnameHope it helps![To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Auto-Delete Users Who Haven't Logged in for > 190 Dayshttps://knowledge.opentext.com/knowledge/llisapi.dll/open/12473635Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

eLink User

Message from Lange, Harald <harald.lange@nsn.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

This thread shows (again) that there is a broad need for those "housekeeping" functionalities like deleting users (and also e.g. transfer ownership on multiple objects to successors, remove deleted users from all groups, etc.)!

In my opinion, such functions belong to an "Enterprise" product - it can not be the right solution that everybody has to fumble around by themselves using VBS,SQL,O-scripts or whatever to find workarounds for those missing functionalies.

Best Regards,
Harald Lange

--------------------------------------------------------
Harald Lange
ShareNet-IMS Consulting & Development
CFO IT OP Mgmt & Support Applicat. SDE
Nokia Siemens Networks GmbH & Co. KG

Phone: +49 89 722 23024
Mailto:Harald.Lange@nsn.com
--------------------------------------------------------

Von: ext eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Gesendet: Dienstag, 5. Juni 2007 19:34
An: eLink Recipient
Betreff: RE RE Auto-Delete Users Who Haven't Logged in for > 190 Days

RE RE Auto-Delete Users Who Haven't Logged in for > 190 Days Posted by amecas01user4 (Venkataramani, Srini) on 06/05/2007 01:33 PM
In reply to: RE Auto-Delete Users Who Haven't Logged in for > 190 Days Posted by stephenfisher (Fisher, Stephen J) on 06/05/2007 01:21 PM

Message from Venkataramani, Srini <srini.venkataramani@ameristar.com> via eLink

We have SQL that is very similar to Robert's also. However, this SQL
does not work in v9.5. I noticed that they have a dauditnew table (not
sure if that was added in 9.5).

Does anyone have the SQL to get the users that have not logged in the
last n days FOR v9.5 SP1?

Also, is there a way to find out when a user was deleted? I could not
find a "deleted_date" field anywhere.

Thanks!
Srini

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion
[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, June 05, 2007 10:22 AM
To: eLink Recipient
Subject: RE Auto-Delete Users Who Haven't Logged in for > 190 Days

RE Auto-Delete Users Who Haven't Logged in for > 190 Days
Posted by Fisher, Stephen J on 06/05/2007 01:21 PM

Message from Fisher, Stephen <sfisher@hatch.ca> via eLink

Where possible, I would avoid doing any kind of user management straight
in SQL. A Delete is more then just a 1 or 0 + the word 'Delete'.

On that note - I did want something to 'Delete' disabled users in the
system so rather then using SQL, I created a VBS script that used
XMLHTTP to click the 'Delete User' button effectively for each user
returned via a SQL Statement. So - you could just alter the SQL in this
VBS and potentially run it do accomplish the same thing (note - the
Provider is SQL Server and it used single sign on - you will need to
change this to be appropriate for your DB). This is a true 'Delete'.
To re-create these users, you should really create new logins - not
'undelete' them.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion
[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: June 5, 2007 8:35 AM
To: eLink Recipient
Subject: Auto-Delete Users Who Haven't Logged in for > 190 Days

Auto-Delete Users Who Haven't Logged in for > 190 Days
Posted by Anderson, Robert on 06/05/2007 08:13 AM

Right now, we have a report that brings up every user that hasn't logged
in for 190 days:

select k.id, k.name, k.lastname, k.firstname, g.name groupname from
livelink.kuaf k, livelink.kuaf g, ( ( SELECT kuaf.id kid FROM
livelink.kuaf kuaf, livelink.dtree dtree WHERE kuaf.id = dtree.userid
AND dtree.subtype = 142 AND kuaf.userpwd IS NOT NULL AND kuaf.deleted =
0 AND dtree.createdate < sysdate-190 ) MINUS ( select userid kid from
(SELECT da.userid userid, max(da.auditdate) maxdate FROM livelink.daudit
da WHERE da.event = 'LOGIN' GROUP BY da.userid ) where maxdate > sysdate
- 190 ) ) badkuaf where badkuaf.kid=k.id and k.groupid=g.id and k.name
not like ('bl%%') order by g.name, k.name

We also have an undelete user report:

update KUAF set NAME =
substr(NAME,1,instr(NAME,'(Delete)',1)-2),DELETED=0 where ID = %1

Which I have changed into a delete user report:

update KUAF set NAME = CONCAT(NAME," (Delete)"),DELETED=1 where ID = %1

What I want to do is somehow combine the two, but all I've gotten are
sql errors.

Any suggestions? We're running 9.2 (unfortunately).

[To reply to this thread, use your normal E-mail reply function.]

============================================================

Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677

Livelink Server:
https://knowledge.opentext.com/knowledge/llisapi.dll

To Unsubscribe from this Discussion, send an e-mail to
unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

[To reply to this thread, use your normal E-mail reply function.]

============================================================

Attachment link: UserCleanupUtil.txt
https://knowledge.opentext.com/knowledge/llisapi.dll/open/12475610

============================================================

Topic: Auto-Delete Users Who Haven't Logged in for > 190 Days
https://knowledge.opentext.com/knowledge/llisapi.dll/open/12473635

Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677

Livelink Server:
https://knowledge.opentext.com/knowledge/llisapi.dll

To Unsubscribe from this Discussion, send an e-mail to
unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Srini_Venkataramani

Message from Venkataramani, Srini via eLinkBhupinder and Eric - Thanks very much for your replies! I tried Eric'squery first and it did the trick for me. -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Tuesday, June 05, 2007 11:51 AMTo: eLink RecipientSubject: RE RE RE Auto-Delete Users Who Haven't Logged in for > 190 Days2

eLink User

Message from Lange, Harald <harald.lange@nsn.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Hm - it seems that there is no product responsible listening ... ?

[This is just for testing if my postings still arrive as user "elink" even if my email adress has been updated meanwhile.]

Best Regards,
Harald Lange

--------------------------------------------------------
Harald Lange
ShareNet-IMS Consulting & Development
CFO IT OP Mgmt & Support Applicat. SDE
Nokia Siemens Networks GmbH & Co. KG

Phone: +49 89 722 23024
Mailto:Harald.Lange@nsn.com
--------------------------------------------------------

Robert_Anderson_(robanderson_-_(deleted))

For reference, if nothing else, what sort of things occur when a user is deleted other than changing their name and changing Deleted to 1? I have a couple of clients that would like a sort of auto-delete, and this information would be good to have.Thanks so much.

volvostephen

Message from Fisher, Stephen via eLinkI believe there are callbacks that get fired when a deletion happens sowhich callbacks fire is dependant on what modules you have installed(when a deletion happens and then looks for all callbacks registered fordeletions and executed the code in each of the callbacks - I don'tremember exactly but sometimes there are pre and post callbacks aswell). For this reason - deleting through the user interface is alwaysbest as it respects all callbacks. If you are developing a genericsolution, then it should use the browser, LAPI or web services - not SQLstatements. -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: June 13, 2007 11:08 AMTo: eLink RecipientSubject: For reference, if nothing else, what sort of things occur whena user is...For reference, if nothing else, what sort of things occur when a useris...Posted by Anderson, Robert on 06/13/2007 11:06 AMFor reference, if nothing else, what sort of things occur when a user isdeleted other than changing their name and changing Deleted to 1? I have a couple of clients that would like a sort of auto-delete, andthis information would be good to have.Thanks so much.[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Auto-Delete Users Who Haven't Logged in for > 190 Dayshttps://knowledge.opentext.com/knowledge/llisapi.dll/open/12473635Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.*****************************NOTICE - This email (including all attachments) is the sole property of the HATCH group of companies. It may contain personal and confidential information, and is intended solely for the addressee. If you are not the intended recipient, any use, disclosure, copying or any other action is unauthorized and may be unlawful. This email is also subject to copyright. No part of it should be reproduced, adapted or communicated without the written consent of the relevant HATCH company.If you have received this email in error, please notify us immediately by return e-mail or via mailto:MailAdmin@Hatch.ca and delete all copies from your system.

Barbara_Denton_(tokeleuser5_-_(deleted))

KUAF.UserPrivileges is changed to 0 when a user is deleted.This query might be of use - shows a count of users grouped by KUAF.userprivileges, decoded. (Oracle SQL)select userprivileges, DECODE(userprivileges, 0,'Deleted',14,'Login disabled, no public access',15,'Login enabled, no public access', 127, 'User administrator, no public access',2048,'Deleted, public access on',2062, 'Login disabled, public access on', 2063,'Login enabled, public access on', 2111,'User administrator', 2143,'User administrator', 2127,'Can create/modify groups', 2175, 'User administrator', 2431,'System administrator',2319,'System administrator', 16777215, 'Admin user') "Rights",count(*) from kuaf where type = 0 group by userprivileges order by 2

David_Yergensen_(afftc1user3_-_(deleted))

As an Admin or Support member you need to be aware of the following when deleting Livelink Accounts:1.User Account is removed from all group memberships except current Department (home) group2.Personal Workspace is NOT deleted3.Workflow Assignments that are/were assigned to this user will become "Assigneeless". Workflow Manager or Admin will need to reassign these.What does this mean? It's best to have a "Deletion Process" in place where Support Team, or Admin will review the Account for Assignments and reassign prior to account deletion, and also clean out the Personal Workspace. It might also be a good idea to review if the user is/was a Project Coordinator and identify a replacement. Then, after those items have been accomplished, account is ready for deletion. These are the main steps...you might have more that include moving the user to a "Deted User" Department Group.

Jim_Coursey

Message from Coursey, Jim <jim.coursey@ngc.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

It's also good to look at the groups the deletee belongs to and try to identify someone to replace that person in each group...especially important when the deletee is the group leader of a number of active groups.