SCCM report Computers with more than 1 partition
Posted by Eswar Koneti on September 10th, 2012
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.