AnsweredAssumed Answered

SQL Query to Replicate File History

Question asked by Andre Davis on Feb 22, 2016
Latest reply on Jan 24, 2018 by Radoslaw Markun

I've written a query that mimics the "History on ..." report, except that I can't figure out where the Event column is coming from.

 

I'm missing several Event names when I run the attached "File History.sql" query. You can run the query and compare it to a file history in your own system by setting the @filename variable at the beginning of the query.

 

Does anyone know where I can find the missing event names? I've attached the results of my query for a file and the file history. The highlighted event on the pdf  (file history from solidworks) is an example.

Outcomes