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.
Before running this report, replace “YourService” in the report below with the service you want to report on.
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
