Is there a feature that allows us to send an email to all us...

[Justin Thomas 2]

Is there a feature that allows us to send an email to all users

[Martin Yergeau]

WF has no feature to send e-mail.

You can use Report Caster but this is normally to distribute reports.

But, in the sense that I think you are requesting, AFAIK, no.

I use my corporate e-mail tool Outlook with a distribution group that contains all BI users

[Drew DeBaecke]

-SET &SENDEMAILTO=a.b@c.com;

TABLE FILE CAR

PRINT COUNTRY NOPRINT

HEADING

All,

 

This is an E-Mail notification sent via WebFOCUS

Further documentation is available at the link below:

 

https://webfocusinfocenter.informationbuilders.com/wfappent/TLs/TL_lang/source/03apps39.htm#WS25A4D021-2CBB-4405-A91C-D3474F6981AA

 

Thanks,

Your Name Here

WHERE RECORDLIMIT EQ 1

ON TABLE HOLD AS MAIL_FILE FORMAT HTML

ON TABLE SET AUTOFIT ON

ON TABLE SET STYLE *

TYPE=REPORT,GRID=OFF,BORDER=OFF,FONT=CALIBRI,SIZE=14,JUSTIFY=CENTER,COLOR=BLACK,$

TYPE=HEADING,JUSTIFY=LEFT,SIZE=12,$

ENDSTYLE

END

-RUN

-MRNOEDIT EX EDAMAIL &SENDEMAILTO, , E-Mail Notification via WebFOCUS from &IBIMR_user,HTML,mail_file

[Pierre CASTILLO 2]

Hello Justin,

if Drew link doesnt work, this one should help :

https://infocenter.informationbuilders.com/wf81rel/index.jsptopic=/pubdocs/reporting/DevelopingAppsWithWFLanguage/source/03apps38.htm

[Justin Thomas 2]

If I am still missing something in the documentation here, I apologize. But, I also need to generate a list of all user emails (from the email we added into the the user profile when we created the accounts in Security Center) that can be added in the EDAMAIL statement as a recipient list.

[Toby Mills]

Hi Justin

There is the possibility of generating a list of emails using the WF Client REST web services. Id like to ask a couple of questions though.

How many users are we talking about here

How often do you foresee sending an email to Everybody

What is the point of the email to everybody For example, if its a status update like system is down for maintenance, maybe it makes more sense to just change your web landing page for WebFOCUS to something that says its down for now. Or add a System News section to your main landing page for users when they first come in.

Are you using LDAP/AD for your security In that case, you might get emails from there. Also if you use this method for Authorization / Group Mapping, you might be able to add an Group email to your MODOC email servers.

There are lots of ways you might approach notifying users of things. Im just trying to get a feel for the higher level task at hand - how many people, how often and what are you trying to communicate

If youre going to use Security Center as the source of emails, itd probably be good to write yourself a little focexec to select the list of users by Security Group instead of going after all the individuals.

[Justin Thomas 2]

Hi Toby,

Currently, we have around 200 users, and we are using OPSYS security. We want to notify users in advance of an outage, during which time we will be upgrading our production environment. We will probably not need to do this very often. But, it would be good to have a process in place to notify users as needed in the future.

We are preparing to move to Active Directory, but not quite there yet. Im really just looking for a way to notify our active WebFOCUS users without sending a notification to all 8000 people in our Active Directory, the vast majority of whom will not be affected. I would prefer the option of sending a message over posting something on our home page (some of our users will only access the system a couple of times a month), but I guess either method will work. Im also not familiar with how to modify our home page. Ultimately, I want users to be able to provide feedback on the time we choose so we do not cause a problem if there are particular windows of time when they know they will need access for reporting.

I also attempted to query the UOA_USERS table without any success. Im not sure if Im looking for the wrong table, or if we are not properly configured to read system tables from the repository.

[Toby Mills]

Thanks Justin - it helps to know where youre trying to go.

It should work for you to just hit the UOA_USERS table and grab EMAIL and NAME where STATUS IN(ACTIVE,AUTOADD) Of course add any other Statuss you like there.

I bet youre just not allowed to see it for some reason. When I check mine, I can see everything.

If you end up putting people in Groups in AD, you can let AD do all the work of assigning users to Groups for you in the future using Mapped External Groups Its nice to push the admin work to the AD folks. Then you can make an email list based off the AD group.

Try getting someone with authority to show you the UOA_USERS and see if you can build a list of people that way. EDAMAIL should work, or you could use some external tool to fire off an email template you made in Word to go to all the users in your list you create.

Thanks again for the description. BTW, Im in the Kansas City area. I presume youre in Jeff City. Its always good to see an organization in KS or MO using WebFOCUS.

[Justin Thomas 2]

Thank you, Toby.

We didnt have a connection to our Repository. Once we created that, it was pretty straightforward concatenating emails from the UOA_USERS table.