MessageQueryPrep status in NearPoint 3.1.x and higher builds

Run the following query to check the status of the messages waiting to be indexed:

select status, count(*) from MimosaExchangeItem_1..MessageQueryPrep (NOLOCK)

group by status

The status column values and their meaning are listed below:

-- 0 Message item not processed
    > DL expansion will work on these items and update STATUS = 11

-- 11 DL expansion completed, waiting to be indexed
    > Indexer will process and update STATUS = 1

-- 1 Message item already indexed
    > Query Prep task will insert record into MessageQuery / MessageQueryDetails tables

-- 2 Message item delete
    > Record deleted from MessageQuery / MessageQueryDetails tables

-- 3 Message item reset for reindexing
    > Indexer will process and update STATUS = 1

-- 4 Message item updated/read/modified
    > MessageQuery / MessageQueryDetails tables directly updated with new value.

-- 5 Message item error while indexed
    > Message item will be re-indexed


See the following Mimosa knowledgebase articles for more details.  (Requires access to Mimosa Systems customer support portal.)

MessageQueryPrep status in NearPoint 3.1.x and higher builds
http://mimosasystems.custhelp.com/app/answers/detail/a_id/364/kw/index%20queue/related/1

NearPoint Archive is out of date (Browse -- Current as of:)
http://mimosasystems.custhelp.com/app/answers/detail/a_id/615