→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎05-25-2010 10:55 PM
‎06-01-2010 09:05 PM
‎06-01-2010 06:45 PM
Select Top 1000000 dbo.tblComputers.Computername, dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, dbo.tblOperatingsystem.Description, dbo.tblServices.Caption, dbo.tblServices.Lastchanged, Web40OSName.Compimage As icon From dbo.tblServices Inner Join dbo.tblComputers On dbo.tblServices.Computername = dbo.tblComputers.Computername Inner Join dbo.tblComputersystem On dbo.tblComputers.Computername = dbo.tblComputersystem.Computername Inner Join dbo.tblOperatingsystem On dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername Inner Join dbo.web40ActiveComputers On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername Where dbo.tblServices.Caption <> 'Performance Logs and Alerts' And dbo.tblServices.Startmode = 'Auto' And dbo.tblServices.State = 'stopped' And dbo.tblComputersystem.Domainrole <> 1 And dbo.tblServices.Caption <> 'Security Center' Order By dbo.tblComputers.Computer
‎05-26-2010 12:41 AM
Select Top 1000000 dbo.tblComputers.Computername,
dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain,
dbo.tblOperatingsystem.Description, dbo.tblServices.Caption,
dbo.tblServices.Lastchanged, Web40OSName.Compimage As icon
From dbo.tblServices Inner Join
dbo.tblComputers On dbo.tblServices.Computername =
dbo.tblComputers.Computername Inner Join
dbo.tblComputersystem On dbo.tblComputers.Computername =
dbo.tblComputersystem.Computername Inner Join
dbo.tblOperatingsystem On dbo.tblComputers.Computername =
dbo.tblOperatingsystem.Computername Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
Where dbo.tblServices.Startmode = 'Auto' And dbo.tblServices.State = 'stopped'
And dbo.tblServices.Name Not Like 'sysmonlog' And
dbo.tblComputersystem.Domainrole <> 1
Order By dbo.tblComputers.Computer
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now