Jetzt Ausprobieren

High Number of Autorun Items Audit

Operating System Software

Find Computers Which Have a High Number of Autorun Items

Find possible causes for performance issues due to high numbers of autorun items. During Windows scans, the autorun items are also scanned by Lansweeper. This audit gives a list of computers which have more than 25 autorun items. Having a high number of autorun items can cause performance issues and more like slow or long boot times due to the resources needed to run all these items. This audit can be used to easily identify assets which might need your attention in order to disable unnecessary autorun items. High number of autorun items

High Number of Autorun Items Query

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  Count(tblAutorun.AutorunID) As Total,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblAutorun On tblAssets.AssetID = tblAutorun.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblAssetCustom.State = 1
Group By tsysOS.Image,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tsysOS.OSname,
  tblAssets.SP
Having Count(tblAutorun.AutorunID) > 25
Order By Total Desc

Show

Hide