Sccm query add remove programs

Miscellaneous Questions. Is there any way to have Zoom settings be the same across Windows users? Can it be Possible to Export files from Outlook to Thunderbird email client.

Link Related Links. CardScan 8. Troubleshooting Microsoft Teams Connection Issue. Post Related Posts. If you run this query now, you should get a return which looks much tidier.

Well, you can do that too, if you have a number of set collections be it for machine types or for departments etc, then you may want to just return all installed software on all machines within the Finance department…. Once you have your Collection ID, you need to make a declaration in your SQL query, so you should add the following to the start of your query:. So, if we use the full query from above, your new SQL query which is now based only on machines within the declared Collection, it should look like this:.

If you want to expand the data that is returned, you can always either join more tables or run the following query and select the columns that you want:. We have now created a guide that will help you to create your SSRS reports based on the data that this guide will pull into the Configuration Manager database.

If you have any questions or feedback about this post, or if you would like us to create any queries for you, please go ahead and leave us a message below in the comments section and we will get back to you as quick as we can.

We will not spam you and we will not pass on any of your details to anyone else. We tend to post new content once or twice a week. Query - Computers with specific application and version installed. By Kris Gross - February 10, Sometimes you want to create a query based on if a computer has a specific Application and version number.

This type of collection is great for bushing out an update to application. I am a newbie to the reports. How to create it, step-by-step or showing the SQL statement? Sort by date Sort by votes. Prajwal Desai Forum Owner Staff member. Try this and let me know if this worked for you. CompanyName, SP. ProductName, SP.