Enterprise Edition with multiple scan servers: lstrigger.exe {ScanServer} {computer} {domain}

[AdmJLovejoy]

Not able to instruct lstrigger to use a particular scan server when more than one scan server is used in Enterprise Edition. There is no parameter to target a specific scan server. ie...

cmd.exe /K {actionpath}lstrigger.exe {ScanServer} {computer} {domain}

For instance, Host(A) can only communicate with ScanServer(A), and Host(B) can only communicate with ScanServer(B).

Now, at the web site, within Host(A)'s "Action Screen", you click "Trigger Scan (P)". Scanning is triggered as expected. with the following...

"cmd.exe /K {actionpath}lstrigger.exe ScanServerA {computer}{domain}"

ScanServer(A) scans Host(A) successfully.

Now you're at Host(B) 's "Action Screen" and you click "Trigger Scan (P)". Because of the static command above, ScanServer(A) is told to scan Host(B), but because ScanServer(A) cannot communicate with Host(B), scanning Host(B) fails. To scan Host(B) successfully, ScanServer(B) must be told to scan Host(B).

Each Scan Server needs to report to the DB that "I scanned this computer" for each computer found by that Scan Server. This can be a column (ScannedBy) added to the tblComputers table.

The behavior sent to the DB would look something like, "I found this computer, and I own the scanning of this computer".

This should be standard functionality for the Enterprise Edition without having to be scripted

[AdmJLovejoy]

After DB rebuild, confirmed that the {scanserver} parameter works as expected.

[AdmJLovejoy]

New SQL scripts are not available unless Database selection is checked. Was forced to drop old DB to get the new scripts.

[Hemoco]

You only need to run the sql script "upgradebeta.sql"

[AdmJLovejoy]

Installed the new beta without the Database selection. Ran SQL scripts buildtables.sql, and buildobjects.sql. Starting the service throws the following errors in the log...

3/12/2010 11:24:39 AM: Starting up service 4.0.0.11, port 9524, 20 computer threads, 10 IP threads
3/12/2010 11:24:39 AM: Enterprise version
3/12/2010 11:24:40 AM: domain\hostname\1 Invalid column name 'scanserver'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at LansweeperService.sweeperthread.UpdateIPandScanningServer(LS_Computer mycomputer, SqlConnection& sqlcon)

[AdmJLovejoy]

Excellent, this can be closed then.

[Hemoco]

AdmJLovejoy wrote:
Excellent, this can be closed then.

Did you try the new beta?
You will need to wait for a rescan to fill the field "scanserver"

[Hemoco]

This will be in the next beta.