sql query or wql querys required

Any one Can help with below Querys please..?? 1.Inventory Of Servers and Desktop and Loptops with OS Installed  and Version and which AD  having Current 2.list of the All servers and OS details and Installed Upadate Details 3.list of application Installed Server ...