Internet Connection Sharing Service Audit
Network Operating System SecurityFind the Internet Connection Sharing Service Status
Services are a core Windows function designed to enable the creation and management of long-running processes. The Internet Connection Sharing service is one of the components in Windows that allows you share a computers‘ internet connection with local devices, using Network Address Translation (NAT) to manage data routing. It simplifies network setup by acting as a DHCP server, assigning local IP addresses.
To help you get an overview of the ICS status, you can use the report below to get a list of all machines in your environment that have the Internet Connection Sharing service.
Run the Internet Connection Sharing Service Audit Now!
![ICS audit report.png](https://www.lansweeper.com/wp-content/uploads/ICS-audit-report.png-1024x119.webp)
Internet Connection Sharing Service Lansweeper On-Prem Query
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.Username, tblAssets.Userdomain, Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, tblAssets.IPAddress, tsysIPLocations.IPLocation, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tsysOS.OSname As OS, tblServicesUni.Caption As [Service Name], tblServicesUni.Pathname As [Service Path], tblServiceStartMode.StartMode As [Service Start Mode], tblServiceState.State As [Service State], Case When tblErrors.ErrorText Is Not Null Or tblErrors.ErrorText != '' Then 'Scanning Error: ' + tsysasseterrortypes.ErrorMsg Else '' End As ScanningErrors, tblAssets.Lastseen, tblAssets.Lasttried From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID Inner join tblServices on tblServices.AssetID = tblassets.AssetID Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID = tblServices.ServiceuniqueID Inner Join tblServiceStartMode On tblServiceStartMode.StartID = tblServices.StartID Inner Join tblServiceState On tblServiceState.StateID = tblServices.StateID Inner Join tblState On tblState.State = tblAssetCustom.State Left Join tsysOS On tsysOS.OScode = tblAssets.OScode Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID, Max(tblErrors.Teller) As ErrorID From tblErrors Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID = ScanningError.ID Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype = tblErrors.ErrorType Where tblState.Statename = 'Active' and tblServicesuni.Name = 'SharedAccess' and tblServicesUni.Caption like '%Internet Connection Sharing%' Order By tblAssets.Domain, tblAssets.AssetName