Client Configurations is Magic/SDE’s way of assigning clients to configurations (usually used as locations or personal configurations) and consequently to assets (inventory items). Whilst there is clearly a benefit to the client of the service desk knowing what assets the client has and where they are located, when logging a call via Self-Service the vast [...]

continue reading.....

In my last post I created a User-Defined Function (UDF) to determine if a given datetime fell within or outside working hours (as defined by a given work schedule). This post will discuss how to use a function such as this in business rules.
Ok so lets say you want to check in a business rule [...]

continue reading.....

A couple of posts recently in the Yahoo MagicSolutions forum made me realise that there was no easy way of checking if a given datetime was during or outside working hours (as defined by the work schedule). Consequently I set about writing a UDF that would accept a work schedule name and datetime as an input [...]

continue reading.....

A colleague of mine recently asked me to take a look at a request a customer had that involved wanting to be able to view an image of the client on the Incident screen when the Client ID was selected.
My immediate suggestion was to create a calculated field in the clients module that was a [...]

continue reading.....

Calculated fields are fields that appear in a SQL or Oracle view but that are not real fields in the underlying tables. Some examples of calculated fields include:

Purchasing Items – Amount: A calculation of quantity ordered x unit price
Support Staff – Full Name: A concatenation of the support staff’s first name and last name

I remember [...]

continue reading.....

Welcome to JOATIT (Jack of all things IT)…
I am an IT professional working in the service sector since 1999. I am fascinated by technology and have developed skills in a huge range of technologies ranging in level from master to dabling depending on the technology.
This is my site, my experiences. I am a Jack of [...]

continue reading.....