DataBase view to get VITs

Ratan B
Tera Contributor

‎11-28-2023 03:07 AM

Need to create Database view in servicenow to get the Vulnerable Items list which are tagged to single Remediation Task and where the assignment group of Vulnerable Item and Remediation Task is different. I've created a Database View for below tables but stuck with the "Where Clause" and "Left Join".

RatanB_0-1701169593679.png

 

0 Helpfuls
  • 292 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

‎11-28-2023 03:36 AM

Hi @Ratan B 

 

I am not a pro here, but check the OOTB database view and check the where condition.

 

If you need more details, try to do it manually and then you get the where clause condition and join.

*************************************************************************************************************
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]

****************************************************************************************************************
0 Helpfuls