K23 - ServiceNow Advanced Admin - Galileo 902 - Level 1 - Links and Info

[darren_halliday]

If you are in the K23 ServiceNow Advanced Admin class in room Galileo 902, please introduce yourself and post any comments or questions here using the COMMENT button. Classroom staff will be monitoring this conversation during class on May 14-15, 2023 and will answer to the best of their ability.

Please also see attached to this article a PDF file containing answers to questions posed in the Labs and also code snippets to support some of the Lab activities.

We will be using REST based integrations today.  To complete Labs 4.1 and 4.2 we will use the following URL and the the following rest_service user:

https://snaa-may10-544-001-instructor.lab.service-now.com/api/now/table/incident

user: webservices.connection

pwd: K23D3m0$

I thought I would share with you resources for some of the features shown yesterday:

ServiceNow Command Line Utility:

https://docs.servicenow.com/en-US/bundle/utah-application-development/page/build/servicenow-cli/conc...

Using IDR:

https://www.servicenow.com/community/creatorcon-blogs/instance-data-replication-managing-data-across...

If you are interested in trying out another REST intgeration example, I have attached a Lab that you can do in a developer instance.  The lab uses a public REST web service that returns a payload of countries of the world.  The Lab calls the REST Service via a REST Message and the payload is processed through a small script and pushes the data into an import set which triggers a Transform Map to populate a target custom table.  The Script and Lab are attached.

[darren_halliday]

I would just like to introduce myself.  I am Darren (from the UK) and I have been an Instructor with ServiceNow since 2012 (Aspen Release).  I teach various courses including Scripting, Discovery, Advanced Admin, Service Mapping and more.  

My hobby when not an IT geek, is trying to play guitar (badly) and I my favourite music is 60s and 70s rock.  I would also add Oasis (really a Beatles/Who cover band).

See you at pre-con.   Darren

[bsmolski]

Hello, my name is Brett and I'll be assisting Darren as a secondary trainer/teaching assistant. I'm from Melbourne, Australia. I've been training for the last few years but I originally come from a programming and BA background.

Being a Melbourne lad, I'm very much into my Aussie Rule Footy and barrack for the Western Bulldogs (think Chicago Cubs for you MLB fans). I'm father to two young girls so hobbies don't currently exist for me, but I love to do some homebrewing and playing RPGs whenever I can.

Hope to see you down at pre-con. Come and say hi!

[treyhem]

Hi all! My name is Trey Hemmingsen and I'll be one of your teaching assistants. I'm part of our Academic Partnerships team, focused on giving professors and their students Now Learning content to incorporate into their classrooms for hands-on experiential learning. I've been with ServiceNow for just over three years. 

I'm based out of Denver, Colorado and enjoy hiking, food & wine/gin, and love to travel. My top three favorite trips have been to the Philippines (El Nido, Palawan), Scotland (Isle of Skye & Edinburgh), and Maine (we try to go every summer). 

Looking forward to meeting you this week!

[Ivano B]

Hello, I am Ivano and will support Darren as a teaching assistant during K23.

I joined ServiceNow in 2011 and worked with the Professional Services team for nine years, covering different technical roles before joining the education team in 2020.

As Darren, my class portfolio is rich and diverse and spans the vast ServiceNow solutions portfolio (ITSM, HR, SAM, HAM etc.).

In my carrier, I technically supervised several essential and complex implementations of ServiceNow in EMEA and created multiple custom applications for customers and our internal teams.

At the moment, I'm based in Italy, and as you can suspect, I'm a tech lover 🙂

Looking forward to meeting in the class!

Cheers

Ivano

[Michael Dove]

Hi I'm Michael Dove and I'm system administrator for Markel Insurance. This is my first knowledge event and im excited to learn as much as I can! Add me on LinkedIn I would love to connect with you all and learn how you guys are implementing ServiceNow at your companies.

[Bill Claman]

Hello I'm Bill (General Mills). This is my first Knowledge event and I am looking forward to learning a lot.

[MysteriousPelic]

Hello, I am Rob Pennington.  I am the Global Service Desk Manager for Pelican Products.  First time at Knowledge!  Looking forward to getting a better handle of managing and maintaining my ServiceNow Instances!

[CCharney]

Howdy from Houston, Texas

I am Carolyn Charney, Software License Compliance & IT Asset Manager for Tokio Marine HCC.

First in person Knowledge Event...

[Joe Aguirre]

Hi, Iam Joe Aguirre. I am a Self-Hosted Systems Administrator for JSOC (Joint Special Operation Command) at Fort Bragg, NC. I've been a ServiceNow Admin for about 2 years, this is my first Knowledge event, looking forward to meeting all of you!

[Marina Yulpatov]

Hi,

I am Marina Yulpatova, Lead, Enterprise Business Applications at Bow Valley College in Calgary, Canada. I participated in Knowledge 21 online during covid. This is my first in-person Knowledge event. Looking to upgrade my skills and knowledge and connect with ServiceNow admins and SMEs.

[treyhem]

@Marina Yulpatov we should chat on our break! We are in initial conversations to give students at Bow Valley College access to ServiceNow as part of their courses. 🙂 

[treyhem]

Class question: Can data replication be turned off for periods of time?

[kevinmurphy]

Hello,

Kevin Murphy from Tufts University. I'm the Manager of IT Service Management for Tufts. This is my 6th Knowledge. First was Knowledge 12. 

[ruzbehv]

Hi,

For those you are interested, here is the link to the 'Add to Update Set' xml.  One this to note is that the UI Action will add it to your current active update set.

https://developer.servicenow.com/connect.do#!/share/contents/9824957_add_to_update_set_utility?v=7.7...

-RV

[Michael Patten]

var table = 'sys_security_acl';
var query = 'name=' + table_Name;
save2updateSet(table,query);


function save2updateSet(table,query){
    gs.print('Table: ' + table)
    var rec = new GlideRecord(table);
    rec.addEncodedQuery(query);
    rec.query();
    if (rec.hasNext()){
        while (rec.next())
        {​
            var um = new GlideUpdateManager2();
            um.saveRecord(rec);
        }​
    } else {
        gs.print('No data')
    }
    gs.print('---------------------------------')
}

[Yves Beland]

Hi,

Data source with multiple transform map execute only 1 transform

The behavior changed in a previous version

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0869943

[jlu]

Just as a heads up - after creating the system clone - there are errors in the log:

There seems to be an issue calling API for scheduling the clone. The message is InternalError: The choice of Java method com.glide.util.StringUtil.base64Encode matching JavaScript argument types (null) is ambiguous; candidate methods are:
class java.lang.String base64Encode(java.lang.String)
class java.lang.String base

[bsmolski]

Explanation of debugging icons:
https://developer.servicenow.com/dev.do?_escaped_fragment_=/learn/learning-plans/orlando/new_to_serv...

[ruzbehv]

A very helpful extension is SN Utils for Chrome.  

https://chrome.google.com/webstore/detail/sn-utils-tools-for-servic/jgaodbdddndbaijmcljdbglhpdhnjobg

-RV

[bsmolski]

// Gives you the time a query takes to execute in ms	
// Using GlideStopWatch(), record the time taken to execute a query.
	gs.cacheFlush();
	var stopWatch = new GlideStopWatch();
	var gr = new GlideRecord('x_tablename');
	gr.addEncodedQuery('Filter Query Goes here');
	gr.query();
gs.info('Query duration: ' + stopWatch.toString());

[bsmolski]

Some real world scenarios where IDR is useful:

• Multi-national customers with multiple production instances across different countries/regions
• Customers with product divisions, subsidiaries or mergers/acquisitions

In these sort of scenarios, there may be subtle data model differences or certain data may need conversion which can be achieved with IDR.

[aaron-howard]

Hello all. I am Aaron Howard with the City of Dallas. I am our primary System Administrator, Scrum Master, and fill-in Developer when needed. We have been using ServiceNow for two years now. I am at the conference this year with my colleague Steve, and we look forward to meeting many of you during this week. 

[mikevdberge]

Very useful series of training video's on ServiceNow Scripted REST API's
ServiceNow Scripted REST APIs: Part 1 – Introduction - YouTube

[IndianaJones]

Chuck covers creating REST APIs and using the ServiceNow API Explorer very well in his YouTube course.

https://www.youtube.com/watch?v=S70s5nisOjU&list=PL3rNcyAiDYK2_87aRvXEmAyD8M9DARVGK&index=49

[Mayur Nagda]

Data filtrations documentation from SN 

https://docs.servicenow.com/bundle/utah-platform-security/page/administer/security/task/data-filtrat...

[sneidich22]

Data filtration info DOES appear in the debug security area (screenshot from lab context) 

[shill]

Something to keep in mind when troubleshooting business rules and ACLs...

https://snprotips.com/blog/2023/4/28/your-servicenow-acls-are-broken

[mikevdberge]

Do you want to know how much storage your instance is using see this KB
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1177521

[bsmolski]

Hi all,

Please find a great series of videos from Chuck Tomasi on learning Javascript on ServiceNow:
https://www.youtube.com/watch?v=62Nabpb94Jw&list=PL3rNcyAiDYK2_87aRvXEmAyD8M9DARVGK

[bsmolski]

Some details on how the Instance Security Centre portal's compliance scores are refreshed:

https://docs.servicenow.com/en-US/bundle/utah-platform-security/page/administer/security/concept/how...

[bsmolski]

Any dashboard can be refreshed using the option in the context menu: