Support Forum

We've been using SurfLog for a while and it hasn't been running on the majority of our systems lately. According to your troubleshooting steps, the issue must be related to running the command since trying to run it manually from an elevated command prompt. The result when trying to run it is: "The system cannot execute the specified program." What would cause this to happen. We are running Automate 12 Patch 8. Thanks.

Antivirus!

Make sure you have cleared the BHV.exe to operate unhindered. Also delete the BHV.exe and allow script to download it again.

Test it yourself to see if it runs without errors by copying the command from script logs and running that in a command shell on agent directly.

We also execute a powershell script to parse the data into a SQL statement we can import back into LabTech. See if it creates the SQL file and also check the file size? Is SQL file we import more than 2 MB in size? If so then Labtech is truncating the file on import and breaking sql.

To fix this kind of issue we need to reduce the time frame we pull data for and then run more offten during the day to make up for the less data being collected.

To do this, You would edit the Scripts\Maintenance\Surflog Maintenance script and where we execute the command to query BHV.exe, the end of the command should have a "24". The 24 represents the number of hours to look back at, so we collect on every scan the last 24 hours. We force SQL to only save new or changed records so a lot of the data is just rehashed junk we do not use if you are scanning every 4 or 8 hours with Surflog. So by changing the 24 to a 12 we collect only the last 12 hours of data and since we are cycling on 4 or 8 we will always get extra data so that no missing data or time frames are seen.

Formula: (Every 4 to 8 hours we collect last 12 hours of data)

This should reduce the file size some and get you under the 2 MB limit of Labtech. (if that is the issue)