nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Documents non viewed and non fetch

Laurent_Scaon_(MotulAdmin_(Delete)_2225025)

Hello,i am trying to realize a livereport which lists all the documents non viewed and non fetch since a certain date.It doesn't work.Would you please help meThankslaurent SCAON

Find more posts tagged with

Comments

BSandUser4_(Delete)_567006

You can try:SELECT DISTINCT a.dnameFROM DAUDIT a, DTREE b WHERE a.event != 'VIEW' and a.event != 'FETCH'AND b.subtype = 144AND a.dataid = b.dataidAND a.auditdate > %1;Choose "UserInput1" as Param%1, "Date" as Inputs type.Good luck!

Dave_Russell_(CCIDR_(Delete)_2115817)

....Unless you're using a CACHE server. If you use a Cache server, the FIRST time a document is retrieved through the server it will be recorded in DAUDIT. As long as it doesn't change, however, the cache server will serve it from it's own local copy and no entry will be made in DAUDIT....Looking to all intents and purposes like nobody is fetching/viewing the document......