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”

This blogpost was designed to be quite different – as next easy-peasy thing, which can be configured in Omnitracker,’cause what can be difficult in configuration of EmailGateway beside writing complicated parsing script? This integration turned it to be very hard to me. It started last December, when I configured 3 EmailGateway rules for parsing emailsWięcej oOmnitracker – integration with ServiceNow[…]

Sometimes it is needed to set individual user permissions to chosen COM objects like (Excel). Here is short explanation what are these permissions and how to set them: Dcomcnfg.exe provides a user interface for modifying certain settings in the registry. By using Dcomcnfg.exe, you can enable security either on a computer-wide or a process-wide basis. … OrWięcej oWindows Server 2008 R2 – permissions for COM objects[…]

Under normal curcimstances Omnitracker enables import of data in easy and userfriendly way in following formats: csv Excel file/Access file LDAP DB connection via ODBC string data from another instance of Omnitracker data from MSExchange Usually configuration of import of data takes about 15-30 minutes. Import of data takes 15-60minutes (in assumtion that nobody usesWięcej oOmnitracker – import of data[…]

‚script retrieves all scripts from OT and stores it in current directory ‚in current directory following folders have to exist:globalScripts,folderScripts,globalforms,folderforms Dim objApp,objSession,scriptsG,scriptsF Dim script Dim AllFolders Dim formsF,formF Dim formsG,formG Dim objFS, objFile Dim CurrentDirectory Dim newfolderpath,newdir Set objApp = CreateObject („OtAut.OtApplication”) Set objSession = objApp.MakeSession („localhost”, 5085, „superuser”, „superuser”) Set objFS = CreateObject(„Scripting.FileSystemObject”) CurrentDirectoryWięcej oOmnitracker – SVN integration[…]

Without autoarchivization OT administrator has to once a year/month review all the folders and create subfolders with proper date and exclude them from main OT Index. Otherwise your OT index grows so fast that Omnitracker perfomance is really bad (imagine 4GB Index file). In order to have all your folders autoarchivized, use below script: AutoarchivizationWięcej oOmnitracker – autoarchivization[…]