Skip to main content
B
23-Emerald III
BenLoosli23-Emerald III
23-Emerald III
June 29, 2022
Solved

Who accessed a file

  • June 29, 2022
  • 5 replies
  • 3414 views

The engineering manager is asking if it is possible to report on who access a file in Windchill.

I can give him check-in reporting on who checked in what file, but I think he is looking for the user id and file name that anyone may have just accessed or pulled up for display in CreoView.

Is this possible by enabling some setting that is off by default or will it require special code?

We are currently in Windchill 11.1 M020 CPS20. If Windchill 12 has some advanced reporting capabilities that would be good to know.

 

Best answer by avillanueva

Yes, you can do this in two ways. If you have enabled security audit reporting, this data should be tracked in the database. It will let you know who downloaded what, when and from where.  The other place would be the webserver access logs but might take you a bit to determine which line relates to the transaction.

 

avillanueva_0-1656510888480.png

 

5 replies

avillanueva
23-Emerald I
avillanueva23-Emerald IAnswer
23-Emerald I
June 29, 2022

Yes, you can do this in two ways. If you have enabled security audit reporting, this data should be tracked in the database. It will let you know who downloaded what, when and from where.  The other place would be the webserver access logs but might take you a bit to determine which line relates to the transaction.

 

avillanueva_0-1656510888480.png

 

    T
    23-Emerald IV
    TomU23-Emerald IV
    23-Emerald IV
    June 29, 2022

    Two possibilities.

    1. Parse the Apache web server access logs.  Not easy to do and you will need to go through all of them.
    2. Enable audit logging.  This is probably not enabled out-of-the-box at the level of detail you need, so it may not help with something in the past.  Also keep in mind that the more stuff you audit, the faster the audit log grows and the more frequently it will need to be purged.

    https://www.ptc.com/en/support/article/cs270619

    http://support.ptc.com/help/wnc/r11.1.2.0/en/#page/Windchill_Help_Center%2FAuditAdminAuditEventRecordConfig.html

     

    HelesicPetr
    22-Sapphire II
    HelesicPetr22-Sapphire II
    22-Sapphire II
    June 30, 2022

    Hi @TomU 

     

    From Windchill 11.1 the download event in audit logging is enabled by default so do not need to configure it perfect.

     

    In Windchill 11.0 (and earlier) it is not enabled as a default. So you need to activate it.

     

    From my experience, if there is not reason to keep the information I set the download event log off.

    It can generates "tones" GB logs per months in a database which are never used .(Why? because a visualization user is been logging all the time the visualization works)

     

    PetrH 

    D
    18-Opal
    d_graham18-Opal
    18-Opal
    June 30, 2022

    I wrote query report that is run from the action menu of the WTDocument (or EPMDocument).

    In short, the action opens the report after automatically passing the object's id to the report.

     

    The manager just has to select the action in the actions menu and then the Generate button and that run the report which displays who downloaded the file, when they downloaded it, etc.

    Works well and can be expanded.

     

    Looks like this.

    d_graham_0-1656589890289.png

     

    When the *Download Report button is selected a Report opens that, in the background, has been automatically edited to use the object whose page was used to open the report as the search criteria.

     
     
     
     
     

    When the *Download Report button is selected a Report opens that, in the background, has been automatically edited to use the object whose page was used to open the report as the search criteria.

     

     

    Results can be whatever is required.  This is just to show it's doable.

    d_graham_1-1656589044955.png

     

    Results

    d_graham_2-1656589044990.png

     

     

    David

      B
      23-Emerald III
      BenLoosli23-Emerald IIIAuthor
      23-Emerald III
      June 30, 2022

      I have looked at the security logs and they give download information, but I think that only pertains to Creo downloads.

      Is there any indication of when the CreoView imbedded image has been downloaded to CreoView? This may be more useful to what the manager is looking for as we recently had a file marked up after being printed from CreoView and sent to a vendor. 

       

      D
      18-Opal
      d_graham18-Opal
      18-Opal
      June 30, 2022

      @BenLoosli 

       

      You may be able to get what you're looking for by keying off "View Representations" event rather than Download.

      That too is stored in the database.

      M
      22-Sapphire I
      MikeLockwood22-Sapphire I
      22-Sapphire I
      June 30, 2022

      I did this test just now.

      Set to true in configAudit.xml; purged all records.

       

      Accessed a published CAD Drawing in Creo View.

      - auditrecord includes one event, event lable: View Representations (no download event)

       

      Printed to PDF from Creo View

      - auditrecord does not have any additional events

       

      So....

      Accessing and printing a published drawing using Creo View does not seem to provide any way of auditing the user action of providing this to a vendor.

       

      Note: If added to a workspace, opened in CAD and then other actions needed to provide to a vendor, this does result in the Download event.

       

      avillanueva
      23-Emerald I
      avillanueva23-Emerald I
      23-Emerald I
      June 30, 2022

      I think you got to the heart of the issues Mike.

      https://www.ptc.com/en/support/article/cs370080?language=en&posno=1&q=Audit%20logs%20view%20representation&source=search

      I found this in the knowledge base and they opened up an SPR.

      Terms & ConditionsAccessibility statement