AnsweredAssumed Answered

PDM SQL Query to Find Modified Files

Question asked by Keaton Warn on Jun 12, 2019
Latest reply on Jun 12, 2019 by Christian Chu

What I'm looking for:

1. A way to find and export some sort of report document that details which users modified how many files in PDM within the last 24 hrs.

2. Added bonus if the document has a graphical interpretation of some sort.

 

I'm still pretty new to PDM and have no SQL experience so I'm trying to learn more about how to make SQL queries/reports in PDM. I realize this might not be the best route to take to achieve my goal, especially since I don't know if/how to get the SQL data, or how to export it to some sort of document file (PDF, Excel, Word, text file, etc). Writing a script using the API and scheduling it to run every night might be a better option, especially since I know it could interact with Excel to generate some graphs to represent the data its pulling.

 

Thoughts?

Outcomes