Highlighted
Contributor.. Contributor..
Contributor..
527 views

Physical location of sysAttachments?

Hi All,

New to SM.

We are in the process of Gathering all the data in the Current SM system.
Puzzled of where exactly is the physical location of  SYSAttachments files (All the attachments) .

The MY SQL database and the SYSATTACHMENT  table is fine but where is the actual attachments located or situated?

 

Please advise.

 

Thanks in advance,

Albin

0 Likes
4 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Physical location of sysAttachments?

The actual attachment is in the SYSATTACHMENTS table in the column DATA.   A single attachment may be stored in multiple records.

In summary the entire attachment is stored in the RDBMS.

Steve Hirschfeld

 

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Physical location of sysAttachments?

... In summary the entire attachment is stored in the RDBMS.
Which are stored on the physical hard drive. 🙂
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Physical location of sysAttachments?

Be nice.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.