The way I set it up is that for any host I edit the view, change the column parameter to another, this time it was host address(primary), in the options above ‘General Properties’ I check ‘Make this view available for other users’, save the changes and it works,
THANK YOU ALL 
Topic closed.