DIP Usage Query

[Mike_Kroner1]

Hello,

Would anyone have a DIP usage query?  Looking to clean up our DIP processes.

DIP Name|Location|Last import date and time

Thank you for  all of your help,
Mike

[Barbara_Ebel-La]

This looks to see when the DIP parse file last found an item to pick up.

SELECT max(pq.itemdate) MaxItemDate, trim(pq.parsefilename) ParseFileName, pq.parsefilenum ParseFileNum, pd.defdirname FilePath
FROM hsi.parsedqueue pq
join hsi.parsefiledesc pd on pd.parsefilenum = pq.parsefilenum
group by pq.parsefilename, pq.parsefilenum, pd.defdirname
ORDER BY 1 desc;

[Dirk_Vanderbent]

Hi Michael

Here is another query

Refer to Database Reporting Guide. Table parsedqueue. parsingmethod may be different for you. Adjust where clause to fit your needs

/*Query for DIP, Document Import parsingmethod 131076*/
/*COLD parsingmethod 1*/

SELECT            batchnum, batchfilename, parsefilename, parsefilenum,
                           datestarted, dateended, parsingmethod
FROM                hsi.parsedqueue
WHERE            hsi.parsedqueue.datestarted >= '2020-09-01'
                           and hsi.parsedqueue.parsingmethod = 131076
ORDER BY      hsi.parsedqueue.datestarted DESC