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 …