Required SQL or WLQ Querys

Question

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

 

Thanks

 

 

 

 

 

 

Answer ( 1 )

  1. Many SQL query reports are available here https://www.anoopcnair.com/?s=SQL+Query

    Have you seen all of these?

    Also, loads of queries are shared in the HTMDForum

    Search

    Best answer

Leave an answer

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