Database view

[shruthim6691431]

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?

[Dr Atul G- LNG]

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.

[Bhuvan]

@shruthim6691431 

Table - Hardware Model Lifecycle (hml)

Table - Hardware Product Model (hpm)

You can use relation hml_model = hpm_display_name

Below is a sample database view for reference

I hope you appreciate the efforts to provide you with detailed information. If my response helped to guide you or answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Bhuvan]

@shruthim6691431 

Did you get a chance to review this as I believe the information provided should answer your question

If my response helped to guide you or answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Ankur Bawiskar]

@shruthim6691431 

so what did you start with and where are you stuck?

share screenshots.

If my response helped please mark it correct and close the thread so that it benefits future readers.