I always reference these two blogs. Use them all the time. http://www.enhansoft.com/blog/where-to-find-user-name-data-in-configuration-manager-part-1 https://www.enhansoft.com/blog/where-to-find-user-name-data-in-configuration-manager-part-2
Daniel Ratliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Miriyala, Vasu Sent: Friday, April 21, 2017 9:52 AM To: mssms@lists.myitforum.com Subject: [mssms] win32_userprofile for User/Computer Mapping ! Hi, I see SCCM Admins try many options to find User ID of a computer, regular tables like v_r_system, v_gs_operating_system etc have accuracy problems. Win32_userprofile seems to be next best option, thought it has its own issues too. Like it shows more users per PC than intended etc., some confusion on refcount, loaded attributes on how best to add a logic with them Wanted to know if anyone successfully used this table to get data to satisfactory level, if so can you share query and suggestions pls Thanks, Vasu This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.