Lookup User in SCCM and systems user have been log in on. 0 /ConfigMgr_P01/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602} None efb25c8b-ee4e-4b48-aed0-ae77634aecc9 DataSource1 =Parameters!username.Value select top 10 s.ResourceID ,S.Name0 System ,OS.Caption0 'Operating System' ,Last_Logon_Timestamp0 as LastLogonDay ,S.User_Name0 UserID ,(select top 1 C.Name from v_FullCollectionMembership M left join v_Collection C on C.CollectionID = m.CollectionID where M.ResourceID = s.ResourceID and c.Name like 'Site - %' ) Site ,U.Full_User_Name0 'User Name' ,U.Mail0 eMail from v_R_System S Left Join v_R_User U on u.User_Name0 = S.User_Name0 left join v_GS_OPERATING_SYSTEM OS on os.ResourceID = S.ResourceID --where S.Name0 = 'zabevspr5273d' --where s.User_Name0 = 'dngc006' where s.User_Name0 = @username Order by s.Last_Logon_Timestamp0 desc true System System.String ResourceID System.Int32 LastLogonDay System.DateTime Operating System System.String UserID System.String Site System.String User Name System.String eMail System.String DataSource1 =Parameters!User.Value select distinct U.User_Name0 from v_R_User U where U.User_Name0 not like '$%' and U.User_Name0 like ( '%' + @User + '%') User_Name0 System.String 39.2875mm 40.875mm 54.89791mm 54.89791mm 6mm true true Known Computer Systems Textbox1 #69be28 2pt 2pt 2pt 2pt 4 6mm true true Date #69be28 2pt 2pt 2pt 2pt true true System Name #69be28 2pt 2pt 2pt 2pt true true Operating System #69be28 2pt 2pt 2pt 2pt true true Site #69be28 2pt 2pt 2pt 2pt 6mm true true =Fields!LastLogonDay.Value 2pt 2pt 2pt 2pt true true =Fields!System.Value 2pt 2pt 2pt 2pt true true true =Fields!Operating_System.Value 2pt 2pt 2pt 2pt true true =Fields!Site.Value 2pt 2pt 2pt 2pt After After Computers 31.93194mm 0mm 18mm 189.95832mm 39.2875mm 95.77291mm 6.08542mm true true User Information Textbox3 #69be28 2pt 2pt 2pt 2pt 2 6mm true true User ID #69be28 2pt 2pt 2pt 2pt true true =Fields!UserID.Value 2pt 2pt 2pt 2pt 6mm true true User Name #69be28 2pt 2pt 2pt 2pt true true =Fields!User_Name.Value 2pt 2pt 2pt 2pt 6mm true true User email #69be28 2pt 2pt 2pt 2pt true true =Fields!eMail.Value 2pt 2pt 2pt 2pt Computers 2.3495mm 0mm 24.08542mm 135.06041mm 1 53.10694mm 226.86459mm 14.55208mm true true true true User lookup Textbox13 0mm 39.2875mm 11.64167mm 133.47291mm #69be28 2pt 2pt 2pt 2pt 25.05mm true true true true Please note: Blank means no data availible. The date is the last known logon. Some deviations are expected. 2pt 2pt 2pt 2pt 297mm 210mm 20mm 20mm 20mm 20mm 0.13cm