Displays usage details for installed applications. I will also be sharing how can we create a Pivot table in Report builder and utilize that. Displays the number of server component error status messages in the last 12 hours. I used different KPIs to measure update compliance and the report combines all that into one dashboard. It searches based on the following criteria: product name, publisher, or version. Find SCCM Application Deployment Details using SQL Query - Prajwal Desai Connect your Database Engine. Displays all drivers for a specified platform. The following reports are included with Configuration Manager. Displays the number of computers discovered by Configuration Manager client version. Historical: A summary of software distribution for a specific advertisement and machine. Over 16+ experience in End-user services along with cloud technologies<br> Primarily worked on various packaging, repackaging, release and testing tools such as Install Shield 2012-2019, App-v Sequencer for various versions of Windows 10.<br> Involved in Configuration Manager Application deployments end to end life cycle for Windows 10 Migration Program, Imaging/re-imaging laptops . (Same as we see in the Monitoring node). Open the template file, click Cancel if it asks you for the Power BI account or just sign in if you already have an account. Displays a list of computers running a specified version of the Configuration Manager client software. Displays users and the count of computers on which they're the primary user. Displays the summary information for the specified task sequence deployment. Displays securable objects, the security scopes associated with the objects, and which administrative users have rights to the objects. In the query window, paste the below SQL query to find SCCM application deployment details and click Execute. Based on research, Configuration Manager supplies many built-in reports covering many of the reporting tasks that you might want to do. Its lawyers provide litigation and other dispute resolution . Displays total replication traffic for all data for a specified number of days. Displays objects that are scheduled for wakeup. The following 13 reports are listed under the Software Metering category. The following five reports are listed under the Hardware - General category. Displays all computers in a specified enforcement state for a specified software update. PowerShell and SQL server. Displays the average number of usages of a particular program for the past 90 days, broken down by hour and day. Displays the driver catalog matching report for a specified computer. Displays compliance information for a specified virtual environment for a specified collection.