query

Greetings! We have multiple collections on our MECM server for various Windows Build values to try and identify those devices in our environment that need upgrading. We use a query to control membership but in some cases, the query is quite clearly not including some devices that qualify. For...

Guys, I'm looking for a SCCM SSRS Report to know the status (installed or not) of a specific software/application on a specific collection. Do you know about this? I have this .rdl as base (SSRS 2012). Remember to change the dataset. https://1drv.ms/u/s!ApU3gCm4YRBIhN12OGV1U0sLofQZsg...

Hi All, need help with sccm report(or query) i need get machines with lan/wlan auto switching enabled or disabled or if its possible, to get machine who have wireless and lan ENABLE the same time Thanks.

Hi, I have a park of 450 pc, and I have to make the removal of proxy settings from all browsers internet explorer 11 and 12. We have nw established internet connections via a new firewall and have to remove all these settings There is a method to set all parameters of lan settings on these...

Hi guys I have created a query based collection for a single OU and it works perfectly fine, tried to edit the query and made it to grab the data off 2 organisational units, but it fails and doesn't collect grab machines. I have removed the extra bit I have added to the query and the collection...

Hi There, Thank you for your wonderful guides which helped me deploying Office 2013 Pro Plus. I was looking for a collection query that will show me all computers with Office 2013 installed. Currently I am using this: select...

Hi Again, I have a query question again. I have 2 laptops that I am testing with in my lab environment. Laptop 1: dell latitude e6520 Laptop 2: hp probook 6560b WMI Query in Apply Driver Package for the 2 above: SELECT * FROM Win32_ComputerSystem WHERE Model LIKE '%Dell Latitude E6520%'...

Hi There, I have tried various wmi queries to target hyper-v virtual machines only with no luck select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join...

Hi, I'm trying to get a report for the different internet browsers our machines have and I havent been able to. The Report is showing in the asset list where I placed it but when I run it, it comes up with no results. i have also enabled Software inventory and added iexplorer.exe as a file...

hi Prajwal how are you I want create a collection of the clients having ms office 2010 (including outlook, excel, power point, word 2010) can you send me query

Can someone help me create a collection query to get a list of all PC's that have office 2016 (Click to Run version) installed?

This is using SCCM 2012 r2. I am a newbie to the reports. I want to create a report to show all the computer's program in add/remove programs for a collection of computers. How to create it, step-by-step or showing the SQL statement? Thanks

Hi, Please let us know the solution for the Below error while creating the Device Collection it happens on Query/Direct rule.. Thanks and Regards James A

Hi how to create sccm query for windows 10 collection ?. Is it one query for all windows 10 or separate one ?.