[ServiceNow] Create database view and Generate report from it

In the left menu, type Database View.

Create New

Enter a unique Name.

Label is the "table name" of the database view.

In section view tables, click New to add tables.

Variable Prefix is a string that will be prefixed to all field names of the table.

i.e. Variable Prefix of "Incident" is "inc", thus the field name of sys_id of incident in this view will become "inc_sys_id".

In left menu, Reports > Create New

In Table, select the view we created > Run

[ServiceNow] > [Widget] Passing parameters from client side to server side

In html template, there is a text field and its name is "data.num".

When c.server.update() is called, the value of "data.num" will be passed to server side.

In server side script, call "input.num" can get the value of "data.num".

---

Client Script

1. Everything from the server’s data object can be accessed via c.data or $scope.data.
2. If you change a value in the data model, use server.update() to post the entire data object to the server script as input.
   Note: After calling server.update() the client script’s data object is automatically overwritten with the server’s data object.
3. Use c.options or scope.options to see what values were used to invoke the widget. This object is read-only and making changes will not be visible in the server script.

Note: Only client scripts set with the UI type as Both or Mobile run in Service Portal.

Server Script

1. An empty data object is initialized.
2. Use the input or options objects to get any data that was sent from the client controller or used to initialize the widget from the server.
3. After the server script executes, the data object is json serialized and sent to the client controller.

---

html template

<div>
<!-- your widget template -->
 
<input type="text" ng-model="c.data.num"
   ng-change="c.update()"
ng-model-options="{debounce: 250}"
       />{{c.data.num}}<br><br>
 
<li class="list-group-item" ng-repeat="item in c.data.items">
    <a href="javascript:void(0)">{{item.name}}</a><span class="pull-right">{{item.price}}</span>
</li>
</div>

client script

function() {
 var c = this;
 c.update = function() {

        c.server.update().then(function(r) {           
            alert(r.a); // return from server script
        });
    };
}

server script

(function() {
 data.items = [];
 var a = input.num;
 if(!a)
 {
  a = 1;
 }
 data.a = a;
 for( var i =0;i<a;i++)
 {
  data.items.push({name:'name '+i,price:i});
 }
})();

Excel VBA Write text file

Sub a()
   
    Dim fso As Object
    Set fso = CreateObject("Scripting.FileSystemObject")
    Dim oFile As Object
    Set oFile = fso.CreateTextFile("d:\a.txt")
    oFile.WriteLine "test"
    oFile.Close
    Set fso = Nothing
    Set oFile = Nothing

End Sub

[ServiceNow] Email Notification using template

Create email scripts (optional)

System notifications > Email > Notification Email Scripts

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
          /* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
          /* Optional GlideRecord */ event) {

template.print( gs.getMessage('sakatsuku is interesting') );

// add req item vars to email content
var item = new GlideRecord("sc_req_item");
item.addQuery("request", current.sys_id);
item.query();
while(item.next())
{
var catalogItem = item.number + ': ' + item.cat_item.getDisplayValue();
var misc = item.variable_pool.alt_poc;
template.print(catalogItem + "<br/> Field: " + misc);
}

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

Build a template

System policy > Email > Templates

Name: xxx
Subject: xxxx
Table: choose a table
Message HTML:
${mail_script: your_email_script}

Create a notification

System notifications > Email > Notifications

In tab "What It Will Contain", choose a email template.

[ServiceNow] Redirect to Service Portal after login

Redirect to Service Portal after login

Use system properties and script includes to conditionally redirect users to a page after logging in.

Follow these steps to redirect a user to Service Portal after they log in.

1. In the sys_properties table, add the following property:

   Property	Type	Value	Description
   glide.entry.first.page.script	string	new SPEntryPage().getFirstPageURL()	First page after authentication

[ServiceNow] Force send an email

Method 1 By Server Side script

When creating business rule / scheduled job using this script, make sure the current scope is Global.

var emailNotification = new GlideRecord('sys_email');
emailNotification.initialize();
emailNotification.type = 'send-ready';
emailNotification.notification_type = 'SMTP';
emailNotification.subject = 'Email subject';
emailNotification.body = 'Email body';
emailNotification.recipients = email-address1 + ',' + email-address2;
var sys_id = emailNotification.insert();

Method 2 - Business Rule Before

It seems only "Before" business rule can read the variables on the request form.

Assign the email in the form to a dummy user then send email notification to that user.

(function executeRule(current, previous /*null when async*/) {

var tmpUser = new GlideRecord('sys_user');
tmpUser.get('0a826bf03710200044e0bfc8bcbe5d7a');
if( tmpUser )
{
gs.info('br_catalog_item_before email '+current.variables.email);
gs.info('br_catalog_item_before remark '+current.variables.remark);
// adela.cervantsz@example.com
tmpUser.email = current.variables.email;
tmpUser.update();

gs.eventQueue('x_122591_marketing.yhy_send_email', current, tmpUser, gs.getUserName());
}
else
{
gs.info('br_catalog_item_before nf');
}

})(current, previous);

[ServiceNow] Print All Variables and values of a requested item

gs.info('Print Request Item Var start'); var item = new GlideRecord("sc_req_item"); item.addQuery("sys_id", '0c7906b5db5003009bdb5740cf961978'); item.query(); if (item.next()) { gs.info('Print Request Item Var '+item.sys_id); // grab all variable sets from the parent request var var_own = new GlideRecord('sc_item_option_mtom'); var_own.addQuery('request_item', item.sys_id); //var_own.addQuery('sc_item_option.item_option_new.u_approval_display', 'global'); var_own.orderBy('sc_item_option.item_option_new.order'); var_own.query(); if (var_own.next()) { gs.info(var_own.sc_item_option.item_option_new.question_text + ": " + eval('item.variable_pool.'+var_own.sc_item_option.item_option_new.name+'.getDisplayValue()') + "\n" ); } }