reports that shows which users have a notification enables

Produce a live reports who's output produces all users who have notification enabled. The users may have many types of notification enabled, but we are simply interested weather or not they have it enabled. If you can pull out their name and email addresses.

Find more posts tagged with

Comments

jamespate

In the query below MAILADDRESS is the default email address for the user. They can over-ride the address for each of the three reports. The over-ride address is stored in MSGADDRESS.PARAMINT1 is which report it is 1,2 or 3.PARAMSTR3 is the name the user has given the report.ENABLED is whether email delivery is turned on.SELECT k.NAME, k.MAILADDRESS, a.MSGADDRESS, a.PARAMINT1, a.PARAMSTR3FROM KUAF k, AGENTSCHEDULE aWHERE k.ID=a.USERID AND a.ENABLED=1

EDMS_-_functional_NAM

Hello John, we are encountering lots of problem with notification and therefore i monitor everyday how many messages per user are in the table.Due to the fact that general interest could be set, and some people are doing that, we have difficulties, in our company im dealing daily with thousands of documents, you can imagine what happens when general interest is set.try this for a list select k.name, k.mailaddress, a.* from kuaf k, agentschedule a where k.id=a.useridthis this for a count per userSELECT DISTINCT rtrim(KUAF.LASTNAME)||' '||rtrim(KUAF.FIRSTNAME)||' '||rtrim(KUAF.NAME), KUAF.ID, count(Notifymessages.MESSAGESEQNO) FROM KUAF, Notifymessages WHERE KUAF.ID=Notifymessages.USERID GROUP BY rtrim(KUAF.LASTNAME)||' '||rtrim(KUAF.FIRSTNAME)||' '||rtrim(KUAF.NAME), KUAF.ID

Gavin_Adams_(gadams_-_(deleted))

Message from Adams, Gavin <GAdams@skm.com.au> via eLink

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

You might be interested in some other details that I have previously in these discussions.

A couple of years ago a document was posted which listed all the bit mask values for general interests.

Very handy document.

https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2878318&objAction=view

I also from time to time run the following queryto see which of our users have placed an interest on node zero (the entire system).

then I use the bit mask document to see which ofthose users have added interests for things like doc added/version added, etc.

select a.userid, b.name, a.eventidmask from notifyinterests2 a, kuaf b where nodeid=0and a.userid = b.idorder by a.eventidmask

Hope this helps,

Regards,

Gavin

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, 4 March 2004 7:53 AM
To: eLink Recipient
Subject: Hello John,

Hello John,		Posted by NAMUser1 (NAM, EDMS - functional) on 03/03/2004 10:05 AM
In reply to: reports that shows which users have a notification enables		Posted by GRETOR015 (Di Fruscia, John) on 02/04/2004 12:07 PM

Hello John,

we are encountering lots of problem with notification and therefore i monitor everyday how many messages per user are in the table.
Due to thefact that general interest could be set, and some people are doing that,we have difficulties, in our company im dealing daily with thousands of documents, you can imagine what happens when general interest is set.

try this for a list
select k.name, k.mailaddress, a.* from kuaf k, agentschedule a where k.id=a.userid

this this for a count per user
SELECT DISTINCT rtrim(KUAF.LASTNAME)||' '||rtrim(KUAF.FIRSTNAME)||' '||rtrim(KUAF.NAME), KUAF.ID, count(Notifymessages.MESSAGESEQNO) FROM KUAF, Notifymessages WHERE KUAF.ID=Notifymessages.USERID GROUP BY rtrim(KUAF.LASTNAME)||' '||rtrim(KUAF.FIRSTNAME)||' '||rtrim(KUAF.NAME), KUAF.ID