SELECT
A
.AdvertisementName,
A
.ProgramName,
R
.Netbios_Name0 as Computername,
SCUM
.TopConsoleUser0 as MainUsername FROM
dbo
.v_R_System_Valid R join dbo.v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM on R.ResourceID = SCUM.ResourceID join dbo.v_ClientAdvertisementStatus CAS on R.ResourceID = CAS.ResourceID join dbo.v_Advertisement A on A.AdvertisementID = CAS.AdvertisementID