how to get the data from sysevent table to my custom table.

[Suresh_32]

We want get data (insert/update records) from Event(sysevent) table to my custom table.

Created BR on table is 'sysevent' and after insert/update BR.

 var oldRecord = new GlideRecord("sysevent");

 oldRecord.addQuery('nameLIKElogin^ORnameLIKElogout'); // only we want login and Logout records from event table.

 oldRecord.query();

 while(oldRecord.next())

    var newRecord = new GlideRecord("u_newtable"); //my custom table

    newRecord.initialize();

    newRecord.u_created = current.sys_created_on;

    newRecord.u_name = current.name;

    newRecord.u_parm1 = current.parm1;

    newRecord.insert();

//    newRecord.update();

[Ramesh_Naidu]

Hi @Suresh_32 ,

You can write a Async business rule, as there will be many records that will be created on the events table. I have attached sample example for reference.

Thankyou.

[Suresh KSB]

Hi @Ramesh_Naidu ,

Thank you for reply, updated my business rule but records are not inserted in my custom table.

[Ramesh_Naidu]

Hi @Suresh KSB ,

Have you tried running the same code from the background script? It might be a cross-scope issue.

Thankyou,

Ramesh

[Suresh_32]

Hi Ramesh,

Yes Background script is working fine, how to resolve the cross-scope issue.

var oldRecord = new GlideRecord("sysevent");

oldRecord.addQuery('nameLIKElogin^ORnameLIKElogout');

//nameLIKElogin

oldRecord.query();

while(oldRecord.next())

{

    var newRecord = new GlideRecord("u_newtable");

    newRecord.initialize();

    newRecord.u_created = oldRecord.sys_created_on;

    newRecord.u_name = oldRecord.name;

    newRecord.u_parm1 = oldRecord.parm1;

    newRecord.insert();

}