Skip to main content
M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
June 15, 2017
Question

query builder report - file downloads from CAD Attachments

  • June 15, 2017
  • 1 reply
  • 3234 views

We have a report which queries AUDITRECORD for the Download event. Works perfectly (not really needed any more with PSM actually but that's beside the point).

Starting to get interested also in downloads for CAD Docs from the Attachments table on the Content tab.

The security audit report for Download event and the query builder reports that I've created so far on the AUDITRECORD show download by user and timestamp, etc. but only report the parent CAD Doc, not the actual attachment file downloaded.

Anyone have a ideas on how we can filter for this?

Example - this CAD doc has Attachments (created/added via publish rules with automatic version naming); downloaded one of them (directly in a browser to local, not to workspace).  Hoping to be able report that specific download action.

AUDITRECORD reports:

1 reply

B
bcedar1-Visitor
1-Visitor
June 15, 2017

I don't have the level of logging turned on, but I am seeing a table called "wt.audit.eventinfo.DownloadEventInfo" and it refers to another table through a "Record Reference" which may be an auditrecord.  I wonder if that'd be a place to start.

M
22-Sapphire I
MikeLockwood22-Sapphire IAuthor
22-Sapphire I
June 15, 2017

Hey, that got me MUCH closer.  Thanks very much.

    P
    pkumar-91-Visitor
    1-Visitor
    December 18, 2018

    Hi -- I am trying generate report using your qml but no luck without, was it really working for you?

    Terms & ConditionsAccessibility statement