It’s not a secret that Remedy stores dates using the epoch date format in number fields. The date is referred to the Greenwich reference time, or Zulu time. So a little adjustment must be made to translate this time to you time zone. This offset is composed by a fixed value and a variable value that depends on Daylight Time Savings (DTS).
If using Analytics or simply want to do some trick at the database level, a conversion utility between epoch a Oracle date format is very useful.
In this post I will cover this problem and I will provide you with the PL/SQL code of the conversion. … Read the complete post
I’m convinced that the case sensitiveness of Remedy is one of its major flaws. It can look like a minor issue, but believe me when I say that it can be the greatest source of incidences for your Remedy support team. Also for other languages that uses accents, the accent insesitiveness is a must, when sorting elements. So, changing your ARS instance to Case insensitiveness must be an objective. To have a Case Insensitive or Accent Insensitive instance of ARS is not difficult, but it isn’t straightforward. The best solution is to have the full text search enabled, but this is an extra cost in licenses. Sometimes you don’t have these licenses (or you don’t have enough for everybody), so another strategy is needed. Remedy bases all its comparisons and sorts in the database engine, so if we change the database engine, we change Remedy. That means that we must achieve that any ORDER BY or WHERE clause to be case insensitive. The solution then implies case insensitive sessions and indexes. If you control both, then you control your case sensitiveness. … Read the complete post