Notification triggerent by Event and a Scheduled Job to the "manager"

Hello guys! 

I want to trigger notifications via a Scheduled Job that's going to run once every month. It's based on alm_hardware table.

So there managed_by can have several posts of hardware assets under him/her. I want to trigger so that only one mail is sent to the "manager" of the "managed_by" (so managed_by.manager) containing all the assets beloning to the managed_by. 

Here is my current code: 

var gr = new GlideRecord('alm_hardware');
gr.addEncodedQuery('managed_by.active=false^install_status=1');
gr.query();



while (gr.next()) {
var manager = gr.managed_by.manager;
if (manager && manager.active) {
var eventParms = gr.display_name + ';' + gr.managed_by.name;
gs.eventQueue('vgr_inactive_hardware_manager', gr, eventParms, manager.sys_id);
}
}

This code doesn't do what it's intended to do, so it tons of mails, every time there is an asset post under a managed_by. 

I want my notification to look like this: 

Thanks in advance!