Tuesday, July 25, 2017

Drivers (Disk) Space information for machines & Collection

Drivers (Disk ) Space information for machines :


Select v_R_System.name0,

v_R_System.Resource_Domain_OR_Workgr0 as Domain,
v_GS_LOGICAL_DISK.FreeSpace0,
v_GS_LOGICAL_DISK.Size0,
v_GS_LOGICAL_DISK.Caption0,
v_GS_LOGICAL_DISK.DriveType0,
v_R_System.Last_Logon_Timestamp0

from v_R_System

inner Join v_GS_LOGICAL_DISK on v_GS_LOGICAL_DISK.ResourceID = v_R_System.ResourceID

where v_GS_LOGICAL_DISK.DriveType0 = '3'
order by v_R_System.name0






For Collection :-



SELECT distinct
SYS.Name,
v_r_system.user_name0,
sys.SiteCode,
SYS.Domain,
LDISK.Description0,
LDISK.DeviceID0,
LDISK.VolumeName0,
LDISK.FileSystem0,
v_GS_OPERATING_SYSTEM.Caption0 as 'Operating System',
LDISK.Size0,
LDISK.FreeSpace0

FROM
v_FullCollectionMembership_Valid SYS
join v_GS_LOGICAL_DISK LDISK on SYS.ResourceID = LDISK.ResourceID
join v_r_system on SYS.ResourceID= v_r_system.resourceID
Inner Join v_GS_OPERATING_SYSTEM ON v_GS_OPERATING_SYSTEM.Resourceid=v_R_System.Resourceid
WHERE LDISK.DriveType0 = 3 and  sys.CollectionID = 'SMS00001'

No comments:

Post a Comment

site backup job manually

Start a scheduled SCCM 2012 site backup job manually You might want to start a scheduled SCCM 2012 site backup job manually. off co...