All Apps and Add-ons

Splunk DB Connect: How to join database information and hardware information tables?

Explorer

Hi,

I have a question about how joining works in the sql explorer of db connect.
I have 2 tables one with database information and another one with Hardware information.
The database table includes:
DB_OBSO_SGBD_DATE, DB_T_ENVIRONMENT, DB_T_NAME, DB_T_SGBD_CATEGORY, DB_T_SGBD_RELEASE, HRD_T_NAME.
And the interesting fields for me from the Hardware table are HRD_T_NAME and HRD_C_SECTOR.
In the Hardware table, there are more items in HRD_T_NAMES, than in the database table.
I now want to join these two tables together to get the matching HRD_T_Names and the HRD_C_SECTOR in one table.
Has someone suggestions for the join function?
Thx in advance.

0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!