Hello
I am an admin of my company's CAD solution ( ~10 users )
we are currently running on SW-2020 EPDM Composer mycadtools mypdmtools.
I'm looking to get a list of the versions of the files in my vault with the users.
I tried with PDMReport but it only gives me the revisions, not the versions.
I saw that there was the possibility of doing SQL but I'm not an expert.
In the worst case I would like to locate the database to copy it and do my research via ACCESS.
Could anyone guide me?
Thanks in advance
Hello
I have more or less the same functions but I didn't really understand what you're trying to do.
And when you put " we're running for the moment on SW-2020, EPDM Composer, mycadtools, mypdmtools." it creates more confusion than anything else.
A simple answer could be to do a search on . at the root of the vault in full search (including subdirectories).
It may be a mess but at the end you can save the results (save icon in excel format).
What you want is maybe the list of extracted files (with users).
In this case you have to add this (uncheck the blue box):
And the request is much faster since normally there will only be a few dozen files
If you do not have the right information in your search result, you must set up your search map at the EPDM administration level
1 Like
Great automatic translation into English 
2 Likes
Hello and thank you for your answer,
I just specified the software version we are working on in case the answers are dependent on this version.
What I'm looking to do is have a database with all the transition histories of each file
example below find all the information in the image
I imagine they are stored on the server but I don't know where or if there is a way to access them.
Ideally, make a request of the type for all the files validate this month extract all the history of transitions.
If you know how to guide me
Thanks in advance
Hello
Everything is in the SQL database tables on the server: transition dates, by whom, for what...
Given your request, the best thing to do is to make a SQL query on this database.
This is where my contribution ends (I'm far from being a pro in SQL and you'll have to do JOIN and other subtleties to get a usable result (with file names instead of IDs...).
I'm afraid that the result of what you're asking for will be little or not at all usable because it will get you thousands of lines (especially since your workflow doesn't seem optimal since you create a lot of versions that don't seem very useful: " notification waiting for validation " state and " waiting for validation " state for example. Normally no need to have a " notification pending validation " state: EPDM can very well send a notification between ' modification ' and ' pending validation ' without having an intermediate state (NB: it is possible that you need this state for other reasons and changing the WFs during operation seems risky to me so you probably better live with it))
Hello
Thank you for your feedback, but where is this database?
during an exchange with a Visiativ technician, he told me about a software to consult this database.
but no way to find this software or even the databases
Do you know where I can find it?
Thank you for your feedback
Hello
Report generator integrated with Solidworks PDM.
1 Like