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

Forum Posts

Filter our Knowledge Base articles to only most recent version?

Super simple one (I hope). I'm trying to build a report to see all our KB articles. But the "versions" is creating a lot of clutter. I just want to see the most recent version of every article (published or not published).  Example - if I have an art...

RC2 by Tera Contributor
  • 1560 Views
  • 1 replies
  • 0 helpfuls

Target record is not creating via ETL

I have created a custom table as per the client requirement and mapped those custom table fields in ETL Entity Mappings and trying to create a record over there but it is not happening and no record is getting created.  I have put down logs in the co...

Sagar24_0-1697175966549.png
Sagar24 by Tera Contributor
  • 1185 Views
  • 3 replies
  • 0 helpfuls

Resolved! Auto-Close Incident when Incident Tasks are Closed

I have some Incidents (INC) that contain Incident Tasks (TASK) and would like the Incident to auto-resolve when all Incident Tasks are closed to prevent anyone from having to manually resolve the Incident ticket itself (all actionable items are conta...

find_real_file.png
bvarian by Mega Contributor
  • 11867 Views
  • 15 replies
  • 8 helpfuls

Convert small letter to capital letter

There are two fields last name and name. So when I enter something in last name field. The first letter it needs to be populate in name field.  I used below code:Using onchangeVar name1= g_form.getValue('lastname');Var f1= name1.charAt(0);g_form.setV...

User_267 by Tera Contributor
  • 1172 Views
  • 2 replies
  • 0 helpfuls

Script include for service catalog

Hello Team, Am trying to auto populate user location in service catalog using script include method and client script, when ever am selecting username.  Below is the client script i have written:function onChange(control, oldValue, newValue, isLoadin...

UmeshGowda by Tera Contributor
  • 1448 Views
  • 8 replies
  • 0 helpfuls

Aut flush / cleanup table

Hi guys Are there any recommendation on the number of seconds that you can set on the "Auto Flush" especially for the sys_log tabel? Right now its 90 days - don't even know if that it OOTB. Thanks in advanceSøren

Resolved! Database view for task_sla, sc_task and incident tables

Hello everybody,  I want to create a database view where to see data from the following tables: task_sla, sc_task and incident - as I need to be able to see all task_sla associated with Incidents and Catalog tasks on the same view, together with the ...

AlinaMariaPas_0-1698750254012.png AlinaMariaPas_1-1698750290389.png

Trigger email based on the schedule and conditions

Hi All,I need help with a ServiceNow case, I have the following email scheduling requirements: 1) Schedule emails to be sent every Monday at 10 AM.2) These emails should contain 'URLs to a list of incidents and RITMs records' , probably hard coded be...

Query1 by Tera Contributor
  • 1835 Views
  • 3 replies
  • 0 helpfuls