Assets with issues overflows scanning queue

[Mister_Nobody]

We have some Windows-assets with endless WMI-scanning.

So we have two porblems:

1. LS doesn't have working timeout but we see log record (Aborted mydomain\rds-sql\1 scanning takes longer than 1 hour, wmi might need a repair on this machine.)

2. And then we have duplicates of assets in scanning queue.

As result scanning queue full and LS doesn't have slot for new scanning.

"Clear queue" button also not works for such assets.

[ErikT · Accepted solution]

@Mister_Nobody 
indeed check is the WMI needs repairing on the Windows asset that is blocking the queue. 
https://community.lansweeper.com/t5/troubleshooting-scanning-issues/repair-a-corrupt-wmi-installatio...

Restarting the scanning server should free up the memory and scanning queue. Not ideal but works as a last resort.

[Mister_Nobody · Accepted solution]

Now I restart LS service every night...

[Mister_Nobody · Accepted solution]

I have created report to  show WMI-corrupted assets:

Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.oscode,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblErrors.ErrorText
From tblAssets
  Inner Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
  Inner Join tsysasseterrortypes On
      tblErrors.ErrorType = tsysasseterrortypes.Errortype
Where (tblErrors.ErrorText Like N'%Недопустимый класс%' Or
    tblErrors.ErrorText Like N'%Invalid%')
Order By tblAssets.Domain,
  tblAssets.AssetName

[Mister_Nobody · Accepted solution]

We have added memory to assets with endless wmi-scanning.

3 GB are not enough for MS WS 2019... A lot of page faults...

[Mister_Nobody · Accepted solution]

I have created report to  show WMI-corrupted assets:

Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.oscode,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblErrors.ErrorText
From tblAssets
  Inner Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
  Inner Join tsysasseterrortypes On
      tblErrors.ErrorType = tsysasseterrortypes.Errortype
Where (tblErrors.ErrorText Like N'%Недопустимый класс%' Or
    tblErrors.ErrorText Like N'%Invalid%')
Order By tblAssets.Domain,
  tblAssets.AssetName

[ErikT · Accepted solution]

@Mister_Nobody 
indeed check is the WMI needs repairing on the Windows asset that is blocking the queue. 
https://community.lansweeper.com/t5/troubleshooting-scanning-issues/repair-a-corrupt-wmi-installatio...

Restarting the scanning server should free up the memory and scanning queue. Not ideal but works as a last resort.

[Mister_Nobody · Accepted solution]

Now I restart LS service every night...