Bulk data insert from one table to custom table

[Rajesh101]

Hi Team.

I have requirements where I need to pull records of last day data from kb_use table (Filter data) and insert into custom created table.

At high level requirment is to capture self solved articles read by user's , I am aware of OOB metric table but that doesn't support our requirment to build report and create breakdowns.
Could any one suggest me best possible methods to pull and insert data into custom table.

Highly appreciated if any one could suggest. 

Rajesh 

[Saurabh Gupta]

Hi,
Is this a one time activity?

[Venkatesh_N]

Hi @Rajesh101 ,

My approach will be like :
Write a Schedule job that runs dialy morning to retrieve last day data from the kb_use table.
Using GlideRecord, add appropriate query conditions to retrieve and then insert those records into your custom table using another GlideRecord in the code.

Thanks,
Venkatesh Nekkanti