Forum Discussion
Project Site Email Addresses
Hello APS1979 ,
A list of Projects / Project IDs can be found in the Reporting schema in the PWA database. The email address for SharePoint site mailboxes will be in the SP content DB but that is not supported to query that schema directly with T-SQL, you will need to use the SP APIs but I'm not sure what the API method is that returns the site mailbox details - if there is one.
Paul
Hello APS1979 ,
A list of Projects / Project IDs can be found in the Reporting schema in the PWA database. The email address for SharePoint site mailboxes will be in the SP content DB but that is not supported to query that schema directly with T-SQL, you will need to use the SP APIs but I'm not sure what the API method is that returns the site mailbox details - if there is one.
Paul
Hi Paul,
is it possible to create a project custom field called e.g. "Project Site Email Address" where it's formula based and concatenates an existing custom field that holds the Project Code field, and adds it to to a set suffix?
e.g. =[Project Code]+"@globalemailaddress.com"
that way the field would then return a full email address? (I'm aware I;m very much over simplifying the formula somewhat, but you know what I'm getting at 🙂 )Hello APS1979,
This wont be possible using the out of the box Enterprise custom fields aa they are only aware of Project related fields / data. The SharePoint data is separate unfortunately.
Paul
Sorry Paul, I perhaps didn't phrase the question well enough; i'm not talking about the SharePoint data itself, I'm talking about creating a new custom field to effectively fake the email address per project without having to have any manual entry or duplicating of information in fields. Our email addresses are always the project code prefix.
We already have a custom field called 'Project Code', and was wondering if a new custom field could have a formula to look at the Project Code value and add a suffix (in this case the global email letters) to provide what will in effect be an email address value in total?
Project Code field = AB-1234
New Custom field formula = [Project Code]+"@myworkemail.com"
New Custom field value would then be AB-1234 @ myworkemail . com(Separated characters due to forum enforcing removal of any address)
