How to Use SQL Joins while writing SCCM Reports

  create reports for the requirement and i first start analyzing the necessity and find the information about the required information where they stored in SCCM Database (SQL views). Most of the reports (SQL) that i have created in this blog created with basic syntax’s like joins. Only certain reports go beyond the joins but…