Creating Custom Reports by Using Configuration Manager 2007 SQL Views

• Creating Custom Reports by Using Configuration Manager 2007 SQL Views
  • Configuration Manager 2007 SQL Server Views
    • Schema Views
    • Site Views
    • Status Views
    • Client Deployment Views
    • Client Health Views
    • Collection Views
    • Software Distribution Views
    • Software Updates Views
    • Operating System Deployment Views
    • Asset Intelligence Views
    • Software Metering Views
    • Reporting Views
    • Desired Configuration Management Views
    • Query Views
    • Mobile Device Management Views
    • Network Access Protection Views
    • Discovery Views
    • Inventory Views
      • Hardware Inventory Views
      • Software Inventory Views
    • Wake On LAN Views
    • Security Views
  • Configuration Manager Reports
    • Predefined Reports Evaluated
      • All Collections Report
      • Computer Information for a Specific Computer Report
    • How to View a Configuration Manager Report SQL Statement
    • How to Clone a Configuration Manager Report
    • How to Modify a Configuration Manager Report
    • How to Create a New Configuration Manager Report
  • Technical Reference
    • Sample Queries Using the Configuration Manager SQL Views
      • Site View Sample Query
      • Status View Sample Queries
      • Client Deployment View Sample Query
      • Client Health View Sample Queries
      • Collection View Sample Queries
      • Software Distribution View Sample Queries
      • Software Updates View Sample Queries
      • Operating System Deployment View Sample Queries
      • Asset Intelligence View Sample Query
      • Software Metering View Sample Queries
      • Reporting View Sample Queries
      • Desired Configuration Management View Sample Queries
      • Query View Sample Query
      • Mobile Device Management View Sample Queries
      • Network Access Protection View Sample Queries
      • Discovery View Sample Queries
      • Hardware Inventory View Sample Queries
      • Software Inventory View Sample Queries
      • Wake On LAN View Sample Queries
      • Security View Sample Queries
    • Scenarios for Creating Custom Reports
      • Scenario 1: Modify an Existing Configuration Manager Report
      • Scenario 2: Clone an Existing Configuration Manager Report and Modify the SQL Statement in Query Designer
      • Scenario 3: Create a Report SQL Statement in Query Designer and Create a New Configuration Manager Report
      • Scenario 4: Create a Report SQL Statement in SQL Server Business Intelligence Development Studio and Create a New Configuration Manager Report
    • Exercises for Creating Custom Reports
      • Exercise 1: Run an Existing Configuration Manager Report
      • Exercise 2: Review the Properties for an Existing Configuration Manager Report
      • Exercise 3: Modify an Existing Report in Configuration Manager
      • Exercise 4: Clone an Existing Report and Modify the SQL Statement Using Microsoft SQL Server Management Studio
      • Exercise 5: Create a New Report and New SQL Statement Created in Microsoft SQL Server Management Studio
      • Exercise 6: Create a New Report and New SQL Statement Created in SQL Server Business Intelligence Development Studio
      • Advanced Exercise 1: Create a New Report for Desired Configuration Management
        • Advanced Exercise 1 Solution: Create a New Report for Desired Configuration Management
      • Advanced Exercise 2: Create a New Report for Hardware Inventory
        • Advanced Exercise 2 Solution: Create a New Report for Hardware Inventory
    • SQL Server Reference
      • SQL Statement Reference
      • Query Design Tools
      • How to Create or Modify a Report SQL Statement Using Query Designer
    • SMS Provider WMI Schema Reference
      • Configuration Manager WMI Namespaces and Classes