List Collector Population

General 2 Comments »
by:

What to do when you want to populate the left and right side of a list collector variable (slushbucket) with the values found in your database? For example you want to update the member list of a group in a catalog item. The list collector should start with the current situation in your database:

• Left side should contain all users, but not the users who are currently a member of the selected group
• Right side should contain all users who are currently a member of the selected group
Continue reading…»

A different approach to attachments

General No Comments »
by:

One of our customers had the need to hide attachments under certain curcumstances on tickets. Now, with out of the box ServiceNow, the user can see all attachments if he has read access to the ticket. An additional demand was that they wanted to give their attachments a name (within ServiceNow).

Out of the box, it is not possible to name your attachments, and it’s not possible to customize the ‘Attachments’ functionality. So, we had to come up with some way to allow this.
image002
Continue reading…»

Things to consider when defining SLAs, OLAs and UCs

General No Comments »
by:

In addition to a blog I have written two years ago about defining SLAs in this blog I want to go a bit deeper into the things to consider when you start defining your SLAs, OLAs and UCs. I hope this blog will give you some guidance.
Continue reading…»

A view on database views

General 2 Comments »
by:

Database views in ServiceNow are somewhat limited, but with a bit of creativity you can still make good use of them. The two main uses of database views are: Reporting and (direct) Web Services.
This blog will try to list the options and limitations of ServiceNow database views by trying translate SQL statements to ServiceNow Database Views. Below you will find a number of Information Requirements that you could have and the technical way to deliver this information. Goal is to show a technical concept where Database Views together with Before Query Business Rules provide a much more powerful solution that Database Views alone.
Continue reading…»