How to get the current epoch time in SQL Server? – use this command SELECT DATEDIFF(s, ‘1970-01-01 00:00:00’, GETUTCDATE()) In order to apply it to a Remedy statement you have to replace the GETUTCDATE() with a remedy field and you’ll […]

In order to create a License Usage report you have to activate license tracking in Server information. The report will be generated afterwords exporting data from the query output (designed of Oracle database): SELECT a.USER_NAME, b.FIRST_NAME, b.LAST_NAME, a.APPLICATION, a.TYPE_OF_LICENSE, a.LAST_DATETIME […]

Following is the steps to add custom field on SRM/Work Order. Please confirm if the steps have been followed Create a custom field on WO (WOI:WorkOrder form ,WorkOrderCreate_Interface form and WOI:WorkOrderInterface). Configure custom fields on SYS:Form Field Selection and Application […]

I need a formula that converts the Remedy timestamp into Oracle date/time field. I have referred to KB article: 000000006132 and formula given in the article is working fine. SELECT TO_CHAR(TO_DATE(’01/01/1970 00:00:00′, ‘MM/DD/YYYY HH24:MI:SS’) + (C3 / ( 60 * […]

Question: How can you quickly realise business value from a fully integrated PPM & ITSM Enterprise Solution? Answer: The ITSM Clarity Connector takes two of the market leaders, CA Clarity PPM & BMC ITSM, and seamlessly integrates the data flow […]

See below the list of known implementations of NTLM protocol: Jakarta (Apache) HTTP Client (free, Apache license) – Support for LM/NTLM (not NTLM V2) protocol on all Java platforms. Requires JRE 1.2 or higher. Not plug-compatible with the Java UrlConnection […]

Jespa is a Java software library that provides advanced integration between Microsoft Active Directory and Java applications. Jespa is a comprehensive language-level security solution for Java applications. Rather than wrapping or inserting security into applications such as websites, Jespa provides […]