Configuration Manager Last Logon User Name To Full Name Unspecified WQL Scripting

 

Here you will find examples of how to create Configuration Manager <unspecified> Console WQL queries to return users full names as well as their Login ID name.

 

All Users And All Machines

Select

S.Name,

U.UserName,

U.FullUserName

From SMS_R_System S, SMS_R_User U

Where S.LastLogonUserName = U.UserName

 

Prompts For Full Name

Select

S.Name,

U.UserName,

U.FullUserName

From SMS_R_System S, SMS_R_User U

Where S.LastLogonUserName = U.UserName

And FullUserName = ##PRM:SMS_R_User.FullUserName##

 

Prompts For Logon Name

Select

S.Name,

U.UserName,

U.FullUserName

From SMS_R_System S, SMS_R_User U

Where S.LastLogonUserName = U.UserName

And UserName = ##PRM:SMS_R_User.UserName##

 

Prompts For Machine Name

Select

S.Name,

U.UserName,

U.FullUserName

From SMS_R_System S, SMS_R_User U

Where S.LastLogonUserName = U.UserName

And Name = ##PRM:SMS_R_System.Name##

 

 

Published Sunday, July 27, 2008 7:59 AM by dhite

Comments

No Comments