Patricia this is the qeury we use...
select distinct sys.Name, sys.LastLogonUserName, sys.OperatingSystemNameandVersion, sys.ResourceId, sys.ResourceType, swfile.FileName, swfile.FileSize from SMS_G_System_SoftwareFile as swfile inner join SMS_R_System as sys on sys.ResourceId =...