Displays a list of the sleep and wake capabilities of computers in the specified collection for a specified date and time. In progress: The client is currently running the application deployment. Usually, when asked, I turn to SQL. An application deployment state has one of the following compliance states: Success: The client successfully deployed the application or it's already deployed. (Same as we see in the Monitoring node). These clients must have an assigned fallback status point. Displays the overall health and compliance data for a software update group. You can also use the SQL statements in these reports to help you to write your own reports. The following is one of the many ways to get the app deployment status from ConfigMgr. Displays a list of all of the video cards installed on computers. Displays all computers with specified software configured to automatically run. The following eight reports are listed under the Hardware - Disk category. The following six reports are listed under the Endpoint Protection category. Displays the time at which the most recently summarized metering data was processed on the site server. In this post, I will be sharing a Configuration Manager SQL query that will provide you Deployment status for an Individual Application corresponding to a Collection. Use these subcategories to help you to quickly identify any important issues with an application deployment. Displays information about all the issues reported by clients. Displays all Windows apps installed to the specified user. The name of the script is CMReporting.ps1. Displays all software installed on a specified computer. Displays a list of computers that the site hasn't recently discovered. Displays the progress of all task sequences that deploy operating systems. Displays securable objects, the security scopes associated with the objects, and which administrative users have rights to the objects. If multiple agents discovered a computer, it may appear more than once in the list. Displays the devices or users in a specified compliance state following the evaluation of a specified configuration baseline. Displays the overall compliance data for a software update group. Software metering must be enabled for this site to view this report. Displays the total monthly energy consumption cost for a specified collection over a specified time period. Highlight one and click "OK". Displays administrative users, their associated security roles, and the security scopes associated with each security role for each user. Displays the software that is either categorized as unknown or has no categorization. Displays a list of computers in a specified collection where a hardware class has changed during a specified time period. Steve Bowman is a Partner at Model Technology as well as their Vice President of Sales and Marketing. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Displays a summary of installed Windows apps. Founded in 1877, the firm represents leading international businesses, from Fortune 100 corporations to mid-market and emerging enterprises. These clients must have an assigned fallback status point. If you don't renew the certificate before the expiry period, the mobile devices become unmanaged. Specify a collection to display the count of computers in each compliance scan state. Displays information about the network adapters installed on a specified computer. Copy the following SQL query to find the report of application deployment with collection details. In the SCCM console go to: Monitoring -> Deployments. The following four reports are listed under the Client Push category. Displays summary information about a specified IP address. Hardware Inventory Cycle collects information such as available disk space, processor type, and operating system about each computer. Displays the total time that it took to successfully complete a specified task sequence on a specified computer. This state isn't applicable for deployments with a purpose of Available. Displays the number of CD-ROM drives inventoried per manufacturer. Displays security scopes and the Configuration Manager administrative users and security groups associated with each scope. Select the CM_MEM database from the drop-down menu. Displays summary information about the physical disks on a specified computer. Deployment Summary Report. Displays a count of installed software with a software identification tag enabled. Click on the New Query button. Displays a list of computers in a specified Workgroup or domain. Use the browser to get the certificate details: Step 1. Displays a summary of computers that have the specified App-V application shortcut as created using the Application Virtualization Management Sequencer. Displays a graph showing CO2 emissions generated by a specified collection over the past 31 days. The clients return the state during the last compliance scan. Displays a list of all sites in the hierarchy that are enabled for Wake On LAN. Displays all the resources in a specified collection. In the Configuration Manager console, go to the Administration workspace, expand Site Configuration, and select the Sites node. Select Run whether user is logged on or not. The following six reports are listed under the Administrative Security category. Compliance 5 - Specific computer. Displays summary information about the video cards installed on a specified computer. The following 10 reports are listed under the Site - Discovery and Inventory Information category. Displays information about the mobile devices that have the Configuration Manager client installed. Displays application infrastructure errors. Displays a list of computers that have processors with a speed that is faster than the specified speed. View a list of computers on which a specified product is detected. To display Details list. If your site has numerous deployments, filter the list to just application deployments. Right Click on your database CM_XXX and click on 'New Query'. 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 status messages for a specified package on a specified distribution point. Application Deployment: Historical: View details for application deployment for a specific application and machine. Displays the number of computers inventoried by operating system. 22 2 3. I used different KPIs to measure update compliance and the report combines all that into one dashboard. Displays a summary of status messages indicating remote control of client computers by a specified user. Displays USB devices, grouped by manufacturer. Software Deployment Tools: SCCM vs Intune vs GPO vs More. Displays the differences between the software inventories reported for two specified computers. These values apply to application, task sequence, and package deployments. Displays the percentage of clients that requested policy at least once in the last 30 days. The following 19 reports are listed under the Site - Client Information category. Displays the mobile devices by operating system. This post is locked. Displays errors received while sending wake-up packets to computers for a defined period. Displays information about a specified virtual environment that is in a specified state for a specified collection. If you need to see more items, use Configuration Manager reports to review application status data. Displays computers with a specified operating system. Deployment: Operating System: List of devices and operating system deployment statistics in . Applies to: Configuration Manager (current branch). Displays a list of computers not reporting any power activity for a specified date and time. Identifies and displays computers that have a specified item from the Microsoft Volume license ledger. Select the site for which you want to configure the summarization interval. The Management Console shows this data under Displays the status summary of all resources targeted by the specified deployment that is available to a collection containing unknown computers. Displays the list of destination computers that exceeded the specified length of time to run a task sequence. Displays detailed information about each client that runs the HTTPS Communication Readiness Tool, and reports to be either capable or incapable of communicating over HTTPS. It also shows any deployment types for the specified virtual environment. Displays the mobile devices that completed enrollment with Configuration Manager, have a certificate, but failed to complete site assignment. Reporting on application deployment is possible within SCCM by accessing Software Distribution - Application Monitoring but the process is complex. Displays a list of computers where the amount of RAM has changed since the last inventory cycle. Right-click Application Groups and select Deploy. Displays the mobile devices that are jailbroken or a rooted device. Displays products on a specified computer that have their licenses managed by the Software Licensing Service. Displays a history of the wakeup activity that has occurred since a certain period. Displays detailed information about deployment success for mobile devices that are managed by the Configuration Manager client for Windows CE. It searches based on the following criteria: product name, publisher, or version. Displays the list of sites in the hierarchy with site version and site status information. The following 13 reports are listed under the Software Metering category. The configuration item must be deployed to a device or user. SmartDeploy Alternatives, Competitors & Similar Software. Displays computers with a specified operating system and service pack. Displays the status of Windows RT sideloading keys. Displays hierarchy aggregate global and site data replication for each direction of every link for a specified number of days. Displays the product categories in a specified product family and the count of software within the category. Possesses strong understanding of multiple OS platforms and deployments. Using a SQL query, you can find SCCM application deployment details with following steps: Launch the SQL Server Management studio (SSMS) and connect to database engine. Displays information about the client push installation process for a specified site. Identifies security, administrative, and compliance vulnerabilities for a specific computer. Displays a list of rules that conflict with a specified rule for a deployed configuration item. The following eight reports are listed under the Software Updates - B Deployment Management category. Configuration Manager . Displays reconciliation on software licenses acquired through Microsoft Volume License Agreement and the actual inventory count. So I just downloaded this report, and found that when I click on the pie chart, it changes the OU, so for instance if I choose in the Deployment results for Specific Application Per OU report Domain\Office\Location it shows all the installs for the OU, but when I click on the chart to see the list the OU changes to DOmain\Office\Location\A1\Computers