Query for Device Inventory

Hi Team, 

Would it be possible to query the below details for device :

1. DNS Name /FQDN 

2. Logged in (Domain )

3. Last logged in user

4. IP address 

5. Group 

6. Status 

7. Operating system and version 

9. Last update 

10. Status 

11. Agent Installed status and Last Online date and time. 

I am new to SQL , Any help is appreciated , Thank you.