Question: How can I create collections that contain system names for every user belonging to certain companies or departments as defined in AD. Situation: AD system discovery enabled AD User discovery enabled - Three fields, employee ID, department and company have been added in the AD attribute tab for the discovery. These fields are populated in AD and the information is in SCCM for ALL user collection. Challenge: When creating collections or queries, records that are available under user resources can’t be linked to records available for system resources. How can I combine fields recorded under two different discovery methods? I have tried using system resources to accomplish this, that is, to look for system by last logon user, however, last logon user is not reliable since users can log to multiple machines.

You can enable asset intelligence and use "top console user" to create the collection you described. See http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/2d7d29fe-9c8e-43a3-9ec9-5f8fc9f2bbf9

Unfortunately you can't query accross resource types. So unless you can get the departmental info to show up in the computer registry or wmi I don't believe this is feasible. One plan of action could be to advertise a script that looks at the top console user per system and search ad for the departmental info to write it to wmi for later collection by hardware inventory."Everyone is an expert at something" Kim Oppalfens Configmgr expert for lack of any other expertise. http://www.scug.be/blogs/sccm

You can do it several ways, none is easy. See if one of these will help you. Query only [Object Type:<unspecified>: select SMS_R_User.Name,SMS_R_System.LastLogonUserName,SMS_R_System.Name, SMS_G_System_WORKSTATION_STATUS.LastHardwareScan,SMS_G_System_COMPUTER_SYSTEM.UserName,SMS_R_User.title , sms_r_user.department from SMS_R_System inner join SMS_R_User on SMS_R_User.Username= SMS_R_System.LastLogonUserName inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceId Collection of Computers based on a user: select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.UserName in (select UniqueUserName from SMS_R_User where UserOUName = "xxxx /SECURITY USERS & GROUPS” ) http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

Unfortunately you can't query accross resource types. So unless you can get the departmental info to show up in the computer registry or wmi I don't believe this is feasible. Why not add the department info into user disc as a custom attribute then do a subselect? John Marcum | http://myitforum.com/cs2/blogs/jmarcum |