sccm query

Hello, I installed CMPivot standalone and I have these entities (first pic). Also when I take a look cmpivot docs on internet and supported entities on microsoft website, there are alot of different entities which I don't have (second pic). Even for example when I write Processor (microsoft says...

Hello everyone, I come here looking for help in refining some queries for my device groups in the SCCM console. Currently, I am looking to obtain different collections which would each group together each type of existing machine in my fleet. For example, I would like a collection for laptops...

Hey all, how can I create a query to check a registry key in SCCM 2211 ? I do not want to do this with Configuration Baseline or CM Pivot Thanks in advance

Hi, i have this query that list all devices with build number 1766 and have a similar that list devices with build 1706 (each on it is own collection). couldnt find a way to make one query for both builds in one collection. greatful for any help select...

Queries for Active Directory group membership are no longer working. It seems that we are no longer able to properly link user and device AD group membership data. This has always worked successfully in the past. We are connected to a SQL always on listener with 2 SQL servers. We are running...

I need a query which lists all devices based on device properties variables type "thin". Can someone help me?

Hello everyone, I'm new on the community, sorry for my bad English, im still learning yet. Recently i'm working with Asset Management department in a company that have almost 3000 devices, if someone have some tips in this area i will appreciate. I need to create a report to return all...

Hi Prajwal how are you doing ? is there any Query for windows 10 Client machines ? I use below Query to add Automatic Win 10 clients to Device collection , is it right one ? select...

Hi Prajwal I tried to add Query statement to add Client machines automatically to my specified device collection I use your Query from your blog but nothing has changed after I apply the setting I removed sccm client from client and tested but device collection not updates , see the screen...

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