Software query sccm

The following query lists all resources that have run metered files, including the resource name, file ID, file name, file version, and start time.

The following query lists all users who have run metered files. The query returns the user domain, user name, file name, file version, usage count, total time of usage, and the last time the file was used. Software metering views in Configuration Manager. Skip to main content. The results are sorted by the assignment ID and then by article ID. Software updates views in Configuration Manager.

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode.

Right click the device collection and click Start CMPivot. In the CMPivot tool, select the Query tab. If you run the InstalledSoftware query, it lists all the softwares installed on every computer in the device collection.

The output is going to be definitely longer and you might have to export the list to a CSV file and review the results. In some cases you need to find all installed softwares from a specific computer.

If you want to find the installed softwares from a specific device or computer, then you use the below query. The above query finds the installed softwares for the specified device. In addition to the product name, the output also contains the Publisher information, Product Version and Software Code. Often we are asked to find a specific installed software from a remote computer.

Use the following query to find specific installed software example Visual Studio Professional on specific computer. For example, if you want to find installed softwares that contain Studio in Product Name you can use the below query.