Required SQL or WLQ Querys


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 and Desktop with Version

4.Patch Failure Details and Updated status

5.List of SCCM agent Installed with Which AD  And Client Status





Please provide if possible above my Querys please









Answer ( 1 )

  1. Many SQL query reports are available here

    Have you seen all of these?

    Also, loads of queries are shared in the HTMDForum


    Best answer

Leave an answer

Sorry, you do not have permission to answer to this question .