Report for active or not user

Julien Discours

Hello everybody,

I searching the best way for make a list if an user take a OT licence or not.

My sql {select ID,Type, Name, Deleted, GroupID from otcs.KUAF where Type = 0 and Deleted = 0}

this sql do the job but when i compare with the sysreport i have some interrogation...

If i suppress an user, in database this one will be change the Deleted colon to 1, it will be always an active user or not ?

Thanks per advance

 

Colin_Schmidt

DELETED will be ‘0’ for Active and ‘1’ for Deleted (license surrendered).  Maybe the difference is “login-enabled” vs. Disabled.  Deleting a User ID via the DB (SQL Developer or SQL Server Studio) is the wrong method and will produce this discrepancy.  Deleting an ID through the proper GUI interface does more than just flag a KUAF record.

 

Colin J. Schmidt

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, July 12, 2017 12:35 PM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Report for active or not user

 

Report for active or not user

Posted by Discours, Julien On 07/12/2017 12:29 PM

 

Hello everybody, I searching the best way for make a list if an user take a OT licence or not. My sql {select ID,Type, Name, Deleted, GroupID from otcs.KUAF where Type = 0 and Deleted = 0} this sql do the job but when i compare with the sysreport i have some interrogation... If i suppress an user, in database this one will be change the Deleted colon to 1, it will be always an active user or not ? Thanks per advance

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

 

---

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.