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  v_GS_COMPUTER_SYSTEM CS,
      v_FullCollectionMembership FCM ,
      v_GS_OPERATING_SYSTEM OS,
      v_RA_System_SystemOUName OU,
      v_GS_WORKSTATION_STATUS WS
where  CS.ResourceID=FCM.ResourceID and
CS.ResourceID=OS.ResourceID and
CS.ResourceID=OU.ResourceID and
CS.ResourceID=WS.ResourceID and OU.ResourceID in
(select LD.ResourceID from v_GS_LOGICAL_DISK LD where LD.Description0 not like '%ROM%' and
LD.Description0 not like '%floppy%' and LD.SystemName0 not like 'null'
group by LD.ResourceID having COUNT(ld.name0)>1) and
OS.Caption0 not like '%Server%'
group by CS.Name0,
         CS.UserName0,
         FCM.Sitecode,
         OS.Caption0,
         OS.InstallDate0,
         WS.LastHWScan

     Customize if you require more information.