Hi,

I 'd need to have a query on a computercollection = pc's and their users.
I have a query which shows computers and their last logged on user but I'd like to have their full AD name.

F.e. now in report: PC1 ALicoln

What I would like to have: PC1 Abraham Licoln

Please advise howto achieve this.

It's just a simple query limited to the targetted collection:

select SMS_R_System.Name, SMS_R_System.LastLogonUserName from  SMS_R_System

I don't think the AD full name (first name, last name and/or display name) are available within sccm. Not sure if we could make it appear, import it somehow(?)

What I have now is

select SMS_R_System.Name, SMS_R_System.LastLogonUserName from  SMS_R_System

how can I join that with

select SMS_R_User.FullUserName from  SMS_R_User?

Note does Active Directory discovery automatically discover the necessary attributes? It  doesn't seem to discover the DisplayName (it does discover

Thanks! When I look into a discovered account (SCCM) I cannot see any full name in a users "discovered data". When it is not there, how should sccm then be able to resolve it?

Thanks for the query but how should that translate into my query "select SMS_R_System.Name, SMS_R_System.LastLogonUserName from  SMS_R_System"?