SCCM SQL Query : to find package size
SELECT DISTINCT
p.PackageID, p.Name, 'Source Size (MB)' = n.SourceSize
FROM v_Package p
LEFT JOIN
v_PackageStatusRootSummarizer
n
ON p.PackageID =
n.PackageID
SCCM SQL Query : To List Machines With IIS , FTP Or Telnet Installed
Select SD.Name0 ‘Machine Name’, SD.Operating_System_Name_and0 NOS, SS.Name0 ‘Service Name’, SS.DisplayName0 ‘Display Name’, SS.StartMode0 ‘Start Type’, SS.Started0 Started, SS.State0 State, SS.Status0 Status From System_DISC SD Join Services_DATA SS on SS.MachineID = SD.ItemKey Where SS.Name0 In (‘W3SVC’, ‘MsFtpSvc’, ‘TlntSvr’) Order By ‘Machine Name’
Comments
Post a Comment