Forum Discussion
Solved
Project Site Email Addresses
Hi,
Can anyone confirm where on the SQL db that sits beneath PWA are the project site emails stored?
We are looking for a list of Projects / ProjectUIDs and the Project Site email address that can be queried in T-SQL.
Thanks in advance.
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
