Query to link user's full name with system details 1

[cailin]

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.

 

[Schoenberg]

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.