→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
maweko
Engaged Sweeper
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?







4 REPLIES 4
maweko
Engaged Sweeper
Hello,

Great job.

Scanning the registry works fine now.

Thanks

M.

Hemoco
Lansweeper Alumni
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
Engaged Sweeper
We are using Version 4.2.0.90.

Looking forward for any help.

M.
Hemoco
Lansweeper Alumni
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.