Lookup a system in SCCM and shows last login data 0 /ConfigMgr_P01/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602} None efb25c8b-ee4e-4b48-aed0-ae77634aecc9 DataSource1 =Parameters!systemname.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 n.IPAddress0 FROM v_GS_NETWORK_ADAPTER_CONFIGURATION N where N.IPAddress0 <> '' and N.ResourceID = S.ResourceID order by N.TimeStamp desc ) as 'IP Address' ,(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.ResourceID = @systemname 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 IP Address System.String User Name System.String eMail System.String DataSource1 =Parameters!system.Value select distinct s.ResourceID,S.Name0 from v_R_System S where s.Name0 not in ('','NULL') and s.Name0 like ('%' + @system + '%' ) Name0 System.String ResourceID System.Int32 DataSource1 =Parameters!systemname.Value select CM.ResourceID ,C.CollectionID ,C.Name ,d.PackageID from v_FullCollectionMembership CM left join v_Collection c on C.CollectionID = CM.CollectionID left join v_DeploymentSummary D on D.CollectionID = C.CollectionID --where CM.Name = 'ZABEVSPR1500D' where CM.ResourceID = @systemname -- and d.PackageID is not null and (C.Name like 'SD -%' or C.Name like 'SU -%' or C.Name like 'CG -%' ) Order by C.Name CollectionID System.String ResourceID System.Int32 Name System.String PackageID System.String 39.2875mm 40.875mm 54.89791mm 44.17918mm 54.89791mm 6mm true true Computer Systems Textbox1 #69be28 2pt 2pt 2pt 2pt 5 6mm true true Last Logon #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 IP Address #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 =Fields!Operating_System.Value 2pt 2pt 2pt 2pt true true =Fields!IP_Address.Value 2pt 2pt 2pt 2pt true true =Fields!Site.Value 2pt 2pt 2pt 2pt After After Computers 31.93194mm 0mm 18mm 234.1375mm 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 194.85mm 6mm true true Collections Textbox1 #69be28 2pt 2pt 2pt 2pt 6mm true true =Fields!Name.Value 2pt 2pt 2pt 2pt 6mm true true SD - Software Distribution SU - Software Updates CG - Container Group Textbox12 2pt 2pt 2pt 2pt After Before Collections 55.38889mm 39.2875mm 18mm 194.85mm 2 73.74444mm 244.85623mm 14.55208mm true true true true System lookup Textbox13 0mm 39.2875mm 11.64167mm 139.95209mm #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