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

Year 2020 – summary

Year 2020 – summary

This year was very bad for me. Lots of fear, uncertainty, overhours, rush. From the work perspective: participtaing in two dead-ends project rare oportunity of work with so called professionals from international companies (many of them with more than 10 years of IT experience):

SmartHome – how to add ActianZenDB as Addon and your main database in HomeAssistant

SmartHome – how to add ActianZenDB as Addon and your main database in HomeAssistant

After installation of HomeAssistant on RaspberryPI Zero using this tutorial: https://www.home-assistant.io/hassio/installation using Virtual appliance, I have installed following Addons: „SSH&Terminal” „Samba share” Afterwards I needed to create my own Addon as it was shown in this Addon for MariaDB: https://github.com/home-assistant/hassio-addons/tree/master/mariadb Following this tutorial : https://developers.home-assistant.io/docs/add-ons/tutorial/ I have created my own Addon for ActianZen. The clueWięcej oSmartHome – how to add ActianZenDB as Addon and your main database in HomeAssistant[…]

Pi hole – blokowanie reklam w Twoim domu.

Pi hole – blokowanie reklam w Twoim domu.

A to kolejny wpis mojego męża: Zacznijmy od tego – czym jest pi hole? Pi hole to prywatny DNS z opcją filtrowania adresów kojarzonych z reklamami. Po co to komu w czasach AdBlocka? Otóż adblock nie jest niestety doskonały – po pierwsze jest wykrywany przez różne strony, które potem serwują nam żebrozasłonę z tekstem “przecieżWięcej oPi hole – blokowanie reklam w Twoim domu.[…]

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”