Serial Number, User Information and installation dates of the software

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

Leave a Reply

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