select
r.Name,
r.SMSAssignedSites,
r.IPAddresses,
r.IPSubnets,
r.OperatingSystemNameandVersion,
r.ResourceDomainORWorkgroup,
ru.name,
r.LastLogonUserDomain,
r.LastLogonUserName,
r.SMSUniqueIdentifier,
r.ResourceId,
r.ResourceType,
r.NetbiosName
from
sms_r_system r,
sms_r_user ru
Where
r.LastLogonUserDomain = ru.WindowsNTDomain
and r.LastLogonUserName = ru.UserName
Recent Comments