SCCM SQL Query : Sql query for machines joined after a date
select distinct *
from v_R_System where Creation_Date0 > '2014-12-01 06:22:10.000' and
Resource_Domain_OR_Workgr0 = 'domainname' and Obsolete0 not like 1
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