Decode of user specific notification settings.

Has anyone a decode of the values in of colomn eventidmask in the tabel notifinterests2. So you can display the notification settings.Thanks

Find more posts tagged with

Comments

DFSG_CWE_AFMCAdmin_(afmcadmin_-_(deleted))

I have determined the values in the notifyinterest2 table for the general interests category when using 9.1.0. If you are interested and are using Oracle I could also provide you with functions that convert from decimal to binary and binary to decimal.

eLink User

Message from Mohsin Jessa via eLinkHi Armin:Thanks a lot for submitting the document on the general interests categoryof the notifyinterest2 table.For the benefit of others, could I please request you to submit yourfunctions to this thread.I am sure your contribution will be greatly appreciated by our usercommunity and hopefully that will prompt some MS-SQL server user to do thesame for that d/b.ThanksMohsinOracle Technical Specialist> -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion> [mailto:livereportsdiscussion@elinkkc.opentext.com]> Sent: Wednesday, October 09, 2002 11:07 AM> To: eLink Recipient> Subject: I have determined the values in the notifyinterest2 table for> the general...>>> I have determined the values in the notifyinterest2 table for the> general...> Posted by AFMCAdmin on 10/09/2002 10:55 AM>> I have determined the values in the notifyinterest2 table for the> general interests category when using 9.1.0. If you are> interested and are using Oracle I could also provide you with> functions that convert from decimal to binary and binary to decimal.>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Attachment link: NOTIFYINTERESTS2_table.doc> https://knowledge.opentext.com/knowledge/livelink.exe/2878319/NOTI> FYINTERESTS2_table.doc?func=doc.Fetch&nodeid=2878319>> ============================================================>> Topic: Decode of user specific notification settings.> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objI> d=2875724&objAction=view>> Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Greg_Lulchak_(greglulchak_-_(deleted))

Just in the case someone needs to find out which users have a particular notification setting.I've found a LiveReport Sample that might complement the document posted by AFMCAdmin.Change the bitmask value 8 for the interest bitmask value you want.Greeting,Fabián PazmiñoTaken from Sample LiveReports https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2073344&objAction=browse*********************************************************************************** Who has the "An Item is Added" interest checked for system wide additions to Livelink?**********************************************************************************In order to locate users who have the notification setting "An Item is Added" (i.e. an item is added anywhere in Livelink), you can use the following SQL in a LiveReport within Livelink (use the "AutoLiveReport" report format, not the "LiveReport" report format):SQL: select a.UserID, b.name "Login Name", b.lastname "Last Name", b.firstname "First Name", a.EventIDMask from NotifyInterests2 a, KUAF b where bitand(a.EventIDMask, 8) = 8 and a.UserID=b.id and a.NodeID=0

Andrew_Brown

Here is an Oracle query I put together that shows all the notification interests for a user including General Interests. Hope it is useful for some people.--Notification interests for a userSELECT k.name "User ID", DECODE(n.nodeid, 0, '* General Interest *', d.name) "Item Name", DECODE(n.interestlevel, 1, 'Urgent', 2, 'Medium', 3, 'Low', 'Other') "Priority", DECODE(bitand(n.eventidmask, 524288), 524288, 'My Task''s settings have changed; ', '') || DECODE(bitand(n.eventidmask, 64), 64, 'A Task is assigned to me; ', '') || DECODE(bitand(n.eventidmask, 4096), 4096, 'A Task is late; ', '') || DECODE(bitand(n.eventidmask, 8), 8, 'An Item is added; ', '') || DECODE(bitand(n.eventidmask, 8192), 8192, 'An Item''s status changes; ', '') || DECODE(bitand(n.eventidmask, 16), 16, 'A Version is added; ', '') || DECODE(bitand(n.eventidmask, 16384), 16384, 'A Version''s status changes; ', '') || DECODE(bitand(n.eventidmask, 65536), 65536, 'A Compound Document Release or Revision is added; ', '') || DECODE(bitand(n.eventidmask, 2), 2, 'A topic is added; ', '') || DECODE(bitand(n.eventidmask, 4), 4, 'A reply is added; ', '') || DECODE(bitand(n.eventidmask, 32768), 32768, 'A News item is added; ', '') || DECODE(bitand(n.eventidmask, 128), 128, 'A Workflow I manage has completed; ', '') || DECODE(bitand(n.eventidmask, 1024), 1024, 'A Workflow I manage is late; ', '') || DECODE(bitand(n.eventidmask, 256), 256, 'A Workflow step has arrived in my personal Assignments; ', '') || DECODE(bitand(n.eventidmask, 2048), 2048, 'A Workflow Step in my personal Assignments is late; ', '') || DECODE(bitand(n.eventidmask, 32), 32, 'I am added to a Group; ', '') || DECODE(bitand(n.eventidmask, 512), 512, 'I am added to a Project; ', '') "Interests", DECODE(n.nodeid, 0, '', '?func=ll' || chr(38) || 'objId=' || d.dataid || chr(38) || 'objAction=browse') "Url"FROM notifyinterests2 n JOIN kuaf k on n.userid = k.id LEFT JOIN dtree d on n.nodeid = d.dataidWHERE k.name = 'ENTER USERNAME HERE'/Andrew BrownDeveloper, Analyst, and Livelink AdministratorTransamerica ReinsuranceCharlotte, NC704.330.7652 (work)585.797.3923 (cell)andrew.brown@transamerica.com

Evert_Kuiken_(ekuiken_-_(deleted))

Message from <Evert.Kuiken@alliander.com> via eLink

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

Thanks for sharing Andrew! Came in very handy now that we have to delete a lot of accounts and cleanup Notifications.

Regards, Evert

Stacy_Butler

Thank you so much for sharing this report! We will definitely be using this one!

Rohan_Gadiya

Thanks a ton Andrew. This is very useful!

Rhulani Makhubele

Thanks for this useful report.

Colin_Schmidt

Here are some....for Oracle.

Colin S

Knowledgelink Support Admin

CapitalOne | Collaboration Technology

From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>
Sent: Tuesday, March 28, 2017 8:16:37 AM
To: eLink Recipient
Subject: Query to Determine all Notification Interests for a User

Query to Determine all Notification Interests for a User

Posted by Makhubele, Rhulani On 03/28/2017 08:10 AM

Thanks for this useful report.

[To post a comment, use the normal reply function]
Topic:	Decode of user specific notification settings.
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.

Pascal_SSC

Hello,

I am wondering if anyone knows the bitmasks for the new general interests available since this post. For example, in 10.5 there's now:

A Blog Entry is added
A Comment is added
A Forum Topic or Reply is added
An FAQ Entry is added

Thanks,

Pascal Desjardins

Shared Services Canada

Quoted DFSG CWE AFMCAdmin (afmcadmin - (deleted)) on 06/25/2018 09:39 AM:

Colin_Schmidt

It’d probably be an easy test…in Oracle.

Colin J

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, June 25, 2018 7:49 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: I have determined the values in the notifyinterest2 table for the general...

I have determined the values in the notifyinterest2 table for the general...

Posted bypascal.desjardins@canada.ca (Desjardins, Pascal) On 06/25/2018 09:39 AM

Hello,

I am wondering if anyone knows the bitmasks for the new general interests available since this post. For example, in 10.5 there's now:

A Blog Entry is added
A Comment is added
A Forum Topic or Reply is added
An FAQ Entry is added

Thanks,

Pascal Desjardins

Shared Services Canada

Quoted DFSG CWE AFMCAdmin (afmcadmin - (deleted)) on 06/25/2018 09:39 AM:

[To post a comment, use the normal reply function]
Topic:	Decode of user specific notification settings.
Forum:	Content Server LiveReports Forum
Content Server:	My Support

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored.

Colin_Schmidt

There are these docs:

https://knowledge.opentext.com/knowledge/llisapi.dll/fetch/6848762/19905386/Configure_Security_Parameters_Explained.pdf?nodeid=12782424&vernum=6

https://knowledge.opentext.com/knowledge/llisapi.dll/fetch/-3494545/3502719/8412324/Notifications_-_how_Bit_Masks_are_stored_in_the_AgentSchedule_table.pdf?nodeid=38398752&vernum=1