Scheduling a report with inline table instead of the attachments

 

Scheduling a report with inline table instead of the attachments


Introduction:

I have received a one business requirement, that we can add the inline report (table) instead of the excel attachments. For this I searched and started working on it, so I had few issues while working on this requirement. Hence, I have started to write this article. I think it will help community users to work on this type of requirement in future.

Create a scheduled report which will trigger based on conditions and it will include the inline table as per business need.

Use case’s:

  1. Create a scheduled report which will trigger based on some conditions and have inline report in mail

  2. Create a scheduled report with an inline table to send the assigned to users and his/her managers for pending approval of requests.



Procedure:

Create a report and schedule it as per the required time.

Example- Create a report for example- List of CRs for CAB Meeting.


Scheduled the same report as per business need.


Create a Notification email script to add report contents(records) into inline table instead of the attachments.








Here is the script: Step 5:


It will add the inline table in dynamically.

A screenshot of a computer Description automatically generated

Execute a scheduled report & check the mail logs.

Received email:


Conclusion:

I this way, we can add inline table instead of the attachments in scheduled report.























(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,

  /* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,

  /* Optional GlideRecord */ event) {


changeRequest();


function changeRequest(){


var chg = new GlideRecord(current.report.table);

chg.addEncodedQuery(current.report.filter);

chg.query();


if (chg.hasNext()) {

template.print('<br />');

template.print('<table style="height: 23px;" width="100%"><tbody><tr><td style="background-color: #0e5399;"><font color="#FFFFFF"><strong>Blackout Window - ECR\'s Approved by Praveen & Anoop</strong></font></td></tr></tbody></table>');

var tbl = '<table style="height: 293px;" width="100%"><tbody>';

//template.print(tbl);


var tab = '<table style="width: 100%; border-collapse : collapse; " border = "2" cellpadding = "10"> <tbody>' + '<tr>' +


'<td style="background-color: #aeaeae;">' + '<b>Number</b>'  + '</td>' +

'<td style="background-color: #aeaeae;">' + '<b>Opened</b>'  + '</td>' +



'<td style="background-color: #aeaeae;">' + '<b>Name</b>'    + '</td>' + 

'<td style="background-color: #aeaeae;">' + '<b>Category</b>' + '</td>' + 


'<td style="background-color: #aeaeae;">' + '<b>Description</b>'   + '</td>' + 

'<td style="background-color: #aeaeae;">' + '<b>Requested by</b>'   + '</td>' + 




'<td style="background-color: #aeaeae;">' + '<b>Configuration item</b>'   + '</td>' + 


'<td style="background-color: #aeaeae;">' + '<b>Assignment group</b>'   + '</td>' + 

'<td style="background-color: #aeaeae;">' + '<b>Assigned to</b>'   + '</td>' + 



// '<td style="background-color: #aeaeae;">' + '<b>Business Impact</b>'   + '</td>' + 


// '<td style="background-color: #aeaeae;">' + '<b>Reason</b>'   + '</td>' + 

// '<td style="background-color: #aeaeae;">' + '<b>Business Impact</b>'   + '</td>' + 


// '<td style="background-color: #aeaeae;">' + '<b>Root Cause</b>'   + '</td>' + 

// '<td style="background-color: #aeaeae;">' + '<b>Fix Required</b>'   + '</td>' + 


// '<td style="background-color: #aeaeae;">' + '<b>Change Scope</b>'   + '</td>' + 


// '<td style="background-color: #aeaeae;">' + '<b>State</b>'   + '</td>' +

// '<td style="background-color: #aeaeae;">' + '<b>Active</b>'   + '</td>' + 

// '<td style="background-color: #aeaeae;">' + '<b>Updated</b>'   + '</td>' + 

// '<td style="background-color: #aeaeae;">' + '<b>Updated by</b>'   + '</td>' + 

// '<td style="background-color: #aeaeae;">' + '<b>Reason</b>'   + '</td>' + 

// '<td style="background-color: #aeaeae;">' + '<b>CCB date</b>'   + '</td>' + 

// '<td style="background-color: #aeaeae;">' + '<b>Type</b>'   + '</td>' + 

// '<td style="background-color: #aeaeae;">' + '<b>Conflict status</b>'   + '</td>' + 


'</tr>';

template.print(tab);

}


while(chg.next())

{   


var clsed = '<tr>' + 

'<td>' + chg.number + '</td>' +

'<td>' + chg.opened_at + '</td>' +  


'<td>' + chg.short_description + '</td>' + 

'<td>' + chg.category + '</td>' +


'<td>' + chg.description + '</td>' +

'<td>' + chg.requested_by.name + '</td>' +

'<td>' + chg.cmdb_ci.name + '</td>' +  


'<td>' + chg.assignment_group.name + '</td>' +  

'<td>' + chg.assigned_to.name + '</td>' +


// '<td>' + chg.u_business_impact + '</td>' +

// '<td>' + chg.u_root_cause + '</td>' +  

// '<td>' + chg.u_fix_required + '</td>' +

// '<td>' + chg.u_change_scope + '</td>' + 


// '<td>' + chg.conflict_status + '</td>' +  

// '<td>' + chg.type + '</td>' + 

// '<td>' + chg.cmdb_ci + '</td>' +

// '<td>' + chg.reason + '</td>' + 

// '<td>' + chg.state + '</td>' +

// '<td>' + chg.active + '</td>' +

// '<td>' + chg.sys_updated_on + '</td>' +  

// '<td>' + chg.sys_updated_by + '</td>' +


'</tr>';

template.print(clsed);

}


var tab_end = '</tbody> </table>';

template.print(tab_end);


}


})(current, template, email, email_action, event);

Comments

Post a Comment

Popular posts from this blog

Script Action and Example

Script Actions The Script actions feature allows to create server side scripts that can run on server side and perform multiple tasks asynchronously. It will run or execute after the event has triggered in the system scheduler. For example: modifying records,    A script action can only be triggered by an event using gs.eventQueue() method.  Script actions are maintained in the System Policy —> Script Actions [sysevent_script_action] table in ServiceNow.   Available Fields For Script actions we have these fields. Name: Add a unique name for a script action. Generally to maintain script actions we should maintain the naming conventions.  Example: Let's take example, we have to create a script action for Close incidents/Problems when Change request gets closed, so name will be Incident-Probelm Closure Application: The application that contains this script. Example: Global or scoped applica...
Read more

#BuildWithCreatorStudio Challenge

Image
  🚀 Excited to share that I've completed the #BuildWithCreatorStudio challenge! 🚀 Using ServiceNow Creator Studio, I built a streamlined Employee Relocation process for India. Here’s a quick look at the automated steps I created: Request Submission: Employees can easily submit their relocation requests, listing the details needed. Manager Approval: The request goes to the employee’s manager for review. They can approve or reject based on the information provided. TCBP Team Validation: Once approved by the manager, the TCBP team reviews and validates the request details. Notification: After final validation, the TCBP team approves the request and notifies the employee of next steps. This simple workflow ensures all requests are reviewed thoroughly by both the manager and TCBP team. Thanks to Creator Studio’s easy, no-code interface, I built this application in under an hour—way faster than I expected! Want to create something yourself? Check out the #BuildWithCreatorStudio chall...
Read more

System Properties & it's Usage in ServiceNow

Image
  System Properties System properties used to store configuration information that rarely or never changes. We can add or update to control the system behavior. It is best practice to use a system property instead of hard cladding the fixed values.System properties store configuration information that rarely or never changes. System properties are maintained in the System properties [sys_properties] table in ServiceNow.   Available Fields For System property we have these fields. Name: Add a unique name for a system property. Generally to add or maintain system property we should maintain the naming conventions. Example: Let's take example, we have to create a property for Team Development Code Reviewers assignment group, so name will be team.development.code.reviewers   Description: Type a brief description for the property. What is the purpose/function and where will it be used? Type: We have multiple data types for a property. For example- Integer, String, Choic...
Read more