How to refresh Drop down list of values based on other 'Select Box' Value in Service Catalog

Use case: Based on 'First' Select Box selected value, Refresh the Second 'Select Box' values  for a Service Catalog item in Service Now

Solution

- Create a new 'Catalog Client Script'

-  Applies to 'Service Catalog Item'

- Type - 'onChange'

- Catalog Item - Select the appropriate catalog item, for which you want to implement this functionality

- Varaiable Name - 'Select appropriate variable' In this example, First 'Select Box' variable name

-  Write the script as below

g_form.clearOptions('state');

var cat = g_form.getValue('country');

if(cat == "usa"){
g_form.addOption('state','WI','Wisconsin');
g_form.addOption('state','TX','Texas');
}
if(cat == "india"){
g_form.addOption('state','AP','Andhrapradesh');
g_form.addOption('state','TG','Telangana');
}

How to Upload a file using Macro in Service Now?

This blog explains about how to implement 'Upload File' feature using Macro in Service Catalog in Service Now

Use case - Provide the ability to upload a file in Service Catalog Item

Solution

- UI Macros
- Create New, Add the Jelly script code as shown below

<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
<b>Use the paperclip</b>  
<a onclick="saveCatAttachment(gel('sysparm_item_guid').value, 'sc_cart_item')">  
<img title="Attachments..." height="16" src="images/icons/attachment.gifx" border="0" width="16"/></a>  
<b>to attach items to this request.</b>  
</j:jelly>

-  Go to Service Catalog Item, where you want to implement this feature
- Create a new variable of a type 'Macro with Label'
- Goto 'Type Specifications' tab and Choose the Macro newly created in above step
- This how it shows

How to see all the changes performed by specific user in Service Now ?

This blog explains about how to see, what are all the activities performed in any Service Now Instance by specific user ?

Use Case : I wanted to see what are all the activities performed by 'Ravi' in 'Development Service Now Instance' ?

Solution

- System Logs -> Transactions
- You can filter by user name

How to retrieve Specific User associated Manager, Director , Title, Department related information in Service Now?

Scenario : Get a specific user associated attributes such as Manager, Job title, Department, etc..

Solution


- Create a Catalog Client script
- 'Applies to ' 'Variable Set'
- Select the appropriate variable set name
- Select the apprpriate variable name
- Use below script


function onChange(control, oldValue, newValue, isLoading) {
var userValue1 = g_form.getReference('variables.cat_requested_for');
// Get Manager
var managerVar = userValue1.manager;

// Get Job title
var managerVar = userValue1.title;

// Get Department
var managerVar = userValue1.department;

}

How to make 'Service Catalog Shopping Cart Window' scroll-able in Service Now

This blog explains about how can we make 'Service Catalog Shopping Cart Window' Scrollable in Service Now

Scenario: Let's say, My Catalog Item has 500 variables when I scroll down to bottom of the page, I wanted to have 'Shopping cart window' also should be scrollable along with scroll bar

Solution:

- Create the following Catalog client script


function onLoad() {
   //Type appropriate comment here, and begin script below
   
 !function(t){t.fn.jScroll=function(n){function o(t){this.min=t.offset().top,this.originalMargin=parseInt(t.css("margin-top"),10)||0,this.getMargin=function(n){var o=t.parent().height()-t.outerHeight(),r=this.originalMargin;return n.scrollTop()>=this.min&&(r=r+i.top+n.scrollTop()-this.min),r>o&&(r=o),{marginTop:r+"px"}}}var i=t.extend({},t.fn.jScroll.defaults,n);return this.each(function(){var n=t(this),r=window;t("div.cms_layout_container",window.parent.document).length>0&&(r=window.parent);var e=t(r);t("div.touch_scroll").length>0&&(e=t("div.touch_scroll"));var s=new o(n);e.scroll(function(){n.stop().animate(s.getMargin(e),i.speed)})})},t.fn.jScroll.defaults={speed:"slow",top:10}}(jQuery),$j("#sc_cart_contents").jScroll({top:20,speed:1500});
}

How can we align or split variables in a Catalog Item ?

This blog explains about how to arrange variables in a Service Catalog Item ?

Scenario : Let's say, there are 500 variables in a Catalog Item, Out of box, all these variables displayed in single column, If you want to arrange these variables in three columns

Solution

- Create 'Container Start' , 'Contanier Split' , 'Container End' variables wherever required in 'Variables' section in a given Catalog

How to Reduce a Catalog Item Variable width in Service Now ?

This blog explains about how can we manage the height/ width of any variable defined in Servie Catalog Items

- Look for 'Catalog client Script'  , Click on New
- Select the appropriate value for 'Applies to' , If it is 'Variable Set' or 'Catalog Item'
- Follow the below script

How to Use Client Script in Service Now ?

Client scripts are shipped to the client (the browser) and run there instead of on the server. Users who know JavaScript can define scripts to run in the client browser. Several types of scripts are supported

Requirement : Whenever any drop down list value changed, Populate the selected value of Drop down list value into another field

Eg : Whenever 'Device type' value modified, display the selected 'Device type' value in 'Name' field

Solution 
Create a client script as shown below screenshot

     var deviceType = g_form.getValue('device_type');
     var deviceTypeLabel=g_form.getOption('device_type',deviceType).text;
     g_form.setValue('name',deviceTypeLabel);

For More Info , Refer http://wiki.servicenow.com/index.php?title=Client_Scripts#gsc.tab=0

How to migrate Update Sets from One Instance to Other Instance in Service Now?

What is Update Set ?

An update set is a group of customizations that can be moved from one instance to another. For example, a set of enhancements to incident management can be grouped in an update set called Incident Management 2.0. While Incident Management 2.0 is marked as the current update set, all changes are tracked in it.

How to migrate Update Sets from One instance to other instance?

Approach 1

- Search for 'Local Update Sets'

- Click on 'New', Enter all the required info , click on 'Submit and Make Current'

- Make all the changes

- If you happen to switch to different update set and make some other changes on other update set, you can always switch to different update set by clicking on 'Gear' symbol on top right hand corner of your service now instance

                  - Click on 'Developer'
                  - Choose the 'Update Set' which you want to switch

 - Once all your changes done on your Update Set, You have to move this to other Service Now Instance (Target instance )

- Click on your Update Set from 'Local Update Set' module
- Modify the state to 'Completed'

- Click on 'Export to XML' and save to your preferred Location

- Login to Target Service Now Instance where you want to copy Update Set transactions

- Click on 'Retrieved Update Sets'

-  Click on 'Import Update Set from XML' link on bottom of all 'Retrieved Update Set' results.

- Select the 'Update Set XML' which you have stored on your preferred location and click on 'Upload'

- Click on your Update Set from 'Retrieved Update Sets' after completing above step, then click on 'Run Preview' button, verify all the errors and after resolving any errors found, click on 'Update and Commit'

- This will copy all your customizations in update set to Target Service Now Instance

Approach 2

- Go to Source Service Now Instance

- Click on 'Update Sources' module

- Select the Target Service Now Instance , If you can't find, then create

- click on 'Retrieve Completed Update Set's

- This will transfer all the 'completed' update sets into target instance.

How to retrieve Requester associated Director email in Service Now ?

This blog explains about how to retrieve any requester associated director email Address.

Scenario : Need to assign a specific request to requester associated director for approval

- Below method recursively calls until it finds the 'Director' role for a specific user

var answer=[];  

answer.push(findDirector(current.variables.u_requester.toString()));  //pass the sys_id of user 

function findDirector(id){  

var gr= new GlideRecord("sys_user");  

gr.get(id);  

if(gr.title.indexOf("Director")>-1){    

return gr.getValue('sys_id');  

}  

else{  

return findDirector(gr.getValue("manager"));  

}  

}  

How to test script using Background Script feature in Service Now

This blog explain about most commonly and most used technique to test any script in Service Now.

It is very common to verify any script before we implement, Service Now provides a feature called 'Background Scripts' through which you can verify any script

- Choose 'Elevate Roles' by clicking on drop down list side by your name on top right hand side.
- Select 'security_admin' check box
- Click on 'Ok'
- Search for 'Background' on applications list
- Write your own script and test accordingly as shown in below screenshot

Service Now & Microsoft SCCM Integration

This blog illustrates my experiences, challenges with Microsoft SCCM Integration.

 - First and far most important to know what kind of SCCM software being used at your customer location, Based on that version, Activate the corresponding plug-in in your Service Now Instance.

- I strongly prefer to have two Mid Servers configured for PROD Environment. Setup Mid Server and make sure Mid Server(s) up and running without any errors. Make sure verify the Log files of the Mid Server once started up and running. Goto Services on where Mid servers are installed, Verify the status of the Mid Server as shown below

- Get one dedicated User who has the access to SCCM
- Right click on Mid Server -> Properties
- Log On Section, Configure the dedicated user who has the access to SCCM and enter the Password and User Name. Make sure if you have two mid servers , need to repeat this step for each MID Server

- After successful plugin activation, You should able to see 'Integration - Microsoft SCCM..' on your applications list navigator as shown below
- Click on 'Setup'

- Enter all the required info in 'Integration Setup' form, Select the Mid Server and make sure MID Server is up and running. Save the form
- Next step is to configure all the required Data Sources for your SCCM Integration.
- Click on 'Data Sources' in 'Integration - Microsoft SCCM..' application
- Out of box, SCCM stores Servers and Workstations in different databases. Out of box we get all the data sources, so Create extra data source for each already existing data source and Suffix with ' - Server' and provide the correct Database Server Name and Database Name for all the 'Server' related data sources.

- Update all out of box Data sources with correct 'Database Server Name' and 'Database Name'
   Select 'Use Integrated Authencation' check box, so that it will use Mid Server to communicate with SCCM Database. Make sure to fill all the below highlighted required information for each data source

- After entering all the required information for each Data Source, verify 'Load All Records'  and execute 'Run Transform'
- I have very bad experience with 'Test Load 20 Records' , this won't work as expected all times, so don't relay on this functionality always.
- After first load of data, Select 'Use Last Run Datetime' check box on each data source, so that it won't load everytime same data into CMDB, only delta data for subsequent runs

- After configuring all the data sources, and verifying all the data sources working fine and loading data into CMDB, Next step is to configure 'Scheduled Import

- Click on 'Scheduled Import' in 'Integration - Microsoft SCCM..' application
- Choose the 'SCCM 2012 v2 Computer Identity' as your parent data source, and select appropriate value for 'Run' field
- Choose all the subsequent data sources which need to be run after Parent data source under 'Run the following imports when complete' section and give correct 'order' for each data source.

With this your SCCM configuration and schedule completed successfully and all good to go.

How to invoke Script Include by clicking on Pickup List? Or How to use Reference Qualifier in Service Now

This blog explains about how to invoke 'Script Include' by clicking on any 'Pickup List'

Use case : Display all the 'Configuration Items' based on selected value for 'Reported By' field on Incident form.

- Go to 'Script Includes'  in 'Applications Navigator'
- Create New, Give proper name and write the logic whatever you want in your script

- Go to 'Create new Incident' form
- Right click on 'Configuration Item' label, choose 'Configure Dictionary'
- Go to 'Reference Specification' tab
- Select 'Advanced' for 'Use Reference Qualifier' list of values
- Provide correct value for 'Reference qual'

- Now, Verify the functionality , Select value for 'Reported By' and click on 'Configuration Item' pickup list, you should see only configuration items associated to 'Reported By' selected value.

Service Now Best Practices

Discovery Best Practices
Best practice on setting up your MID Server
Best Practices When Using Discovery and SCCM Together
Discovery - Tips, Tricks, and Best Practices