Adding new information (email address) to 'user info' database

[lee212]

We were requested to provide email address accompanied with portal user name. Since the ldap scripts has been updated to support email address with first name, last name, and uid, the database of cloud-metrics needs to be altered to include the new information.

This task will result in a list of actual users of FG in a following template: e-mail; portal username; first name; last name; iaas; date first use;date last use; overall used hours

Task (details)

1. Create a script to retrieve email addresses using portal usernames of actual users
2. Alter table to have a column of email address
3. Update records with the retrieved email addresses
4. Generate a list of actual users of FG

[lee212]

eca5e1723536592c62da144849e8bf08ede63034

[lee212]

c2bdd8c0af3f43315cce95bd12a46e97566bbea7

[lee212]

Now we have email addresses of portal users in the database