History report of used removable storage

[ict-user]

Hi Folks,

Currently i have a Report to show active removable storage:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysOS.OSname As OS,
tsysOS.Image As icon,
tblFloppy.Manufacturer As [Drive Manufacturer],
tblFloppy.Model As [Drive Model],
tblFloppy.Size,
tblFloppy.Size
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblFloppy.Size > 1 And tblAssetCustom.State = 1 And
tblFloppy.InterfaceType = N'USB'
Order By tblAssets.AssetName Desc

I want to make a report that shows me the history of all used removable storage in the domain.

Can anybody give me a tip how to build the query?

[ict-user]

Thanx for the reply

[Hemoco]

We checked with development and it appears history tracking for this item was enabled by default in Lansweeper 4.2. It is now disabled by default in (new) Lansweeper 5.0 installations.

[ict-user]

Clean install of the first version 5.
Later all the updates.

I think it is off (default)

[Hemoco]

Someone must have disabled this before, as history tracking for this item is enabled by default.

[ict-user]

Scanned items wait time for FLOPPY.
Enabled History.

This solved my problem.

[ict-user]

After a rescan i get new inserted USB sticks (in the query with tblFloppy).
In the query with tblFloppyHist i don't.
I want to keep track of USB sticks that were inserted for about a month ago.

When i look in configuration > database scripts > table rows for tblFloppyHist is 0

[Hemoco]

If tblFloppyHist is empty, that means no changes have been detected in tblFloppy. If you're sure changes took place, try rescanning your machines by clicking the Assets link at the top of the web console, ticking the upper checkbox and hitting the Rescan button on the left.

[ict-user]

When i use tblFloppyHist i don't get any result.
For example:

Select Top 1000000 tblFloppyHist.InterfaceType,
tblFloppyHist.Manufacturer,
tblFloppyHist.Model
From tblFloppyHist

[Hemoco]

You need to base your report on tblFloppyHist instead of tblFloppy. Historical data is stored in database tables ending in "Hist".