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