TECHNOTE: IEM SUA / ILMT 9.2 Scan Health widget reports Missing Scan Results

Usage and Config BFI
1

http://www-01.ibm.com/support/docview.wss?uid=swg21902714

Problem(Abstract)
The Scan Health widget shows the health of scans that are running in your infrastructure. In IBM Endpoint Manager for Software Use Analysis v9.2 or IBM License Metric Tool v9.2 it may happen that this widget reports endpoints which are Missing Scan Results. Also the data from scan files is not imported into SUA / LMT even though endpoints are working fine and data import logs does not show any errors.

Symptom
Scan Health widget reports Missing Scan Results for most, or all of the endpoints. The number of endpoints will be close to, or equal to the result of following sql query:
SELECT count(*) FROM sam.scan_files_persistent sf
JOIN dbo.computers c ON c.id = sf.computer_id
JOIN dbo.datasource_files df ON df.file_name = sf.file_name AND df.computer_id = sf.computer_id
WHERE sf.deleted = 1
AND c.deleted = 0
AND df.deleted = 0

Resolving the problem
To workaround the problem you should follow this procedure:

  1. Stop the SUA/ILMT server.
    Linux:
    Run the following command: /etc/init.d/SUAserver stop
    (/etc/init.d/LMTserver stop)
    Windows:
    a. Go to the License Metric Tool installation directory.
    b. Open cli.
    c. Run srvstop.bat.

  2. Replace the scan.file.rb file with:
    http://www-01.ibm.com/support/docview.wss?uid=swg21902714&aid=1

The file scan_file.rb is in the following directory:
Linux:
install_dir/wlp/usr/servers/server1/apps/tema.war/WEB-INF/domains/sam/app/models/sam/
Windows:
install_dir\wlp\usr\servers\server1\apps\tema.war\WEB-INF\domains\sam\app\models\sam\

  1. Start the SUA/ILMT server.
    Linux:
    Run the following command: /etc/init.d/SUAserver start
    (/etc/init.d/LMTserver start )
    Windows:
    a. Go to the License Metric Tool installation directory.
    b. Open cli.
    c. Run srvstart.bat.

  2. Initiate new software scans for affected endpoints using Initiate Software Scan task.

  3. Upload scan results to the Endpoint Manager console.

  4. Run a data import (ETL) to Software Use Analysis.

This problem will be permanently addressed in the next SUA/ILMT patch.

2

Hello,

I had the same after LMT deployment 9.2.0.0 in RedHat server. So we applied the patch 9.2.1 still the some of the machines showing missing scan results.

Also work around link is not working it seems, can you give me the work around steps for the same.

ASAP.

-suresh

3

Can you define “some”? Is it a few of your endpoints? Half? More than half?

“Missing Scan Results” means “Results of the catalog-based scan were not uploaded to the BigFix server. The problem might occur because the computer or a relay is offline or there is a network outage”.

Check a few computers with this status value and see if the software scan actually ran on it. If not, or you are not certain, run the scan, upload the results and then run an ILMT import, and see if the results of the scan will now appear.

–Mark

4

Half of the endpoints.

When I look at the software scan status of all endpoints seems OK. Also have ran the scan many times and ILMT import as well.

How about primary and secondary relay options . Its says “main endpoint manager server”.

-Suresh

5

@suresh
Update to 9.2.2 and schedule scans on all the endpoints again, so if that helps.

6

Actually have done the upgrade also. Still 21 endpoints showing missing scan results.

Is it anything to do with the scanner. Since i have IBM Endpoint manager 9.2.21 version.

7

looks like link related to scan.file.rb is broken or outdated. can you repost the updated link. Thanks.

8

it is recommended to update to latest version at this point, this issue has been fixed there as well as many other issues