Last logged on user name in report

[billybarty]

I am using this report to see which machines have XP SP1 installed on them and I would like to have the last logged on user name in the report but I don't know how to add it to the query. This is the query as it currently is:

Select SYS.Netbios_Name0, OPSYS.Caption0 as C054, OPSYS.Version0, OPSYS.CSDVersion0, OPSYS.InstallDate0, OPSYS.LastBootUpTime0, OPSYS.WindowsDirectory0, OPSYS.Description0
from v_R_System SYS
join v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID=OPSYS.ResourceID
where OPSYS.Caption0 like @os and IsNULL(OPSYS.CSDVersion0,'') like @sp
order by SYS.Netbios_Name0

 

[johnnyb99]

Use User_Name0 from v_R_System.