Extract a list of affected location

rajeevj
Tera Contributor

Hi all clever people.

 

I want to extract a list of " affected locations

AL.PNG

" for every open incident.

 

Can someone please assist?

 

Many thanks

 

Raj

 

 

3 REPLIES 3

Hemanth M1
Giga Sage
Giga Sage

Hi @rajeevj ,

 

Please follow below steps

1)go to  task_location list by entering "task_location.list" from the left filter 

2)Apply the filter task type is incident

3)right click on the list export 

Sample :

 

 

HemanthM1_0-1690306152227.png

HemanthM1_2-1690306197606.png

 

Option 2: you can build a report around this and schedule to send as PDF to email.

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

Hi @rajeevj ,

 

Did it help, if so.

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @rajeevj 

 

Greetings!!

 

The easy way to create a report for same. To do the same, we need the table name, you can get the table by Task-INCxxxxx and open in new tab. and you will get the table name. and then use that table to create report where task is incident.

 

Please mark this response as correct or helpful or the solution accepted if it assisted you with your question.

Regards
Atul G.
Learn N Grow With Atul G

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************