Does anyone have a EDPM Report that will return files that have been deleted and not destroyed?
Okay - stupid mistake - I was joining to a table that wasn't needed.
Here is the updated very simple version - It just gives you the filenames of deleted files.
I ran it but nothing reported back and I know that we have deleted files in the vault that have not been destroyed.
Do I need to adjust anything in the report you sent me?
Let me look at it again and make sure I didn't forget something.
What exactly are you trying to do?
We are looking trying to see what files in the vault have been deleted and are waiting to be destroyed by the Admin.
Hi Todd, I deleted the old one and added the new one - does that work for you? Joy
It does return some files but I was expecting to see a a lot more files than the report showed.
Does the ".crp" file you esnt me just return the deleted files per the logged in user? I was looking to get all the files in the vault that have been deleted.
I am trying to wrap my head around this reporting stuff.
Hi Todd - No, it should be for all files. It's a simple query on the documents table. Select Filename From Documents WHERE Deleted = 1 (you can open the crp in Notepad) It should list every file that is deleted but not destroyed. Joy
Yes what you sent works great.
If I am in my vault and RMB on a folder - Properties - Deleted Items, I see files that do not show up on the report.
That's weird. You might want to give your VAR a call and have them look at it with you.
Todd - Did you contact your VAR? If you do, ask them to open an SR so we can look at the issue more closely. Regards, Joy
Sorry for the delayed response. I was put back onto production work so all the fun stuff had to be put on the sideline. I will be talking with IT this week.
I have some answers back on this problem. We tried various different queries but they still did not return what we expected. I did contact my VAR, Design-Point Solutions, and here is what they sent back...
Good afternoon Todd, When a project is deleted and not yet destroyed, this is recorded in the database table "Projects" under the "Deleted" column (as True or False). Queries from the administration guide can be modified to include a condition as below: P.Deleted != 'True' OR P.Deleted != 1 So a complete query will be: ___________________________________ Select P.Name From Projects P, ProjectTree Pt, Projects P2 where P.ProjectID > 1 And P2.Path Like '\Level_1\' And P2.ProjectID = Pt.ProjectID And P.ProjectID = Pt.ChildProject and p.Deleted != 'True' Order By P.Name Asc --------------------------------------------------------------- Note: The project path needs to be edited as per the requirement. The 'Flushed' flag is used internally in the undo-check out operation to see if file has been checked in with references beforehand. Added files get value 1, checked in files with reference information gets 2. You should not modify that flag manually - or any SQL data for that reason. Please let me know if you have further questions.
Best Regards, John E. Shuey Jr Application Engineer, Certified SOLIDWORKS Professional DesignPoint Solutions, Inc www.design-point.com
Hi Todd, I'm not clear why the response was regarding folders. Where you trying to delete folders as well? In any event, are you planning on going to SOLIDWORKS World? If so, bring a backup of your database and find me and we can take a look at it. (I'll be presenting a learning T-SQL session as well). Regards, Joy
We are still a little "fuzzy" on the report yet.
I am hoping to get out to 2015 SWW. I will be submitting my proposal to management this week.
Retrieving data ...