SMS reports

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Reporting 101? (101?_at_discussions.microsoft.com)
Date: 01/26/05 

Date: Wed, 26 Jan 2005 13:19:03 -0800

Does anybody know how or if it's possible to replace the User_Name0 with
Full_User_Name0 from the query below?

select SYS.Netbios_Name0, User_Name0, SF.FileName, SF.FileVersion,
SF.FileModifiedDate, SF.FilePath
>From v_GS_SoftwareFile SF
join v_R_System SYS on SYS.ResourceID = SF.ResourceID
Where SF.FileName LIKE @variable

ORDER BY SYS.Netbios_Name0