Some PDIs are currently unavailable, and PDI actions are paused. View the latest updates here. Read More

Developer forum
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Query against Configuration Items and Relationship Table

Hello,We are trying to get a list of all of our Configuration Items (CI) that do not contain a relationship to another Configuration Item.I was building a query to go against the cmdb_ci and cmdb_ci_rel tables to get this information, but it appears ...

mdidrikson by Kilo Contributor
  • 2962 Views
  • 2 replies
  • 0 helpfuls

Resolved! MAC Address Formatting

I've seen some inquiries and information related to MAC address transformation/normalization, but I'm not exactly the best at regular expressions so I'm having trouble getting this to work.My instance contains several forms (including the Incident fo...

jevans by Kilo Contributor
  • 6632 Views
  • 5 replies
  • 0 helpfuls

Getting wrong Duration days

Hi,I am trying to create a business rule to get the duration between two fields. I am using below script to get the duration:*******************************************************************stts = current.u_status;if (stts =='Published'){var strt =...

DubeyN by Mega Expert
  • 2909 Views
  • 11 replies
  • 0 helpfuls

Background Script - Duplicate Numbers

I am writing a script (most of which was written for me) to renumber the tickets in our system that have duplicate numbers. I am able to get them to print onscreen, but to get them to actually renumber I need to add currentGlideRecord.update(); in th...

Shirley3476 by Kilo Contributor
  • 3440 Views
  • 2 replies
  • 1 helpfuls

Add sys_user_id to comments (sys_journal_field)

I'm integrating a third party app with ServiceNow and am looking at showing the incident comments, along with a picture of the users which made the comments. The default sys_journal_field has a "created by" field, but this is only a text field (of th...

rajabhadury by Kilo Explorer
  • 2628 Views
  • 5 replies
  • 0 helpfuls

One approval notification for multiple approvals?

I would like to send one approval email for multiple RITM's waiting to be approved. Something that says "You have multiple approvals that need your attention". Is there any way for me to prevent notifications for more than one RITM on one REQ for a c...

LDAP - formatting large integer values

Hi,We currently import users from Active Directory using LDAP. I would like to import the lastlogon attribute which has a large integer value. How can I transform this into a date (and time) field onto the User table? I have created a date time field...

Rish_007 by Kilo Contributor
  • 4164 Views
  • 4 replies
  • 0 helpfuls

Sending email to all users

There are times when I'd like to send email to all or a subset of users on the system to announce a change, a pending upgrade or other message.Is there a way to send an email from my account on Service Now to all users in such a way that I could eith...

Inbound Email - Getting original email address

I am in the process of writing a script for an Inbound Email Action, but I am having an issue. The script is meant to assign incidents to specific groups based on the from address on the inbound email. I'm running into trouble because the email.froma...

lrenninger by Kilo Explorer
  • 6694 Views
  • 6 replies
  • 0 helpfuls

UI action to create child incident

Trying to create something in the UI that will let me create a child incident (one that contains some of the parent's data).Based on some of the posts I've seen here, I did the following: var fieldList = 'sysparm_query=active=true^u_inc_type=2'; fiel...

klassa by Kilo Explorer
  • 6150 Views
  • 6 replies
  • 0 helpfuls