K20 - LAB 1163 - Get Started with Reporting - Q&A

[anna_scheib]

This article is for questions and answers for LAB1163 - Get Started with Reporting. This lab is being presented multiple times throughout the live K20 event May 5 - 7, 2020. During the live event, post your questions in the comments of this article, and one of our lab gurus will be happy to answer it.

[LearnMoreDoMore]

Hello and welcome LAB1163 session attendees! Here are some links you will need today:

Lab Guidebook URL:

• https://developer.servicenow.com/connect.do#!/event/knowledge2020/LAB1163

Additional Resources:

• Now Learning: https://nowlearning.service-now.com/lxp 
• A self-paced, on demand version of this lab session will be available on Now Learning after Knowledge. On Demand versions will be released in batches over the next several weeks.
• ServiceNow Product Documentation Site: https://docs.servicenow.com/
• ServiceNow Community: https://community.servicenow.com/community

[LearnMoreDoMore]

Feel free to introduce yourself and tell us a little bit about your role and experience. Also, post questions here throughout the session and our lab gurus will be happy to answer them!

[Edward Rosario]

My Name's Ed Rosario and this is my second year as a ITSM Servicenow admin for Aarons inc. Just got certified in april of this year

[LearnMoreDoMore]

Welcome Ed, and congrats on your certification!

[taylor_comstock]

What a great accomplishment!! Congrats!

[David Giammona1]

Welcome, Ed! Congratulations on the recent certification. Great to have you in the ServiceNow universe! 

[stormer]

Hello, My name is Caleb.  I am a supervisor in the service operations department at CDW.  Looking to learn a lot with reporting to better manage our teams and provide information how much work is coming in and how much work is getting done.

[RLamoureux1]

My Name is Ray Lamoureux, I am a former Remedy/Service Manager Administrator. Now for the last 6 years I am the Certified ServiceNow Admin at Fort Bragg, NC

[Tom Dunnam]

Welcome Caleb!  Glad to have you in today's session.

[taylor_comstock]

Welcome Ray!

[Tom Dunnam]

Great to have you Ray.  You have a solid history to use with ServiceNow!  I'm sure you'll find some new info in today's session.

[taylor_comstock]

+1 Welcome!!

[David Giammona1]

Great to have you in this lab session, Caleb! Hope you find some good tips to help demonstrate the value of your solutions. 

[Sameer7]

Hi, My name is Sam. I am from Calgary, Alberta. We just implemented ServiceNow in Jan so looking to learn lots about the power of the platform especially reporting.

[Sameer7]

My name is Sameer. I am the ServiceNow Admin (very very new) to the ServiceNow platform. Recently implemented the tool (Jan 2020). Looking to learn about the power of the platform. Came off being an admin for Assyst.

[Cody Rasmussen]

Hello Anna.  from this page:   how do it launch the guide for the Lab 101?

[Tom Dunnam]

Good day to you Sameer.  This will be a great class for you to learn some of the basics of reporting.  Welcome!

[LearnMoreDoMore]

try this! https://developer.servicenow.com/connect.do#!/event/knowledge2020/LAB1163

[taylor_comstock]

Hi Cody, use this link:


Lab Guidebook URL: https://bit.ly/3dca3vS

[David Giammona1]

Great to have you in the lab, Sameer! There are some great tips here to help create awesome reporting solutions QUICKLY. The more you get into the Now Platform, the more you'll discover the power available to serve your clients. Enjoy!

[anna_scheib]

The lab guide is here: https://developer.servicenow.com/connect.do#!/event/knowledge2020/LAB1163

[Cody Rasmussen]

great! thank you Taylor 🙂 worked/I am in

[Sheree2]

If you have two separate domains eg. IT & OT and these are not identified in the CMDB and you want to report on them. Any suggestions on the best way to implement this?

[Adam Stout]

Can you explain your use case in a little more detail?  What are you trying to report on?

[Tom Dunnam]

Hi Sheree,

I'm a bit confused re: "two separate domains" in relations to ServiceNow.  Do you have a separate ServiceNow instance for each domain?  ...or is the data combined within a singular instance of ServiceNow?

Tom

[Sheree2]

We want to identify assets in two segregated domains. All IOT devices are totally separated and we don't have a field in SNOW identifying whether they are IT or OT; they are ALSO currently mixed across both domains, but some are identified in the FQDN as ot.com or item.com. Is there a better option of creating a custom field for the two different options?

We want to filter between both device types to highlight which incidents are caused by which category.

[Betty Kelly2]

Hello! I am Betty. I have worked with SN for the last 4 years. Thanks for this Report Lab - I am hoping to hone my skills so I can better serve my customers. 

[Ketan Shah]

Where do you get the slides being presented?

[Sheree2]

No we only have one SNOW instance. We have Security layers in place between OT & IT.

[LearnMoreDoMore]

Someone asked: "In the first list filter we chose incident state but in the second lab we are using state. Which is best practice?"

Answers:

https://community.servicenow.com/community?id=community_question&sys_id=15909369dbdcdbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=34caf657db2e534023f4a345ca96...

[Tom Dunnam]

Hi Ketan,

The on-demand presentation will be available on NowLearning after these sessions have completed.  You can access at https://nowlearning.service-now.com and search for Get Started with Reporting.

[LearnMoreDoMore]

The self-paced, On Demand version of this lab session will be posted to Now Learning in the next couple of weeks. I'll notify everyone via this community article when it is available 🙂 

[Adam Stout]

In general, I would add a field, you want to push the logic to store your data (in a new custom field) instead of calculating on the fly which can be computationally intensive.

Here is a more detailed discussion on this topic:  https://community.servicenow.com/community?id=community_blog&sys_id=2f99990fdbee5b00fece0b55ca9619fb

[Cody Rasmussen]

NEVER joke about doughnuts!!! 😉

[Anjali39]

🙂

[Tom Dunnam]

Agreed Cody!  We need to find a way to put sprinkles on our donut charts!

[Brenda Doonan]

Hi, when do you use a Data Source vs Table?

[Lener Pacania1]

Hi Brenda, 

Use report sources for reports containing the same conditions, so you do not have to define the conditions more than once. You can also use report sources to implement the same definitions across your organisation.

more on:

https://community.servicenow.com/community?id=community_question&sys_id=2e555effdbe43f04d58ea345ca96...

[davis_ng]

hi Brenda, here is an community article on the topic https://community.servicenow.com/community?id=community_question&sys_id=2e555effdbe43f04d58ea345ca96...

[David Giammona1]

A predefined Data Source can also be helpful to provide to project members that need to create reports, but might not be as familiar with ServiceNow table structure.

[Lener Pacania1]

You'll notice that many of the guru's are pointing you to articles on the Performance Analytics and Reporting community @ https://community.servicenow.com/community?id=community_forum&sys_id=b5291a2ddbd897c068c1fb651f9619e...

One of the things I found helpful when I was learning ServiceNow is that if you have a question it's mostly likely been asked in the community.   If you post a new question you can often get a response within the hour from either customers who have done it or from ServiceNow employees.

[RLamoureux1]

Thanks for the presentation. I have completed all the labs. I have done some of these in my work, but my counterpart normally does these.

[Edward Rosario]

Hey Brenda,
Here's a community post I think will be useful

https://community.servicenow.com/community?id=community_question&sys_id=2e555effdbe43f04d58ea345ca96...

[Cody Rasmussen]

Hey just a question regarding the Dashboard created in Build a real-time single score visual.    When i went to the dashboard i saw two priority-type widgets  1. Incident Category  2. Incident Priority.   I do not recall creating these, but i like them.  How and when were those places on the Dashboard.     final question: how do i create these?   very valuable -thx

[Cody Rasmussen]

Trainer is showing it now.  those two interactive widgets.  how did they get on the Dashboard?  are they are 'widget" I can select?

[Cody Rasmussen]

YAY! I found them finally.  + > Gagets > Interactive

[Cody Rasmussen]

- gadgets   just Interactive Filters.    I missed using these on Dashboards.  I will start doing it now for sure! thanks Great Session

[David Giammona1]

ServiceNow Docs: Interactive Filters
https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/dashboards/c...

"You can create an interactive filter and add it to a homepage or dashboard as a widget."

"You can make an Interactive Filter available to users by adding the filter to a homepage or dashboard."

[David Giammona1]

Great job, Cody!

[Lener Pacania1]

nice work Cody digging in.