You can also use the SQL statements in these reports to help you to write your own reports. Displays all software installed on a specified computer. You are first presented with a gridview list of all current app deployments. Displays the number of computers that have collected software inventory for a specified file. If a collection member has a deployment on a different collection you are out of luck. The following four reports are listed under the Hardware - CD-ROM category. Displays all software update deployments that are deployed to a specified computer. Displays the total monthly energy consumption (in kWh) for a specified collection over a specified time period. You can also use the SQL statements in these reports to help you to write your own reports. Displays scan errors at the site and a count of computers that are experiencing each error. It can report on application, package, compliance baseline, software update and task sequence deployments. View a list of computers on which a specified product is detected. Displays information about the SCSI cards installed on a specified computer. The name of the script is CMReporting.ps1. Displays the differences between the software inventories reported for two specified computers. The following three reports are listed under the Hardware - SCSI category. A deployment can install or uninstall an application. Displays a list of the status messages created in the last hour by a specified component on a specified computer at a specified site. Select your update deployment in the top pane, and the bottom pane will populate with some . The aggregate deployment state of the application for this user displays as Error. Displays the inventory history for CD-ROM drives on a specified computer. Displays information about the mobile devices that have the Configuration Manager client installed. This report shows the contents of the specified migration job. Copy the following SQL query to find the report of application deployment with collection details. The following seven reports are listed under the Wake On LAN category. This report lists all computers with a specified Windows app. Displays all of the package and program deployments to a specified collection. The following three reports are listed under the Company Resource Access category. We have many other SQL queries and other custom reports we shared with the HTMD Forum community. Displays total global data replication traffic on a specified link for a specified number of days. This tells the client to both check to make sure it has the latest list of deployments and then runs the Installation check for each of them to determine whether the app has installed successfully or not. Displays all computers that have installed software with a specified software identification tag enabled. These rules are for locally installed software, or using Terminal Services. Displays a list of clients that haven't reported discovery data, hardware inventory, or software inventory in a specified number of days. MEM is the ConfigMgr site code. Lets find out the ConfigMgr or SCCM Application Deployment Status using Custom Report, SQL query, and report builder. Displays detailed information about client assignment failures. Status Not open for further replies. Starting in version 2203, you can perform client notification actions, including Run Scripts, from the Deployment Status view. Displays USB devices, grouped by manufacturer. Displays a summary of all instances of software installed and registered with Add or Remove Programs or Programs and Features on computers within the specified collection. Displays a list of computers that have a specified network adapter. Displays the number of computers discovered by Configuration Manager client version. In progress: The client is currently running the application deployment. Help. For each compliance state, you can view additional information, such as the number of users and devices in this category. Displays a list of computers that have a specified SCSI card installed. . Displays the status messages reported for a specified computer and package and program deployment. The clients return the state during the last compliance scan. Displays the name of the content that was rejected by a peer source. In the Configuration Manager console, go to the Administration workspace, expand Site Configuration, and select the Sites node. Deployment: Applications: List of devices with their application deployments in Configuration Manager. Displays information about users that have apps installed that aren't compliant with a policy you specified. Status messages, by contrast, work to help administrators track the flow of data through various SCCM components. The list organizes for every hour since an administrator creates the package and program deployment. Displays a list of computers that contain a CD-ROM drive made by a manufacturer you specify. Identifies security, administrative, and compliance vulnerabilities for a specific computer. Displays executable programs that users recently used. Historical: Displays an overview of the health of your Configuration Manager infrastructure. Displays usage details for installed applications. Deploy SCCM Application Groups. Displays clients that are excluded from migration. Displays all of the package and program deployments that apply to a specified computer. Displays detailed status information for a specified Windows RT sideloading key. Displays the deployment errors at the site and a count of computers that are experiencing each error. After opening, you may need to change the datasource for each DataSet to either the GUID one you . Displays a list of users and their computers in a specified domain. Displays information about all mobile device clients. This is a part of SCCM inventory functionality. The following 15 reports are listed under the Software - Companies and Products category. Displays the status summary of all resources targeted by the specified deployment that is available to a collection containing unknown computers. By clicking the three vertical dot menu on the right side of the application row, you have the option for either ' deployment' or 'delete'. The Implementation. Displays a list of computers where a specified Microsoft product that supports per-processor licensing is installed. Displays information about the rules evaluated as compliant for a specified configuration item for a specified device or user. Ill include the code at the bottom of this post, but first, Ill show you how to use it. Displays a graph showing monitor, computer, and user activity for a specified collection over a specified time period. Displays a list of computers that have a processor of a specified speed. Displays a list of site system server and their site system roles for a specified site. Each day represents a percentage of total clients that requested policy since the first day in the cycle. The following two reports are listed under the Alerts category. Displays the mobile devices that completed enrollment with Configuration Manager, have a certificate, but failed to complete site assignment. The following eight reports are listed under the Software Updates - A Compliance category. Displays the list of users with the most number of detected threats. Displays the weekly progress of a task sequence, starting from the deployment date. You can filter this report by product name. Displays all drivers in a specified package. Displays the compliance data for software updates released by a vendor during a specified month and year. Displays the health state details of the roaming user profile for a specified user. Displays a summary of the compliance state of the rules and any setting errors for a specified configuration item. Get-CMAppDeploymentReport -ChooseFromGrid -DetailType Both -OutputType Text. Displays executable files that users recently used on a specified computer. The following 13 reports are listed under the Software Metering category. Displays the mobile device compliance details for a default Exchange ActiveSync mailbox policy that is configured by using the Exchange Server connector. The following 10 reports are listed under the Replication Traffic category. Displays information about the network adapters installed on a specified computer. Displays all drivers for a specified platform. Displays the number of processors on computers using Microsoft products that support per-processor licensing. Displays the number of computers in each resource domain or workgroup. Endpoint Manager. In the SCCM console go to: Monitoring -> Deployments. The main KPI is the first bar and all the others should simply help identify patch problems or flaws in your deployment strategy. Displays a list of computers that have multiple, conflicting power settings applied. Status. Then select More Details on the right side of the window. Intune as an extension of Microsoft System Center 2012 Configuration Manager - If you already use Configuration Manager to manage on-premises devices and are looking for a. With the Introduction of Applications in SCCM since the 2012 RTM version, a lot has changed, new features have been introduced, now most the organizations follow to create applications instead of Packages and achieve their requirements easily, but one thing that has become difficult for Admins is the reporting (SQL queries). Displays the client check results of active clients for a given collection. Displays the users enabled for the Microsoft Intune subscription. When clicking on a number, you are sent to the Deployment - Application report. The following one report is listed under the Task Sequences - References category. Displays a list of computers that run Windows Server operating systems. Configuration Manager displays multiple deployment results for that computer. Displays total replication traffic for all data for a specified number of days. Displays objects that are scheduled for wakeup. Displays a detailed list of inactive clients for a given collection. Display a count of detected App-V applications. Displays detailed information for clients that have successfully deployed. Displays all computers with specified software configured to automatically run. View details for products in your environment that have expired lifecycle dates. Displays overview information about client assignment status. Displays a summary of the compliance status with the Default Exchange ActiveSync mailbox policy for the mobile devices managed by the Exchange Server connector. I will also be sharing how can we create a Pivot table in Report builder and utilize that. . Displays the users that most recently used a specified executable program. Configuration management (CM) is a process for establishing and maintaining consistency of a product's performance, functional, and physical attributes with its requirements, design, and operational information throughout its life. To use this script, you first need to load the functions into memory by running the script. Planning and Deploying Applications and Updates to Win7 x64 and Win10 x64 to be deployed out to end-users via SCCM 2012r2 utilizing the application model with Software Center. Displays the number of failures in each phase or group of the specified task sequence. Displays summary information about a specified IP address. The following 67 reports are listed under the Asset Intelligence category. Displays task sequence deployments that install a specified application.