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 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
