Hi, Is there any method to use osquery in getting DNS records

You mean DNS requests/responses made on the endpoint? If so then no. There may be an extension that does this. Or there are commercial vendors that have this in their custom agents. The company I work for does.