Hi, I'm looking for a query to link two classes sms_r_system and sms_r_user but I don't quiet know how. You know the standard ALL SYSTEMS query which shows lastlogonuser name, system name, ip address etc...(which are all from object type sms_r_system). Well I also want to have a heading with the user's full name (which is basically another object type sms_r_system). In short I want to be able to see the user's full name (not logon name) along with system details.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.