SCCM SQL Query : To See When Collections Were Last Updated
Select
CC.CollectionID,CN.CollectionName, CC.TimeUpdated
From Collection_MemberChg_Notif
CC,
Join Collections CN on CC.CollectionID = CN.SiteID
Order By CollectionName
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