Creating Custom Reports by Using Configuration Manager 2007 SQL Views
Documentation Home
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
Documentation Home