Question on what some Mailbox Importer column values mean

[Ryan_Wakefield]

Hello,

I am working on creating a dashboard that will allow me to view ALL of my Mailbox Importer Accounts and their configuration overall. However, I have a few columns that I could use some help in understanding what that column is for as well as how to calculate the value of a flags column to know what they mean.

Column Questions

Firstly, there is a column named "namedaccountnum" in the "hsi.subscriptiontable" table. What does this value refer to?

Flag Calculations

1. There is a "Flags" column in the "hsi.ssaccount" table. Can someone please tell me what the different bitwise calculations are so that I can know what checkboxes they equate out to?
2. There is a "Flags" column in the "hsi.subscriptiontable" table. Can someone please tell me what the different bitwise calculations are so that I can know what checkboxes they equate out to?

If I find others, I will ask. Otherwise, these are the ones I am looking for right now.

Thanks.

[Mike_Walkuski]

Hey Ryan,

Here are the answers to your questions, I hope this helps!

The namedaccountnum column is not used by the software.

For Flags values are as follows:

hsi.ssaccount

0x00000001 (1) - Use POP3
0x00000002 (2) - Use SSL
0x00000004 (4) - Use Exchange Web Services

0x00000008 (8) - Use MSGraph

0x00000010 (16) - Use Gmail

hsi.subscriptiontable

0x00000001 (1) - Convert the email to HTML (no longer used)
0x00000002 (2) - OCR Image Attachments
0x00000004 (4) - Set the batch to fully indexed
0x00000008 (8) - Save the email as plain text
0x00000010 (16) - Exclude embedded attachments from archival

[Ryan_Wakefield]

You rock @Mike Walkuski . Thanks a TON for this information. 🙂