Here is magic query to extract all attachments from Omnitracker and their physical storage.
select request, 'path_to_your_attachments\'+substring(filename_on_disk,1,2)+'\'+ substring(filename_on_disk,3,2)+'\'+ substring(filename_on_disk,5,2)+'\'+filename_on_disk+'.'+ substring(orig_name,len(orig_name)-2,3) as fileOnDisk, orig_name from ( SELECT [id], CONVERT(varchar(MAX),CONVERT(VARBINARY(8),id),2) as filename_on_disk ,[request] ,[orig_name] FROM [Attachment] where request in (617674,760232,...))a
requests_id can be retrieved from this query:
select request from UserFields1 where f19_titel="your title of Incident/RFC/Problem"
2 myśli na “Omnitracker -extraction of attachments”
Does your site have a contact page? I’m having problems locating it
but, I’d like to send you an email. I’ve got some recommendations for your blog you might be interested
in hearing. Either way, great blog and I look forward to seeing it grow over time.
Please contact me via LinkedIn.