Database view

shruthim6691431
Giga Contributor

7 hours ago

How can I create a Database View in ServiceNow by joining the Hardware  product models  table (using the Display name field) with the hardware mode life cycle table (using the Model field) as the common join field?

0 Helpfuls
  • 32 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

3 hours ago

Hi @shruthim6691431 

You need to identify the common field between the two—whether it's the Asset ID or Tag ID. Once you have that, you can create the database view.

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