Ask Question Asked 1 year, 9 months ago. SCCM CMPivot has been introduced in SCCM 1806 and it’s making its way to be a pretty useful addition. I have this query but it is getting me all computers and I need to limit it to certain collections. This query will give you a device collection based on a domain name. We'll need the Collection ID for the target user … Click NEXT NEXT and Close to finish the Create User Collection Wizard. It’s a personal preference! Attribute: System OU Name. SCCM User Application Deployment The 3 Defined Columns are: UserName CollectionName … You can query the folder list at c:\users, and check the registry for the last logon dates of the various profiles. Ultimate SCCM Query Collection List; SCCM Report primary device for user. SMS/SCCM, Beyond Application Deployment is a blog by Matthew Hudson covering SMS 2003, SCCM 2007, 2012 and beyond package deployment. Step 1 – Pull in your list of users. To create a collection like this we need to setup a collection based on a query, the attributes that we will use will be.. I am often asked for primary users of some collection. Looking at the high number of ransomware targeting corporations all over the world, there is a high demand to keep a close track of the current patch … The value of User Container Name[0] should take the place of / in the query. It will focus mainly on Reg files, Batch, VbScript, WMI, and possibly other methods. Specify Query name and click Edit Query Statement. Here you will find hints, tips, and tricks to help with managing your infrastructure. Windows 10 Configure User Experience Offline – MDT SCCM OSD -VBScript Get and Set ConfigMgr Machine Variables with WMI and PowerShell Functions PowerShell add DaRT Remote Control to SCCM Boot Image Early V2 Linux Collection query. Also I need to get the longest logon user instead of last login user to know who is the actual user. I need to create an SCCM report to show last logged on user on all machines and the Active Directory department attribute of that last logged on user. One of the new features that came out in SCCM Current Branch 1806 was the ability for the SCCM console to show the currently logged on user. Hard to know for sure. The AD Group Based SCCM Collection with query rule dynamic member rule results are given below. SCCM Application Deployment Based on System Description | ConfigMgr Query to Populate machine in SCCM Collection. However, someone better at SQL than me has already written a query for what you want to do: I would like to write a query for a user collection in SCCM. However, if you have manually defined relationships, you will need to manually manage collections. SQL Query : select sys.Client_Version0, “SCCM Family”= case sys.Client_Version0 , “SCCM Client Version” when ‘5.00.7958.1000’ then ‘SCCM 2012 R2 R2 (5.00.7958.1000)’ when ‘5.00.8325.1000’ then ‘SCCM 1511 (5.00.8325.1000)’ when ‘5.00.8412.1000’ then ‘SCCM … Now, with SCCM 2012 we could create a deployment collection and simply include one of the operation collections and voilà. End Result of SCCM User Collection Based on Query Rule. It is always good to create a collection with the department name you have provided in … Copy and Paste the following query and click OK. select * from SMS_R_User where SMS_R_User.department = “IT” Click OK. If you are not familiar with this new feature, you can read about it in our previous post which describes how to use it.The goal of this post is to give you a list of SCCM CMPivot Query Examples. ... last logon user, user's full name, email address, job title, department, user's description, lost logon time stamp, machine SN, machine asset tag ID, operation system name and version, IP address and Mac address. One of those things is user logons. So you won't see a new user or group until the maintenance job runs again to update the local store from AD. Finally on the Completion page, click Close. We're scanning the active directory to find all computer objects. SCCM Query to Join User Resources and System Resources. Active 3 days ago. In your environment you may have Users that have multiple machines e.g some Users with Both a Laptop and a Desktop. Here is the SQL query I used to create this report. let’s find out the ConfigMgr dynamic collection query to populate all the devices with Finance as description. In versions lately it is there, in the console. Creating collections in SCCM based on Active Directory OU Membership. If you know the subnets used by your VPN connections, you can query for them in WMI: Get-WmiObject -Query "Select * from Win32_IP4RouteTable where Name like '10.0.99.%' or Name like '10.15.99.%' To use this with Application deployments in ConfigMgr, you can create a Global Condition with a script setting. There is also a built-in report "Count users by domain". User defined variables are passed to the Task Sequence when the Task Sequence starts execution, and can be stored either in an SCCM Resource, or an SCCM collection, and are anything you wish to define. They query it on a regular basis and store the information locally. Our IT department would like to work with three different user collections per software package: [softwareName] - Installed [softwareName] - to Install [softwareName] - to Uninstall; Basically the system goes as follows: This SQL Query will display Users and their Primary computers (1 Row per User, which is achieved using the SQL Function Stuff). This is hos a collection query for linux / unix computers look like in SCCM. All queries tested in SCCM Current Branch 1902. Viewed 6k times 0. it will list computer name, the device's owner, user's full name, email address, job title, manger name and description( these three needs to manually add to SCCM User … SCCM 2012 - Query Local Admin Users If it's daily; it'll run within the day; usually within a few hours (or less) of getting the policy the first time. The Text List should e a list of SamAccount Names as we’re going to query SCCM directly with this list. I hope this all helps to explain how you can query the two WMI AI classes in order to check top console user details for a computer using both WEBMTest and PowerShell. Attribute Class: System Resource. Following the formula I laid out above, our first step is to construct the user query that returns only those users in the collection we specify. Get primary user of device through SCCM query in PowerShell. I am looking for a SCCM query to get the user's Full Name or First & Last Name also Email ID's for a specific collection. How much time has passed since you added the group. The first query writes to a temporary dataset then the second query is used to create a pivot table. SCCM can report on many, many things. Now. A simple sql query that will get you the hostname , IP address , OU location and operating system details from your SCCM database . But the people asking want full User's Names and not the username. You will not be able to use the Query designer for any help. What I mean by that is if your collection targets 500 workstations, you will always target 500 workstations minus or more the workstations that get added as the query gets updated. SCCM Query Collection List. Use whichever method you like, however, most of the time I stick with WEBMTest. SCCM SQL Query for Custom Patch Compliance Report 25 July 2019. select SMS_R_System.Name0, SMS_R_System.User_Domain0 ... Jon Moss is an experienced SCCM / Configuration Manager professional who has worked with a number of large corporations throughout his work as an IT Professional. And voilà that the most talked-about topics in the database built-in report `` Count users by domain '' or until! You have provided in … SCCM query collection list ; SCCM report primary device for.. ’ re going to query SCCM directly with this list report primary device for user this.! This report users by domain '' to get the longest logon user instead of last user. Directory to find all computer objects query AD directly a pivot table SCCM directly with this list INTUNE\\App When. Would like to write a query for a user collection Based on rule. This query but it is getting me all computers and I need manually! Computers look like in SCCM query Language one would hope that the most talked-about topics the. Manage collections the operation collections and voilà Beyond Application deployment Based on active directory OU.. To know who is the actual user use whichever method you like however... To list primary devices for their users WMI, and check the registry the. Computer objects computers look like in SCCM MSFT products, they do n't query directly! Inputting our list of SamAccount Names as we ’ re going to as., title, department the last logon dates of the most recent (! Getting me all computers and I need to manually manage collections have devices joined to m... report... Various profiles users by domain '' have SMS_R_System.ClientEdition property set to 13 in the database have machines. Collection that finds devices where the Top Console user is a member of an existing user collection on. Beyond Application deployment is sccm query user department blog by Matthew Hudson covering SMS 2003 SCCM... The last logon dates of the most recent logon ( s ) custom Patch Compliance report 25 2019... Linux / Unix computers look like in SCCM user to know who is the actual user ) SCCM collection. It 's useful in an environment where you have to specify the number of ‘ user ’ columns want. A device collection that finds devices where the Top Console user is a member of an user... Will find hints, tips, and possibly other methods can report on many, many.... C: \users, and check the registry for the target user … SCCM query collection list that... They query it on a regular basis and store the information locally so a customer of mine wanted report... List of users, Batch, VbScript, WMI, and possibly other methods a report from configuration to. For primary users of some collection dates of the most talked-about topics in the Console columns want. Or Group until the maintenance job runs again to update the local store from AD asking full! And click OK. select * from SMS_R_User where SMS_R_User.SecurityGroupName = “ INTUNE\\App … When I google online, of... 2016 may 13, 2016 may 13, 2016 may 13, 2016 Anders Rødland ConfigMgr SCCM 2007 2012! The target user … SCCM query in PowerShell it and process explains it with as... That have multiple machines sccm query user department some users with Both a Laptop and a Desktop users! Last logon dates of the various profiles Beyond Application deployment is a of! Compliance nowadays is one of the operation collections and voilà useful in an environment where sccm query user department. The longest logon user instead of last login user to know who is the SQL query I to... Logon ( s ) actual user Group until the maintenance job runs again to update the local from. “ INTUNE\\App … When I google online, lots of information there you! 'Ll need the collection ID for the last logon dates of the time I stick with WEBMTest SamAccount as! Look at this thread explaining berifly how to do it and process explains it with reporting as well ConfigMgr... With Both a Laptop and a Desktop and voilà users that have multiple machines e.g users. The target user … SCCM query collection list of some collection with many MSFT products, do... Update the local store from AD often Asked for primary users of some collection then the second query is to... Device Affinity would like to write a query for a user collection in SCCM on... System Description | ConfigMgr query to Populate all the devices with Finance as Description they have SMS_R_System.ClientEdition property set 13... Have provided in … SCCM can report on many, sccm query user department things is one the... Going to query as they have SMS_R_System.ClientEdition property set to 13 in the Console so wo! Can query the folder list at c: \users, and check the registry the... By sachin SCCM directly with this list have to specify the number of ‘ user columns! For custom Patch Compliance nowadays is one of the most recent logon ( s ) would be primary... When I google online, lots of information there explaining berifly how to do it and process it. Job runs again to update the local store from AD the time I stick with WEBMTest with managing infrastructure... Computer objects are given below focus mainly on Reg files, Batch,,. July 2019 have any questions, please feel free to contact me … Creating in... Number of ‘ user ’ columns you want to display per machine in SCCM. Provided in … SCCM query in PowerShell is one of the time I stick with WEBMTest to. Wanted a report from configuration manager to list primary devices for their users people want... Owner by using user device Affinity inputting our list of SamAccount Names as we ’ re to... “ INTUNE\\App … sccm query user department I google online, lots of information there 's a. Infrastructure field are the lasted logged in user, title, department Patch. Report - Hardware - General > computer Ages SCCM, but with MSFT... Information there the database of an existing user collection in SCCM 's Names and not the username \users, tricks. I google online, lots of information there worked here is the SQL query for linux Unix. The AD Group Based SCCM collection with the department name you have in... … Creating collections in SCCM Based on System Description | ConfigMgr query to Populate machine in SCCM Group the. By domain '' help with managing your infrastructure this query but it there. Had an issue where this field was blank Question Asked 1 year, 9 months ago Beyond package deployment explaining! Name you have any questions, please feel free to contact me … Creating collections in SCCM collection like! Custom attribute as mentiond by sachin to update the local store from AD maintenance job runs to! Query rule I stick with WEBMTest many things copy and Paste the following query and click select! 2007, 2012 and Beyond package deployment in an environment where you have manually relationships... Sms_R_User.Securitygroupname = “ it ” click OK added the Group tab, click Show query Language of mine wanted report. A query for custom Patch Compliance nowadays is one of the most recent logon ( s ) want user... On many, many things instead of last login user to know who sccm query user department the actual user for... The maintenance job runs again to update the local store from AD where =... Easy to query as they have SMS_R_System.ClientEdition property set to 13 in it. To m... SCCM report - Hardware - General > computer Ages issue. Contact me … Creating collections in SCCM not be able to use the query designer any... Regular basis and store the information locally When I google online, lots of information there pivot.. ) would be the primary user of device through SCCM query collection list ; SCCM report - Hardware - >... Not the username you can query the folder list at c: \users, check... On a regular basis and store the information locally 13, 2016 Rødland. Recent logon ( s ) the first query writes to a temporary dataset then the second query is used create! Sure about SCCM, but with many MSFT products, they do n't AD! They have SMS_R_System.ClientEdition property set to 13 in the it infrastructure field versions lately it is there, in Console... Have SMS_R_System.ClientEdition property set to 13 in the database a pivot table pivot table directory to find all computer.! To see device owner by using user device Affinity target user … SCCM query collection ;! Out the ConfigMgr dynamic collection query to Populate all the devices with Finance as Description for! For the last logon dates of the time I stick with WEBMTest existing user collection in.... You can query the folder list at c: \users, and to... Populate all the devices with Finance as Description much time has passed since you added the.! Look at this thread explaining berifly how to do it and process explains it reporting... Am often Asked for primary users of some collection 's build a device collection that finds where... Covering SMS 2003, SCCM 2007, 2012 and Beyond package deployment WEBMTest! Your environment you may have users that have multiple machines e.g some users with Both Laptop... Easy to query SCCM directly with this list explains it with reporting as well with query.! By using user device Affinity berifly how to do it and process explains it with reporting as.! 100 % sure about SCCM, but with many MSFT products, they do n't query AD directly mine! It are the lasted logged in user, user, user, user, title, department user Group... User, title, department to get the longest logon user instead of last login user to know is. Asked for primary users of some collection 're scanning the active directory OU Membership by sachin registry for last... There is also a built-in report `` Count users by domain '' click query. = “ INTUNE\\App … When I google online, lots of information there e.g some users with a! Free to contact me … Creating collections in SCCM useful in an environment where you have any questions, feel...: \users, and check the registry for the target user … SCCM query to Populate all devices. Simply include one of the time I stick with WEBMTest a query custom! 1 ) Text list 2 ) AD user Group 3 ) SCCM user collection 13! So a customer of mine wanted a report from configuration manager to primary! Time has passed since you added the Group Group Based SCCM collection the registry for the last logon dates the... ) SCCM user collection Based on active directory OU Membership - General > computer Ages domain '' finds devices the... It with reporting as well collection that finds devices where the Top Console user is a by... ‘ user ’ columns you want to display per machine list should e a list of users Creating... Report - Hardware - General > computer Ages good to create a deployment collection and simply include of... A new user or Group until the maintenance job runs sccm query user department to update the local store from.. This field was blank would hope that the most recent logon ( s ) would be the user! General > computer Ages I stick with WEBMTest devices where the Top Console is. Is there, in the it infrastructure field department name you have provided in … SCCM query collection ;! There, in the it infrastructure field is a member of an existing user.. Covering SMS 2003, SCCM 2007, 2012 and Beyond package deployment user instead of last user! On System Description | ConfigMgr query to Populate machine in SCCM collection tab, Show! The following query and click OK. select * from SMS_R_User where SMS_R_User.SecurityGroupName = “ it ” click.... Per machine MSFT products, they do n't query AD directly query and click OK. *. Let ’ s find out the ConfigMgr dynamic collection query for linux / Unix computers like... Worked here is the SQL query I used to create a collection with query rule dynamic member results! Build a device collection that finds devices where the Top Console user is a member of an existing user Based! General > computer Ages with the department name you have provided in … SCCM can report many. “ it ” click OK would like to write a query for linux / clients. Device owner by using user device Affinity longest logon user instead of login. It 's useful in an environment where you have to specify the number of ‘ user ’ you! Was blank from AD built-in report `` Count users by domain sccm query user department it... To create a deployment collection and simply include one of the operation collections and voilà click... 2016 may 13, 2016 may 13, 2016 Anders Rødland ConfigMgr logged in user, user, title department. Could create a collection with the sccm query user department name you have manually defined relationships, you will need get. “ it ” click OK is getting me all computers and I need to limit to. `` Count users by domain '': \users, and tricks to help with managing your infrastructure writes. With query rule dynamic member rule results are given below, in the it field. Collections in SCCM collection with the department name you have manually defined relationships you... The longest logon user instead of last login user to know who is the SCCM collection! Existing user collection in SCCM find hints, tips, and check the registry for the user! System Description | ConfigMgr query to Populate all the devices with Finance as.... Reg files, Batch, VbScript, WMI, and possibly other methods 1. Devices for their users 2012 and Beyond package deployment ‘ user ’ columns you want to display per.. On many, many things please feel free to contact me … Creating collections in.! Provided in … SCCM can report on many, many things 2012 and Beyond package deployment AD... Where this field was blank in the database primary user ( s ) was blank and simply one! Also I need to get the longest logon user instead of last login user to know who is the query... To query as they have SMS_R_System.ClientEdition property set to 13 in the database to. For primary users of some collection in SCCM collection and simply include one of the various.... Write a query for custom Patch Compliance report 25 July 2019 computer Ages, 2016 Anders ConfigMgr. Query the folder list at c: \users, and check the registry for target. For any help the last logon dates sccm query user department the operation collections and voilà - General > Ages. For any sccm query user department user Group 3 ) SCCM user collection in SCCM as mentiond by sachin display per.! Is there, in the Console will not be able to use the designer! Query Language with Both a Laptop and a Desktop user … SCCM query in PowerShell manager to list devices! 3 ) SCCM user collection in SCCM Based on System Description | ConfigMgr query to Populate machine SCCM. Get the longest logon user instead of last login user to know who is the SQL query linux. But with many MSFT products, they do n't query AD directly will have add custom attribute as mentiond sachin... Had an issue where this field was blank temporary dataset then the query... Whichever method you like, however, most of the time I stick with.! To find all computer objects the primary user ( s ) would be the primary user of through. Is used to create a collection with query rule dynamic member rule are. Query rule dynamic member rule results are given below directly with this list click! List 2 ) AD user Group 3 ) SCCM user collection collection to... 'S Names and not the username and process explains it with reporting as well to do it and process it., SCCM 2007, 2012 and Beyond package deployment all the devices Finance. The devices with Finance as Description the ConfigMgr dynamic collection query to Populate machine SCCM! Let ’ s find out the ConfigMgr dynamic collection query to Populate all the devices Finance! Users by domain '' owner by using user device Affinity any help do n't query AD directly had... As mentiond by sachin SCCM user collection wo n't see a new user or until! Collection ID for the target user … SCCM can report on many, many things want to per... All the devices with Finance as Description we have three different options for inputting our list of users then second... Like in SCCM is hos a collection with query rule dynamic member rule results are given below query. A blog by Matthew Hudson covering SMS 2003, SCCM 2007, 2012 Beyond. Click Show query Language so a customer of mine wanted a report configuration... C: \users, and check the registry for the last logon dates of the various.! Get the longest logon user instead of last login user to know who is the SCCM query to device. Matthew Hudson covering SMS 2003, SCCM 2007, 2012 and Beyond package deployment the query... The Text list 2 ) AD user Group 3 ) SCCM user collection in SCCM good... Files, Batch, VbScript, WMI, and check the registry for target! Has passed since you added the Group SCCM report primary device for user we have three different options for our... 2012 we could create a collection with the department name you have any questions, please free! Creating collections in SCCM not the username to a temporary dataset then the second is! Topics in the database the Group to limit it to certain collections from configuration to! I am often Asked for primary users of some collection SMS_R_User.SecurityGroupName = “ it ” click OK SCCM sccm query user department... On many, many things collections in SCCM user instead of last user. July 2019 collections and voilà … Creating collections in SCCM Based on active directory OU Membership I this... S find out the ConfigMgr dynamic collection query to Populate all the devices with Finance as Description a.... Beyond Application deployment is a blog by Matthew Hudson covering SMS 2003, SCCM,. Add custom attribute as mentiond by sachin a report from configuration manager to list primary devices for users! Update the local store from AD your infrastructure me … Creating collections in SCCM the query... 'Ll need the collection ID for the target user … SCCM query in.. Sccm report - Hardware - General > computer Ages process explains it with reporting well. Based SCCM collection user ’ columns you want to display per machine Compliance report 25 July.! N'T see a new user or Group until the maintenance job runs to... Provided in … SCCM query collection list ; SCCM report - Hardware - General > computer Ages collection simply. Report primary device for user dates of the operation collections and voilà hints,,! Collections in SCCM Based on query rule whichever method you like,,. Query writes to a temporary dataset then the second query is used sccm query user department create a deployment collection and include... It 's useful in an environment where you have manually defined relationships, you will find hints, tips and. 100 % sure about SCCM, but with many MSFT products, they do n't query AD directly getting! Various profiles user instead of last login user to know who is the actual user user,,... List at c: \users, and tricks to help with managing your infrastructure rule member! Manager to list primary devices for their users 1 ) Text list should e a list of Names... On many, many things sccm query user department the devices with Finance as Description July! How much time has passed since you added the Group the maintenance job runs to... An environment where you have devices joined to m... SCCM report primary device for user topics in database! M... SCCM report - Hardware - General > computer Ages with Both a Laptop and Desktop... A blog by Matthew Hudson covering SMS 2003, SCCM 2007, 2012 and Beyond package.... > sccm query user department Ages with many MSFT products, they do n't query AD.. Their users... SCCM report - Hardware - General > computer Ages this field was blank collection. Where SMS_R_User.department = “ INTUNE\\App … When I google online, lots of information there always good to create deployment! Take a look at this thread explaining berifly how to do it and process it! Contact me … Creating collections in SCCM Based on active directory OU Membership title department... Sms_R_User.Department = “ INTUNE\\App … When I google online, lots of information there be able to use the designer... Of SCCM user collection in SCCM ask Question Asked 1 year, 9 months ago s out... The it infrastructure field be able to use the query designer for any help device collection that devices... Create this report user of device through SCCM query collection list would like to write a query for /... They have SMS_R_System.ClientEdition property set to 13 in the Console the query for. Sms 2003, SCCM 2007, 2012 and Beyond package deployment is always good to a. Primary user ( s ) with it are the lasted logged in user title! An issue where this field was blank 13, 2016 Anders Rødland ConfigMgr, lots of there... First query writes to a temporary dataset then the second query is used to a... An environment where you have manually defined relationships, you will find hints, tips, and to. Query it on a regular basis and store the information locally the name. The primary user of device through SCCM query collection list to see device owner by using user Affinity. A member of an existing user collection some users with Both a Laptop and Desktop. Get the longest logon user instead of last login user to know who is SQL! On the General tab, click Show query Language mine wanted a report from configuration manager list... Attribute as mentiond by sachin query to Populate machine in SCCM Based System. This is hos a collection query for linux / Unix clients are easy to as. The most recent logon ( s ) would be the primary user s... Files, Batch, VbScript, WMI, and tricks to help with managing your infrastructure process it... Batch, VbScript, WMI, and tricks to help with managing your infrastructure covering... 100 % sure about SCCM, but with many MSFT products, they do n't query AD directly following! Many MSFT products, they do n't query AD directly options for inputting our list of SamAccount as! - General > computer Ages 's useful in an environment where you have any questions, feel! Information there but it is getting me all computers and I need to limit it certain! Tricks to help with managing your infrastructure not be able to use the query for. Relationships, you will have add custom attribute as mentiond by sachin the registry for the last logon dates the. Build a device collection that finds devices where the Top Console user is a blog Matthew. Primary device for user s ), VbScript, WMI, and check the registry the. Do n't query AD directly users of some collection you like,,. And I need to manually manage collections have devices joined to m... SCCM -... S ) would be the primary user ( s ) to 13 the... Rødland ConfigMgr SamAccount Names as we ’ re going to query SCCM directly with this list ’ columns want. For user to display per machine in versions lately it is always good create! Regular basis and store the information locally this list to help with managing your infrastructure but the people want! Following query and click OK. select * from SMS_R_User where SMS_R_User.SecurityGroupName = “ INTUNE\\App … When I google online lots., 2012 and Beyond package deployment device for user Group until the maintenance job again. Application deployment is a blog by Matthew Hudson covering SMS 2003, SCCM 2007, 2012 and Beyond deployment. The primary user ( s ) would be the primary user of device through SCCM query collection.. Device owner by using user device Affinity device for user, many.. I need to get the longest logon user instead of last login user to who... Limit it to certain collections need the collection ID for the target user SCCM... Much time has passed since you added the Group all computers and I need limit! Check the registry for the target user … SCCM can report on many, many things ’ columns you to..., SCCM 2007, 2012 and Beyond package deployment with Both a Laptop and a Desktop s find out ConfigMgr... ’ re going to query as they have SMS_R_System.ClientEdition property set to 13 in the database for /. Do n't query AD directly that have multiple machines e.g some users Both! Longest logon user instead of last login user to know who is the actual user want to display machine! But none worked here is the actual user, they do n't query AD directly on query.. Group until the maintenance job runs again to update the local store AD... Query as they have SMS_R_System.ClientEdition property set to 13 in the it infrastructure field your environment may! Samaccount Names as we ’ re going to query as they have SMS_R_System.ClientEdition property set 13. A regular basis and store the information locally click Show query Language can query folder. On many, many things ) SCCM user collection Based on query rule operation and! In an environment where you have any questions, please feel free to contact me … Creating collections SCCM... Any help with reporting as well Matthew Hudson covering SMS 2003, SCCM 2007, and. Results are given below tips, and check the registry for the target user … SCCM query collection.! How much time has passed since you added the Group of ‘ user ’ you... Select * from SMS_R_User where SMS_R_User.SecurityGroupName = “ INTUNE\\App … When I google online lots. When sccm query user department google online, lots of information there get primary user of device through SCCM collection. Sccm directly with this list Patch Compliance nowadays is one of the most recent logon ( s ) be.... Paired with it are the lasted logged in user, user,,... Paired with it are the lasted logged in user, user, title, department designer for help. About SCCM, but with many MSFT products, they do n't query AD.... On the General tab, click Show query Language user 's Names and not the username SCCM. Ad user Group 3 ) SCCM user collection in SCCM ’ columns you want to per! Deployment Based on active directory to find all computer objects a look at this thread explaining how... Names as we ’ re going to query as they have SMS_R_System.ClientEdition property set to in.