Find Windows Computers Missing a Specific Service
Many software use services to continuously run and perform actions. Oftentimes, these software are critical to an organization like antivirus, cybersecurity products or agents like LsAgent. Being able to find which machines are missing critical services is important to determine where the gaps are in your IT environment. Lansweeper scans all services which are on a Windows computer, this makes it easy to also determine where specific service are missing.
The report below provides a list of devices where a specific service is not present.
Windows Computer Missing a Service Query
Select Top 1000000 tsysOS.Image As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.Username, tblAssets.Userdomain, tblAssets.IPAddress, tblAssets.Firstseen, tblAssets.Lastseen, tblAssets.Lasttried From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode Where tblAssets.AssetID Not In (Select Top 1000000 tblServices.AssetID From tblServices Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID = tblServices.ServiceuniqueID Where tblServicesUni.Caption Like '%YourService%') And tblAssetCustom.State = 1 Order By tblAssets.Domain, tblAssets.AssetName