SELECT

adv

.AdvertisementName,

stat

.LastStateName,

adv

.Comment AS C072,

pkg

.Name AS C062,

adv

.ProgramName AS C071,

adv

.SourceSite,

adv

.AdvertisementID,

se

.SerialNumber0,

cs

.UserName0,

Stat

.LastAcceptanceStatusTime FROM

v_Advertisement adv

JOIN v_Package pkg ON adv.PackageID = pkg.PackageID JOIN v_ClientAdvertisementStatus stat ON stat.AdvertisementID = adv.AdvertisementID JOIN v_R_System sys ON stat.ResourceID = sys.ResourceID join dbo.v_GS_SYSTEM_ENCLOSURE se on se.ResourceID = sys.ResourceID join dbo.v_GS_COMPUTER_SYSTEM cs on cs.ResourceID = sys.ResourceID

WHERE

sys.Netbios_Name0

=@ComputerName