The test case added has a hardcoded vlaue of the hostname in where claus...

...e

. changing the query so that there is no where clause involved