SCCM SQL Query : To Get Members Of A Specified Collection
Select
Members.Name
‘Collection
Members:’
From
CollectionMembers Members
Join
Collections Coll on Members.SiteID = Coll.SiteID
Where
Coll.CollectionName = ‘All Systems’
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