SCCM report Computers with more than 1 partition
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 …