Hi Neel
Yes, the original To: address is retained in the To: field. The attachments stored in the database are compressed, but with a proprietary compression algorithm, so you cannot access them directly from the database without going through the Remedy API. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application See the <http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf> ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk <http://www.westoverconsulting.co.uk/> _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of SUBSCRIBE arslist Neel Sent: Wednesday, May 02, 2007 9:21 PM To: [email protected] Subject: Re: How to reduce Inbound/Outbound mailboxes & attachment space. Hi David, Thank you for a quick reply. This is something I was looking to do. But to clear up my confusion, if I do set-up email aliases let's say [EMAIL PROTECTED], [EMAIL PROTECTED] and [EMAIL PROTECTED] pointing to a same mailbox [EMAIL PROTECTED] , if I look at that email record within AR System Email Messages form, what would be "to" email address? Would it still point to the emails of those aliases (sounds like they will be if I understood your email correctly) or would it point to [EMAIL PROTECTED] email and the aliases will be accessible from some other fields? Also, I was under the impression that attachments in remedy db are not compressed. Do they get compressed before they get saved into the database? Thank you for your help :-) Neel Gautam From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders Sent: Wednesday, May 02, 2007 11:18 AM To: [email protected] Subject: Re: How to reduce Inbound/Outbound mailboxes & attachment space. Hi Neel You can set up multiple email aliases pointing to a single mailbox, so all your inbound messages are delivered to the same place. You then have the address it was sent to in the To: address, so you can use workflow to set row level access etc. based on that value. For outgoing mails, again you can use a single outgoing account, but set the From: and Reply-to: addresses through workflow. The only way to manage the size taken up by your attachments (they are already compressed) is to delete old records. HTH David Sanders _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of SUBSCRIBE arslist Neel Sent: Tuesday, May 01, 2007 5:04 PM To: [email protected] Subject: How to reduce Inbound/Outbound mailboxes & attachment space. Importance: High Hello fellow-listers, The application we are developing support multiple BPOs, each BPO has multiple companies and each company has multiple support-groups. Now, we have an staging form with table fields to show emails from 'AR System Email Messages' form and we have multi-tenancy defined on this staging form (on the table field) so users can see only emails sent to any of the support-groups they have access to. Because of this design, we have mailbox set-up for each support-group and now we have about 150 incoming and 150 outgoing mailboxes and it's increasing exponentially as new bpo/company comes on-board. I think this seems like a common problem many people might have faced already. If so, is there any strategy or an approach to reduce number of mailboxes (at the same time I need multi-tenancy on email records as well)? Also, along the same lines, any efficient ways to store attachments for emails? Attachments are quickly filling out the db server space. Any ideas/suggestions are welcome. Thank you, Neel Gautam This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
