09-29-2020 10:03 AM
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
09-30-2020 06:32 AM
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;
09-30-2020 07:01 AM
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
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.