Updating of field "LastSeen" when using LSpush

[wantok]

Hi

We have many machines that are offline and we run lsPush to capture their information.

When the LS.TXT files are imported, the field tblComputer.Lastseen is updated to the date the information is imported, not the date the information was actually captured on the computer.

Is there anyway to have that field capture the date the LSpush was run on the source computer, or any other field that has that information.

Thanks

[wantok]

Thanks support, looks like a good solution

[Hemoco]

When you import an LsPush file:
- If the machine had not previously been present in the database, its "firstseen" date is updated to the date/time of when the LsPush scan took place.
- The machine's "lastseen" and "LastLsPush" fields are updated to the date/time of the import. There is currently no way to change this behavior, but we may add an option in Lansweeper 5.0. In the meantime however, the tblCPlogoninfo.logontime field would be a good way to determine when the LsPush scan took place. An example report can be seen below.

Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblComputers.Firstseen, tblComputers.Lastseen, tblComputers.Lasttried,
tblComputers.Lasttriggered, tblComputers.LastScheduled,
tblComputers.LastActiveScan, Max(tblCPlogoninfo.logontime) As
[Last LsPush Scan], tblComputers.LastLsPush As [Last LsPush Import]
From tblComputers Inner Join
tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Where tblComputers.LastLsPush = tblComputers.Lastseen
Group By tblComputers.ComputerUnique, tblComputers.Computername,
tblComputers.Domain, tblComputers.Computer, tblComputers.Firstseen,
tblComputers.Lastseen, tblComputers.Lasttried, tblComputers.Lasttriggered,
tblComputers.LastScheduled, tblComputers.LastActiveScan,
tblComputers.LastLsPush, tblComputers.LastLsPush
Order By tblComputers.ComputerUnique

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.