The test case added has a hardcoded vlaue of the hostname in where clause
. changing the query so that there is no where clause involved