Registry scanning fails

[maweko]

Hello,

I used the Lansweeper registry scanning feature to get an overview about installed hofixes of our used Virusscan software. This was working in past without any problem. At the moment the registry scanning seems not to work and there are not shown any results in a particualr report about that fix.

The old used scan looked in specific registry paths for a Regvalue "Hotfix_793781" and the value detected was "Mcshield=". My report about the deployment was

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblRegistry.Valuename, tblRegistry.Value From tblComputers Inner Join tblRegistry On tblComputers.Computername = tblRegistry.Computername Where tblRegistry.Valuename = 'Hotfix_793781'

and everything worked fine.


Now I have configured the registry scan to look in specific paths for Regvalue "Hotfix_805660"
and changed my report slightly so it looks like

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblRegistry.Valuename, tblRegistry.Value From tblComputers Inner Join tblRegistry On tblComputers.Computername = tblRegistry.Computername Where tblRegistry.Valuename = 'Hotfix_805660'

but it does not come back with any computers although the Regvalue and value is there on the computer.

I assume the registry scan fails due to the value contains special characters. Following is the value of the regvalue:

Hotfix_805660

mfeapfa.dll=|mfeapfk.sys=|mfeavfa.dll=|mfeavfk.sys=|mfebopa.dll=|mfebopk.sys=|mfeclnk.sys=
|Mfehidk.sys=|Mfehida.dll=|mfehidin.exe=|mfehidk_messages.dll=|mferkda.dll=|mferkdet.sys=
|mfetdi2k.sys=|mfevtpa.dll=|mfevtps.exe=|mfewfpk.sys=|mfeapconfig.dll=|RkScan.dll=



Has someone an idea how to get it working?

[maweko]

Hello,

Great job.

Scanning the registry works fine now.

Thanks

M.

[Hemoco]

Do the following:
- Execute the script below in the Lansweeper configuration console under Lansweeper\Database Scripts, which will increase the size of the registry value field. Copy and paste the code and hit the “Execute sql script” button.

ALTER TABLE tblregistry ALTER COLUMN value nvarchar(1000)

- Rescan your machines by hitting Ctrl+A under Lansweeper\Scanned Computers in the configuration console and hitting the Full Rescan button.

[maweko]

We are using Version 4.2.0.90.

Looking forward for any help.

M.

[Hemoco]

The problem is that the string below is too long for its corresponding Lansweeper container and therefore cannot be stored.

mfeapfa.dll=|mfeapfk.sys=|mfeavfa.dll=|mfeavfk.sys=|mfebopa.dll=|mfebopk.sys=|mfeclnk.sys=
|Mfehidk.sys=|Mfehida.dll=|mfehidin.exe=|mfehidk_messages.dll=|mferkda.dll=|mferkdet.sys=
|mfetdi2k.sys=|mfevtpa.dll=|mfevtps.exe=|mfewfpk.sys=|mfeapconfig.dll=|RkScan.dll=

Could you tell us which Lansweeper version you are using (4.2 or 5.0), so we can provide you with accurate instructions for resolving this issue.