|
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
|
|
|