I am having trouble connecting hosts via plain osquery in fleet dm, any suggestion.

I'd recommend asking the #fleet channel for that.