Phone Lines icon GFI Support Home Sign in
Start a conversation
  1. GFI Support
  2. GFI Support - LanGuard Section
  3. Articles

A scheduled report against Entire Network does only report on a subset of computers ()

Answer

PROBLEM

A scheduled report run against the entire network does not cover all computers, but only a subset of computers.

Example:
  • The entire network contains 100 computers and all have been fully scanned and are licensed
  • The generated report file only contains the results for 5 computers

ENVIRONMENT

  • LanGuard 2011
  • Using an SQL database

SOLUTION

Note: The following procedure covers manual deletion of data from the database. If followed incorrectly this could result in data loss.
  1. Close the LanGuard console and stop its service
  2. Ensure that there is a current backup of the database
  3. Start the SQL Management Studio
  4. Open a query against the 'LNSSScanResults10' database
  5. Run the query: SELECT * FROM [Selection]
  6. If the query returns 0 rows stop the procedure
  7. If the query returns 1 or more rows run the query: DELETE FROM [Selection]
  8. Start the LanGuard service again

CAUSE

Temporary data in the '[Selection]' table of the database was not cleared properly.
Choose files or drag and drop files
Was this article helpful?
Yes
No

  1. Priyanka Bhotika

  2. Posted

Comments