[mssms] Re: Adding last logged on user to query

Awesome! Thanks! From: listsad...@lists.myitforum.com <listsad...@lists.myitforum.com> on behalf of James Massardo <jmassa...@jackhenry.com> Sent: Wednesday, June 29, 2016 9:01:47 AM To: mssms@lists.myitforum.com Subject: [mssms] RE: Adding last lo

[mssms] RE: Adding last logged on user to query

Looks like you need an INNER JOIN for v_R_system. SELECT arp.DisplayName0 AS [Application Name], arp.Version0 AS [App Version], GSCS.Name0 AS [Machine Name], GSCS.Manufacturer0 AS [Manufacturer Name], GSCS.Model0 AS [Machine Model], RSYS.User_Name0