I always struggle with this... How to trim the domain\ off of of the user name here?
select vrs.Name0 as [Machine Name] , vru.Unique_User_Name0 as [User Name], vru.cn0 as [Full Name] from v_UsersPrimaryMachines upm left join v_R_User vru on upm.UserResourceID = vru.ResourceID left join v_R_System vrs on upm.MachineID = vrs.ResourceID where vru.Name0 IS NOT NULL order by vru.Name0 ________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
