Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

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

Forum Posts

Adding custom field to CMDB

What is the best practice to add a field to the CMDB? Situation:  I've been asked to add a column (probably to the ci_hardware table) with the local name of the vlan the IP address assigned to the device resides in to facilitate reporting based on vl...

Jack8 by Giga Contributor
  • 2330 Views
  • 1 replies
  • 0 helpfuls

Resolved! How to get the record count in the while loop?

Hello, I am trying to get the count of all record that matches the query condition. When I use the below script, the count is always being '1' even though there are 1+ records that matches the condition. I am I missing anything? Please suggest. var c...

Rick54 by Tera Expert
  • 5366 Views
  • 35 replies
  • 0 helpfuls

Resolved! Location search in Service portal

Hello All,   In portal there is variable called Location [Reference]...... IF i search [ *can ] in locations it's showing all related to that as below but if i simply type can without  [ * ]  it's showing only one ...but for us it's display all rela...

find_real_file.png find_real_file.png
ar1 by Kilo Sage
  • 3413 Views
  • 5 replies
  • 1 helpfuls

Resolved! How is this Scheduled Job Condition code working correctly?

I encountered some code written by another person in a "Condition" in a Scheduled Job.  This Condition prevents the scheduled job from running on Sundays as expected.  However, I don't understand why it works.  The value of answer is only ever set on...

davidc1 by Kilo Contributor
  • 4943 Views
  • 3 replies
  • 5 helpfuls

Resolved! Unsubscribe email notifications

You might have seen an email footer which contains something like ''Unsubscribe". When a user clicks on it, it generates an email from outlook with some message content. Same as it described in the below link;  https://docs.servicenow.com/bundle/jaka...

Geeky by Kilo Guru
  • 6338 Views
  • 6 replies
  • 13 helpfuls

Coalesce in transform but update multiple records

Hi Community, I have a data source that includes all of the 'titles' of the software installation table records. I need to use that datasource to flag \software installations. Target table is cmdb_sam_sw_install I have the transform script and map so...

johnfw by Kilo Expert
  • 1423 Views
  • 4 replies
  • 0 helpfuls

Resolved! Set "portal login page" as default instead of instance login page

Hi all. Guys its very critical , I got one requirement today login page for all users should be the portal landing page only. This is my instance url  https://strnewdevtemp.service-now.com whenever user hits this url they should be redirected to ser...

Sin by Giga Expert
  • 4827 Views
  • 2 replies
  • 6 helpfuls

Help! M2M Relationship Removal

I've been looking and I can't find any information on how to remove a Many to Many relationship table as created by the sys_m2m table.I created M2M relationships from a table to Change Request then realized I could have used Task which would allow me...

Shane11 by Mega Expert
  • 2615 Views
  • 4 replies
  • 4 helpfuls

Resolved! Custom table - variable formatter - changes not saved

Attempting a new thread for this question. We needed to extend the sc_req_item table, which is done and most everything is working as needed. However, we're having issues with the variables not saving changes. The formatter is set up properly and sho...

Resolved! How do I retrieve results for survey based on assignment group?

Good Morning, I am trying to create a report that will give me survey results for an assignment group also down to user level.  I am not sure how to view this information.  I am currently using the Metric table but it only shows assigned to for the s...