Advertisements, Programs and Main User of all PC

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

Leave a Reply

Your email address will not be published. Required fields are marked *