Hi,
I have written the below script in scheduled jobs to export the the list of ritm created and approved data. Can you help me to write the script for the above mentioned conditions.
Script:

var grApprover = new GlideRecord('sysapproval_approver');

grApprover.addQuery('state', 'approved');

grApprover.query();

// if (!grApprover.hasNext()) {

//     gs.log("No approved approval records found.");

//     return;

// }

// CSV Header

var csvContent = "Approval Number,Approver,Approval State,Approval Date,Sysapproval\n";

while (grApprover.next()) {

    csvContent += grApprover.getValue('sys_id') + "," +

        grApprover.getDisplayValue('approver') + "," +

        grApprover.getValue('state') + "," +

        grApprover.getValue('sys_created_on') + "," +

        grApprover.getDisplayValue('sysapproval') + "\n";

}

// Save as an attachment

var fileName = "Approved_Approvals_" + gs.nowDateTime() + ".csv";

var tableName = new GlideRecord("sys_attachment");

tableName.initialize();// Attach to sys_attachment

var recordSysId = gs.generateGUID(); // Generates a unique record ID

var attachment = new GlideSysAttachment();

attachment.write(tableName,fileName, "text/csv", csvContent);

gs.log("Exported Approved Approvals and saved as an attachment: " + fileName);

Thanks & regards,
Nageshwari P.