Blog

IT GRC ASC Data Load

This article contains an example method to import Authoritative Source Content (ASC) for the ServiceNow GRC application.

4MY9b.jpg

This is helpful for importing new ASC like COBIT 5.0 or other new updates. You can also use this to import your own company's ASC if designed.

Wiki Articles for reference:

http://wiki.servicenow.com/index.php?title=Import_Sets
http://wiki.servicenow.com/index.php?title=Creating_New_Transform_Maps
http://wiki.servicenow.com/index.php?title=Transform_Map_Scripts

Example ASC Import

  1. Turn off Email

    Turn off email on system if activated.

  2. Create Excel File

    Create an excel file with columns such as:

    • Authoritative source
    • Comments
    • Key areas
    • Name
    • Reference
    • Type
  3. Load Data

    Load Data into Import Set Table:

    • Label: GRC ASC Data Upload

    After Import Set Table is created, Click Create Transform Map link.

  4. Transform Map

    Setup Transform Map:

    • Name: GRC ASC Data Upload
    • Source Table: GRC ASC Data Upload
    • Target Table: Authoritative Source Content
    • Run Business Rules: false
    • Enforce Mandatory fields: No
    • Copy empty fields: false

    Transform Map (Field Map)

    Source field | Target field | Coalesce | Choice Action
    u_comments | comments | FALSE | ignore
    u_key_areas | key_areas | FALSE | ignore
    u_caller_id | caller_id | FALSE | ignore
    u_name | name | FALSE | ignore
    u_reference | reference | TRUE | ignore
    u_type | type | FALSE | ignore

  5. Transform Script

    Reference fields are stored as sys ids in a ServiceNow table, so we need transform scripts to convert the data we imported for reference fields to sys ids. Below are some example conversions for reference fields:

    • When: onBefore
    • Order: 100
    • Script:
    //Set Authoritative Source Content Reference
    var grAS = new GlideRecord('grc_authoritative_source');
    grAS.addQuery('name', source.u_authoritative_source);
    grAS.query();
    if (grAS.next()) {
    target.authoritative_source = grAS.sys_id;
    }
  6. Transform!

    After your Import Set, Transform Map, and Transform Script are ready. Transform the Import Set you created.

  7. Purge Emails and Turn on Email

    Purge any emails in the Email Log that you don't want sent and Turn on Email