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.    

2 Responses to "SCCM report Computers with more than 1 partition"

  1. Hi Eswar,

    I want to know if any of my systems have more than one partition on the same drive. Does this report list the number of partitions on the drive, or the number of drives in a computer?

    Thanks!

    Reply
    1. This report will list computers that have more than 1 partition but not the partitions like c, d, e etc. If you need, you have to add the partition info into the query.

      Reply

Post Comment