Which tables do I use to find all the DIP processes and the status of the DIP?

[#1]

I have looked at the Database Reporting Guide to find which table(s) store records for all DIPs and the only table it lists is the ParsedQueue table. When I query this table, it does not list all the DIPs that were run; I know this because I can see other DIP batches in the client that are not showing up in the ParsedQueue table.  Should I be looking at a different table?  I am ultimately trying to write a query if a dip completed and it's status, failed/succeeded.  Thanks in advance.

[Justin_Fandl]

Hey Lisa,

Typically the hsi.parsedqueue would be the only table in which a DIP batch resides. However if you send the batch to a Scan Queue (via the Send to Scan Queue setting on the Settings of the DIP process) it may have an entry in the hsi.archivedqueue.

Hope this helps!

[#3]

Perfect, thanks so much!!