Skip to main content
B
BrianToussaint19-Tanzanite
19-Tanzanite
October 5, 2017
Question

SQL Table for Links?

  • October 5, 2017
  • 1 reply
  • 2024 views

I was wondering if there is a SQL table for the Attachments portion of a CN Task?  We have a bunch of links in the CN Task area that are pointing to a server name that has been changed.  It would be nice if these were stored in a table and I could just change the link from the database side.  Anyone know if this can be done?

 

We are on Windchill 11.

 

Thank you,

Brian

1 reply

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
October 5, 2017

Hi Brian,

this article could be useful for you?

 

https://www.ptc.com/en/support/article?n=CS63595

 

 

Marco
B
BrianToussaint19-TanzaniteAuthor
19-Tanzanite
October 5, 2017

Hello Marco,

 

That contains a lot of good information for affected/resulting and tasks.  But it doesn't seem to have where attachements are.  I'm hoping they are not blobs.  This is the information that I am looking for from the task.

10-5-2017 12-07-06 PM.jpg

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
October 6, 2017

In my Resource for Reporting document there are some reports that may help.

 

This is one: https://www.ptc.com/en/support/article?n=CS42155 that lists the size of "CAD Documents" and their vault location.

 

You can search where EPMdoc are stored in vaults using name or number.

 

Marco
Terms & ConditionsCookie settingsAccessibility statement