Here is nice report to identify computers which are with more than one partition installed on to them excludes external drives. select CS.Name0 as [Computer name],        MAX(OU.System_OU_Name0)as [OU],        CS.UserName0 as [Last loggedon User],        FCM.Sitecode ,        OS.Caption0 AS [OS],        OS.InstallDate0 [OS Installed Date],        WS.LastHWScan [Recent Reported to sccm]      from …

long ago have posted report on computers with SCCM report for Last logged on computer name with application installed or not and SCCM report display computers with IPaddress based on Application/software this report gives you computers with ip address and last logged on username from a given collection : select A.Name0,c.IPAddress0 as 'IP ADDRESS',E.UserName0 as…

You have report to list all computers based on last logged on username from http://eskonr.com/2011/03/sccm-report-to-list-all-computers-based-on-last-logged-on-user-name-from-collection/ . In this post,you will get list of computers with last logged on user name from given collection. Create a new report and paste the below query into it. Select A.Name0, A.UserName0  from V_GS_COMPUTER_SYSTEM A join v_FullCollectionMembership B on A.ResourceID…