SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

Adding Display name to "All Systems" query

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

Published Feb 20 2009, 10:52 AM by Garth
Filed under: , ,

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems