Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to show only log in backgroudn script?

BoHyun Jung
Mega Sage

My Background Script

var query = 'sys_class_name=rm_story^assigned_to=3c6bad6a8746611085020f65dabb35c8^state!=-6^ORstate=NULL^ORDERBYsys_created_on';
var story = new GlideRecord('rm_story');
story.addEncodedQuery(query);
story.query();

while(story.next()){
    var sd = story.short_description.toString();
    gs.log(sd);
}

 

Script completed in scope global: script

Time: 0:00:00.112 id: doosandigitalinnovationdemo01_1[glide.7] (connpid=29481) for: UPDATE sys_number_counter SET `number` = 2568 WHERE sys_number_counter.`sys_id` = '19a9e87e8734211085020f65dabb356a' AND (sys_number_counter.`number` = 2567 OR sys_number_counter.`number` IS NULL ) /* doosandigitalinnovationdemo01002, gs:AE8849048766E51085020F65DABB35DF, tx:7bcc3e00876ee51085020f65dabb3535 */ 
Time: 0:00:00.165 id: doosandigitalinnovationdemo01_1[glide.28] (connpid=29502) for: INSERT INTO sys_rollback_context (`sys_mod_count`,`active`,`sys_updated_on`,`to_version`,`type`,`number`,`sys_id`,`sys_updated_by`,`sys_created_on`,`state`,`from_version`,`user`,`sys_created_by`) VALUES(0,1,'2023-04-27 08:27:16','sys.scripts: jung96 (2023-04-27 08:27:16)','scripts_bg','BAK0002568','bbcc7e40876ee51085020f65dabb35d4','jung96','2023-04-27 08:27:16','staged','sys.scripts: jung96 (2023-04-27 08:27:16)','3c6bad6a8746611085020f65dabb35c8','jung96') /* doosandigitalinnovationdemo01002, gs:AE8849048766E51085020F65DABB35DF, tx:7bcc3e00876ee51085020f65dabb3535 */ 
Time: 0:00:00.125 id: doosandigitalinnovationdemo01_1[glide.31] (connpid=29505) for: INSERT INTO sys_delete_recovery (`sys_id`,`sys_updated_by`,`rollback_context`,`initiating_transaction`,`sys_created_on`,`sys_mod_count`,`sys_updated_on`,`stack_trace`,`state`,`sys_created_by`) VALUES('bfcc7e40876ee51085020f65dabb35d4','jung96','bbcc7e40876ee51085020f65dabb35d4','7bcc3e00876ee51085020f65dabb3535','2023-04-27 08:27:16',0,'2023-04-27 08:27:16','	java.base/java.lang.Thread.getStackTrace(Thread.java:1602)
	com.glide.db.recovery.DeleteRecovery.start(DeleteRecovery.java:88)
	com.glide.db.recovery.DeleteRecoveryManager.startOrResumeDeleteRecovery(DeleteRecoveryManager.java:162)
	com.glide.db.recovery.DeleteRecoveryManager.createAndSetCurrent(DeleteRecoveryManager.java:100)
	com.glide.processors.SysScriptsExecution.start(SysScriptsExecution.java:48)
	com.glide.processors.ScriptProcessor.evaluateScript(ScriptProcessor.java:361)
	com.glide.processors.ScriptProcessor.runScript(ScriptProcessor.java:261)
	com.glide.processors.ScriptProcessor.process(ScriptProcessor.java:219)
	com.glide.processors.AProcessor.runProcessor(AProcessor.java:625)
	com.glide.processors.AProcessor.processTransaction(AProcessor.java:277)
	com.glide.processors.ProcessorRegistry.process0(ProcessorRegistry.java:184)
	com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:172)
	com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:51)
	com.glide.sys.Transaction.run(Transaction.java:2501)
	com.glide.ui.HTTPTransaction.run(HTTPTransaction.java:27)
	java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	java.base/java.lang.Thread.run(Thread.java:829)
','started','jung96') /* doosandigitalinnovationdemo01002, gs:AE8849048766E51085020F65DABB35DF, tx:7bcc3e00876ee51085020f65dabb3535 */ 
Time: 0:00:00.204 id: doosandigitalinnovationdemo01_1[glide.13] (connpid=29487) for: INSERT INTO sys_script_execution_history (`sys_id`,`executed_by`,`sys_updated_by`,`rollback_context`,`sys_created_on`,`sys_mod_count`,`started`,`sys_updated_on`,`script`,`transaction`,`sys_created_by`) VALUES('33cc7e40876ee51085020f65dabb35d5','3c6bad6a8746611085020f65dabb35c8','jung96','bbcc7e40876ee51085020f65dabb35d4','2023-04-27 08:27:16',0,'2023-04-27 08:27:16','2023-04-27 08:27:16','var query = ''sys_class_name=rm_story^assigned_to=3c6bad6a8746611085020f65dabb35c8^state!=-6^ORstate=NULL^ORDERBYsys_created_on'';
var story = new GlideRecord(''rm_story'');
story.addEncodedQuery(query);
story.query();

while(story.next()){
    var sd = story.short_description.toString();
    gs.log(sd);
}','7bcc3e00876ee51085020f65dabb3535','jung96') /* doosandigitalinnovationdemo01002, gs:AE8849048766E51085020F65DABB35DF, tx:7bcc3e00876ee51085020f65dabb3535 */ 
*** Script: [Catalog Item]구매/자재
*** Script: [Catalog Item]영업/견적/사업/서비스
*** Script: [Catalog Item]시공
*** Script: [Catalog Item]경영/투자/Risk&OE
*** Script: [Catalog Item]재무
*** Script: [Catalog Item]RPA
*** Script: [Catalog Item]Dootops, PRPMS, IFC 및 기타
*** Script: [Catalog Item]DIVE
*** Script: [Catalog Item]HPC
*** Script: [Catalog Item]R&D
*** Script: [Catalog Item]RMS
*** Script: [Catalog Item]SmartPlant 제품군
*** Script: [Catalog Item]관리/EHS/환경/에너지/기타
*** Script: [Catalog Item]문서 (DDMS, EIM) / 사인관리시스템 (DSMS)
*** Script: [Catalog Item]생산
*** Script: [Catalog Item]설계 ERP/BOM관리시스템
*** Script: [Catalog Item]설계 PLM
*** Script: [Catalog Item]설계 S/W
*** Script: [Catalog Item]주단
*** Script: [Catalog Item]통합설계환경(DIDS)
*** Script: [Catalog Item]품질
*** Script: [Catalog Item]풍력 MES+O&M
*** Script: [Catalog Item]SAP S/4HANA(DIV)
*** Script: [Catalog Item]DLP 예외 (개인정보 대량 발송, FTP 사용 등)
*** Script: [Catalog Item]DB보안 및 보안메일/OTP
*** Script: [Catalog Item]SAP ECC(Bobcat)
*** Script: [Catalog Item]ePDM
*** Script: [Catalog Item]DM (DIV&Bobcat)
Time: 0:00:00.199 id: doosandigitalinnovationdemo01_1[glide.3] (connpid=29477) for: EXECUTE BATCH OF 1 STATEMENTS
Batch Statement: 1 of 1 id: doosandigitalinnovationdemo01_1[glide.3] (connpid=29477) for: INSERT INTO sys_rollback_incremental (`context`, `operation`, `table_name`, `storage_table_name`, `element_name`, `storage_alias`, `document_id`, `txn_id`, `oldvalue`, `newvalue`, `row_mod_count`, `when`) SELECT 'bbcc7e40876ee51085020f65dabb35d4', 'UPDATE', 'sys_script_execution_history', 'sys_script_execution_history', 'rollback_context', 'rollback_context', `sys_id`, 'ccdc7e40a46ee51067c6b8e08f7568d9', `rollback_context`, NULL, `sys_mod_count`, utc_timestamp()  FROM sys_script_execution_history  WHERE sys_script_execution_history.`sys_id` = '33cc7e40876ee51085020f65dabb35d5' AND `rollback_context` IS NOT NULL  /* doosandigitalinnovationdemo01002, gs:AE8849048766E51085020F65DABB35DF, tx:7bcc3e00876ee51085020f65dabb3535 */ 
Time: 0:00:00.334 id: doosandigitalinnovationdemo01_1[glide.3] (connpid=29477) for: COMMIT
[0:00:00.550] Statement batcher: 1

 

I want to see only '*** Script: ' part...

1 ACCEPTED SOLUTION

@BoHyun Jung 

can you try this script?

var query = 'assigned_to=3c6bad6a8746611085020f65dabb35c8^state!=-6^ORstate=NULL^ORDERBYsys_created_on';
var story = new GlideRecord('rm_story');
story.addEncodedQuery(query);
story.query();
while(story.next()){
	var sd = story.short_description.toString();
	gs.info(sd);
}
Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

@BoHyun Jung 

Is the similar log showing every time you run the background script?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

BoHyun Jung
Mega Sage

It keeps happening😂

@BoHyun Jung 

can you try this script?

var query = 'assigned_to=3c6bad6a8746611085020f65dabb35c8^state!=-6^ORstate=NULL^ORDERBYsys_created_on';
var story = new GlideRecord('rm_story');
story.addEncodedQuery(query);
story.query();
while(story.next()){
	var sd = story.short_description.toString();
	gs.info(sd);
}
Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Aniket Narode2
Tera Contributor

Hello,
Just try to use gs.print(logmsg);

 

Mark is helpful if it help you.

Thank

Aniket