How can I query sys_email table in Scripts - Background

[irenechen]

Hi,

I need to extract some information from sys_email table while I am doing the production issue investigation, but when I run below scripts in the "scripts - background" tool, there's no data list out.

gs.sql("select distinct recipients from sys_email where sys_created_on= '2015-08-22' and subject like 'BCM Governance Declined%'");

Thanks in advance for your help!

Irene

[irenechen]

Hi Berny,

Do you have a script to print out the top 10 sys_id? so it won't consuming

too many resource while the script query the big table.

Thanks,

Irene

[irenechen]

Hi Berny,

I ran below script in the script background,

gs.sql("select count(*) from sys_email");

the return as below:

06 Script completed: script

count(*)

0

Thanks,

Irene

[bernyalvarado]

Hi Irene, I should also have mentioned that from the list view you can always export to excel, csv and pdf.

You just need to right click on the list menu item and the export option will be in there.

Thanks,

Berny