This SQL query will allow you to find and rely software program file and products data to get a specified executable.
When you’re very excellent with WQL or have a query you have got pulled from the Internet, you can simply click Present Query Language and set your query there in lieu of use the tabs to develop your query.
By running our initially query, it can convey back again a large amount of details (determined by your surroundings measurement of course) – it is going to essentially exhibit the selections for every machine inside your Configuration Supervisor database.
During this publish we is going to be investigating making use of SCCM dynamic queries to populate collections within our deployments. Like a SCCM administrator, you more than likely needed to program out mass deployments to all of your servers or workstations and even the two.
This SQL query will present you with an example of how to vary a query effects NULL worth to some thing more readable or easy to understand.
What is good with WQL queries is which you can use those same queries for assortment. For people who fully grasp SQL syntax, you gained’t be dropped. It appears to be like lots like SQL queries.
However, if you still want to understand so you are Do-it-yourself individual, open the SQL Administration Studio and query all v_GS_ xxxxx views inside your CM databases. These are the lessons inventoried over the components inventory.
Catapult takes advantage of cookies to improve your working experience, to display customized content in accordance with all your browser configurations, and to help us much better know how you utilize our Web page.
It is almost certainly the internal joins; since a x86 box is not going to have any 64 stuff; so nothing at all to join on. Â Just allow it to be less difficult:Â
Administration essential me To place with each other a SCCM Query SQL report for various versions of a similar application. This unique scenario proved tricky since the logic included which includes an "or" for the applying variations and an "and" to the publisher from the "where by" part. This query did the trick for me:
Should you have any concerns or responses about this submit, or if you prefer to us to make any queries for you personally, be sure to go ahead and leave us a concept underneath in the responses portion and we can get back to you as swift as we can easily.
Is there any way this report can clearly show all Microsoft (or almost every other suppliers) items as opposed to just the merchandise specified?
Make an effort to refresh the world wide web report from the browser, and when A different “The Find authorization was denied†mistake seems in relation to other SCCM tables, assign the accessibility permissions to these tables in the identical way.
Delete any textual content currently during the ‘Query Assertion’ box and copy and paste the query previously mentioned SCCM SQL Query for Add Remove Programs in to the box