Who has notification setup

David_Turpie

Is it possible to get a report listing users who have subscribed to an item?I am particularly interested in knowing which of my users have subscribed to a news areaThanksDavid

Martin_Gäckler

Here is a sample SQL:select distinct k.name "User Name", k.mailaddress "Mail Address", d.name "Node Name" from KUAF k, dtree d, notifyinterests2 n where k.id = n.userid and d.dataid = n.nodeid and n.nodeid in ( select dataid from dtree connect by prior dataid=parentid start with dataid=%1 )