Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Query to link user's full name with system details

Query to link user's full name with system details

Query to link user's full name with system details

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.

RE: Query to link user's full name with system details

Have you tried building a query by right clicking on the Queries node in the Admin Console, and selecting All Tasks...New Query?  This allows you to build one to your specification relatively easy without knowledge of SQL.

Basically, you would click on the dialog boxes and select the User tables and the System tables and show what fields you want.

With a little investigation of SQL (a book, a web site etc.), you can join these tables more fluently giving you a great deal of control over your reports.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close