wynalazkowo - eksperymenty małe i duże

Omnitracker – integration with ServiceNow – last words

Omnitracker – integration with ServiceNow – last words

This is continuation of story, which started last year in March. For following months we were fighting, fixing and adjusting this interface. Here are some more issues which should have been considered at the beginning of this project, but everybody knows that the wisest you are after the facts;): there should be a mapping betweenWięcej oOmnitracker – integration with ServiceNow – last words[…]

Omnitracker -extraction of attachments

Omnitracker -extraction of attachments

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”

Omnitracker – integration with ServiceNow

Omnitracker – integration with ServiceNow

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[…]

Omnitracker – import of data from Powershell

Omnitracker – import of data from Powershell

$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()

Omnitracker – reports in different way

Omnitracker – reports in different way

’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[…]

Windows Server 2008 R2 – permissions for COM objects

Windows Server 2008 R2 – permissions for COM objects

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[…]

Omnitracker – SVN integration

Omnitracker – SVN integration

’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[…]