[mssms] Query assistance

[Enley, Carl]

I need help writing a query that will allow me to pull the primary user and the 
mail0 attribute for each machine in a collection. I need to communicate with a 
group of users about an anticipated software update and it would be great if I 
could add all of the machines to a collection run a query against it to pull 
the email address for the primary device user. I could then just export the 
results and copy the email address into Outlook for the communication.

I do have the email address being discovered and UDA turned on and working, CM 
1702 if it matters.

Thanks

[mssms] Query Assistance

[Boseman, Marcia H - Raleigh, NC]

Does anyone have a SQL query or SCCM 2012 report that would show all windows 10 
machines that became new clients on a daily basis?