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 )
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