Hi
I found that the user properties has an extra tab in 6.5 with Displayname and email which we do not find in 6.1.Can anyone tell me for what we can use these exactly.
Thanks
Cathy
Cathy (BOB member since 2005-11-23)
We use them for information only purposes.
We modified the auditor universe to include the table. Now we can display an actual name instead of a BO user ID. This will allow us to move to a common user ID across all systems. But, we’ll still be able to know who “e23523” actually is.
We use the email ID so that we can generate a distribution list so we can notify users when there is going to be a major change to something in the environment.
Steve Krandel 
(BOB member since 2002-06-25)
We LOVE the email detail for the reason that Steve mentions - we can quickly generate emails lists to alert our users to service disruptions, major fixes etc. We have a universe built on our repository that exposes this detail so we can build a report in any way we like, especially by group membership to tailor it to a particular universe/location etc.
Previously we had to maintain distribution lists in Outlook and it took forever to keep them in synch with BO and they weren’t very flexible, unlike building a report in BO.
This has saved us hours of admin work. The only drawback being in entering the email address correctly in the first place 
beckster 
(BOB member since 2003-02-18)
Hi beckster,
can you send me please the universe you built on the Repository Data? I have to build a report with user name, E-mail and group (many levels) to alert users to service problems. I enter all E-Mail adress in Supervisor.
Thx in advance.
Jamila
Jamila 
(BOB member since 2004-12-03)
OK I’ve attached a copy of my universe and the report I use for emails.
This universe is used for reporting on Users and on Documents in the document domains and and most particularly monitoring Jobs on Broadcast Agent. It doesn’t touch on other parts of the repository - I use my version of managero for that. If you find things a bit quirky in it - then that’s just how I work!
There is a repository universe by Cindy-guru in BOBs downloads which does much more clever stuff with hierarchical inheritance which I keep meaning to merge into mine but never find the time. You could easily add the email field to that (though it may require an outerjoined alias of OBJ_M_USRATTR, column M_UATT_C_ATTRVALUE).
You just need to replace the connection with another to your own security repository.
The Emails report has a few conditions to exclude null emails or disabled logins, and a prompt to allow the selection of groups (or ALL). It simply returns a list of all matching emails. I save this as text, copy them all and paste into the To/CC/BCC fields of an Outlook email. I usually do a check names before sending in case any of the addresses are not recognised by our email system (they should all be internal).
Have fun! P.S. I do not guarantee that this universe is logically correct, but it has always worked for me! 
Repos65.zip (28.0 KB)
beckster (BOB member since 2003-02-18)
Thanks a lot beckster for your help. I will try it.
Have a nice day!
Jamila
Jamila (BOB member since 2004-12-03)
Hi Beckster,
It appears as though your universe was built to work with an Oracle DB. Do you have a version, or can you suggest a way to convert this universe to work with SQL Server 2000?
Thanks!
Tubejig
Tubejig (BOB member since 2005-03-22)
I don’t have a SQL Server 2000 version - we don’t use that Db.
However you should be able to convert it. Create the connection to your repository then go through the objects to check for Oracle specific functions and replace them with SQL Server 2000 equivalents.
Easy ones may be sysdate, substr, decode, mod, to_date etc.
The ones you might struggle with are bitand, from_tz - there may well not be a direct equivalent. I can only suggest searching the net for more help. Some of them are really only for better display though, you can probably get away without the from_tz type stuff - just display the date without it.
Sorry not to be of more help.
beckster (BOB member since 2003-02-18)
Ok will do. Thanks for all your help and for sharing this universe. Much appreciated!
Tubejig
Tubejig (BOB member since 2005-03-22)