- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 01:36 AM
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...
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 02:05 AM
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);
}
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 01:53 AM
Is the similar log showing every time you run the background script?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 01:57 AM
It keeps happening😂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 02:05 AM
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);
}
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 02:16 AM
Hello,
Just try to use gs.print(logmsg);
Mark is helpful if it help you.
Thank
Aniket