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”
Kategoria: Omnitracker
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[…]
$objOTApp = New-Object -ComObject OTAut.OtApplication$objOTSession = $objOTApp.MakeSession($strServerName, $strServerPort, $strLoginName, $strPassWd)$objOTFolder = $objOTSession.GetRequestFolderByPath($strFolderName) Do { Start-Sleep -Seconds 2 Write-Host „Waiting for OT response…” $objImport = $objOTFolder.MakeImport() #$objImport } Until ($objImport.Datasource -eq „”) #$objOTFolder.ImportDefinitionsWrite-Host „Importing objects to Omnitracker”$objImport.Datasource = $strFileName$objImport.Run($ImportName)$objImport$objOTSession.Logoff()
‚pokazuje wszystkie pola z danego katalogu oprocz inherited select ufd.id, pa.parent,ufd.area, pa.name asFolder, ufd.label, ufd.alias, ufd.run_time_field, otFieldTypes.field_type, case when ufd.[type] = 254 then ‚ReferenceList’+ Convert(nvarchar(50), ufd.id) else” end as RefTable, case when ufd.[type] = 254 then ‚ReferenceList’+ Convert(nvarchar(50), ufd.id) + ‚.Request = ‚+ rtrim(pa.name) + ‚ Object’ else” end as Description_Request, case when ufd.[type] =Więcej oOmnitracker – reports in different way[…]
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[…]
Last week I attended interesting IT conference related to the program, which I administer every day. Just now I am involved in upgrade of two OT servers, so I could test versions: 11.2, 11.3.3 and 11.4.0. After real disappointment with version 11.4.0 , which didn’t work at all for one of my databases and hadWięcej oOmnitracker Customer Day 2019[…]
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[…]