Inputlookup some data not matching with dbxquery

[rijuth]

I have a dbxquery which pulls some  applicationdata which includes servername. Also I have a inputlookup which fetches the server details from my server inventory.

My goal is to match the dbquery server name data with inputlookup data servername to show server status.Using the join type=left.

I can see few are matching and returning the server status but others not. I tried to search servername in inputlookup which is not matching and can see the data there .Checked if any space issue but not.

Kindly help on this.

[richgalloway]

I concur with @ITWhisperer .  The lookup and inputlookup commands are often confused and are not interchangeable.

Could case sensitivity be part of the problem?  If so, create a lookup definition and unselect the advanced option "Case sensitive match".

[ITWhisperer]

Why not just do a lookup (instead of a join to an inputlookup search)?