cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ict-user
Engaged Sweeper III
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?
9 REPLIES 9
ict-user
Engaged Sweeper III
Thanx for the reply
Hemoco
Lansweeper Alumni
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
Engaged Sweeper III
Clean install of the first version 5.
Later all the updates.

I think it is off (default)
Hemoco
Lansweeper Alumni
Someone must have disabled this before, as history tracking for this item is enabled by default.
ict-user
Engaged Sweeper III
Scanned items wait time for FLOPPY.
Enabled History.

This solved my problem.
ict-user
Engaged Sweeper III
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
Lansweeper Alumni
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
Engaged Sweeper III
When i use tblFloppyHist i don't get any result.
For example:

Select Top 1000000 tblFloppyHist.InterfaceType,
tblFloppyHist.Manufacturer,
tblFloppyHist.Model
From tblFloppyHist
Hemoco
Lansweeper Alumni
You need to base your report on tblFloppyHist instead of tblFloppy. Historical data is stored in database tables ending in "Hist".

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now