Re: Email Messages Form Indexes?

2013-02-14 Thread Munukutla,Ravishankar
as well. Regards, Ravi From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: 14 February 2013 01:05 To: arslist@ARSLIST.ORG Subject: Re: Email Messages Form Indexes? ** Idea submitted... Review Email Engine form(s) indexing and adjust

Re: Email Messages Form Indexes?

2013-02-14 Thread Jason Miller
@ARSLIST.ORG *Subject:* Re: Email Messages Form Indexes? ** ** ** Idea submitted... Review Email Engine form(s) indexing and adjust as appropriate https://communities.bmc.com/communities/ideas/1758 ** ** Jason ** ** On Wed, Feb 13, 2013 at 9:44 AM, Drew Shuller drew.shul

Re: Email Messages Form Indexes?

2013-02-13 Thread Misi Mladoniczky
*To:* arslist@ARSLIST.ORG *Subject:* Email Messages Form Indexes? ** ** ** Good morning! Could anyone confirm what indexes are OOB on the Email Messages form? AR Server 7.5 Patch 008, MS SQL 2008 DB The first index contains 7 colums: Mailbox ID, Message Type, Priority, Send Message, Parse

Re: Email Messages Form Indexes?

2013-02-13 Thread Drew Shuller
After running combined SQL and API logs, Misi's suggestion was the one that identified the problem. The Email Error Messages form has no indexes, so I added one for the Email Message ID, which is in one of the queries that I saw in the log file. Now even an unqualified search on the 3400 or so

Re: Email Messages Form Indexes?

2013-02-13 Thread Jason Miller
Idea submitted... Review Email Engine form(s) indexing and adjust as appropriate https://communities.bmc.com/communities/ideas/1758 Jason On Wed, Feb 13, 2013 at 9:44 AM, Drew Shuller drew.shul...@gmail.comwrote: ** After running combined SQL and API logs, Misi's suggestion was the one that

Re: Email Messages Form Indexes?

2013-02-12 Thread Mayuresh Wagh
Shuller *Sent:* 11 February 2013 10:44 *To:* arslist@ARSLIST.ORG *Subject:* Email Messages Form Indexes? ** ** ** Good morning! Could anyone confirm what indexes are OOB on the Email Messages form? AR Server 7.5 Patch 008, MS SQL 2008 DB The first index contains 7 colums: Mailbox ID

Email Messages Form Indexes?

2013-02-11 Thread Drew Shuller
Good morning! Could anyone confirm what indexes are OOB on the Email Messages form? AR Server 7.5 Patch 008, MS SQL 2008 DB The first index contains 7 colums: Mailbox ID, Message Type, Priority, Send Message, Parse Message, Message ID and Execute/Send at. Is this OOB? The second index is one

Re: Email Messages Form Indexes?

2013-02-11 Thread patchsk
The email engine keeps a copy of OOTB email form and workflow def file in AREmail installation folder. You can open that def file in text editor and navigate to the Email Messagessection and see the index fields there. I have a copy of 8.x Email Messages form and here are fields I see as

Re: Email Messages Form Indexes?

2013-02-11 Thread Joe D'Souza
what meets your eye. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Drew Shuller Sent: Monday, February 11, 2013 12:14 PM To: arslist@ARSLIST.ORG Subject: Email Messages Form Indexes? ** Good morning! Could anyone confirm

Re: Email Messages Form Indexes?

2013-02-11 Thread Walunjkar, Parshuram
@ARSLIST.ORG Subject: Email Messages Form Indexes? ** Good morning! Could anyone confirm what indexes are OOB on the Email Messages form? AR Server 7.5 Patch 008, MS SQL 2008 DB The first index contains 7 colums: Mailbox ID, Message Type, Priority, Send Message, Parse Message, Message ID