01-31-2024
10:56 AM
- last edited on
04-01-2024
12:23 PM
by
Mercedes_O
Hello team,
Is there any report available to track USB Storage disks activities? I mean when were being connected on assets, as well when they are disconnected?
We need a historical report, not only when the USB Storage disks were detected during the last scan.
Solved! Go to Solution.
02-01-2024 06:56 AM
NG Query:
+ List AD Groups with prefix 'USB'
Select Top 1000000 tblAssets.assetid,
tblAssets.domain,
tblAssets.AssetName,
tblAssets.Userdomain,
tblAssets.Username,
Stuff((Select ', ' + tblADGroups.Name As [text()]
From tblADMembership Inner Join tblADGroups On
tblADMembership.ParentAdObjectID = tblADGroups.ADObjectID Inner Join
tblADusers On tblADMembership.ChildAdObjectID = tblADusers.ADObjectID
Where tblADusers.Username = tblAssets.Username And tblADusers.Userdomain =
tblAssets.Userdomain And tblADGroups.Name Like 'USB%' For Xml Path('')),
1, 2, '') groups,
tblFloppyHist.Model,
tblFloppyHist.Size,
tblFloppyHist.FirmwareRevision,
tblFloppyHist.SerialNumber,
Case tblFloppyHist.Action
When 1 Then 'Added'
When 2 Then 'Removed'
When 3 Then 'Updated'
End As Action,
tblFloppyHist.InterfaceType,
tblFloppyHist.Lastchanged
From tblFloppyHist
Inner Join tblAssets On tblAssets.AssetID = tblFloppyHist.AssetID And
tblFloppyHist.InterfaceType = 'USB'
Order By tblAssets.AssetName,
tblFloppyHist.Lastchanged Desc
02-01-2024 07:29 AM - edited 02-01-2024 07:30 AM
I see that you have setting one scan per 20 days I suggest you change to 1 or 0!
01-31-2024 11:26 AM
Did you put your LS servername?
Are you LS admin?
01-31-2024 12:30 PM
Yeah, I m an admin.
The report you shared with me has no results while executing. (For sure there are 100+ workstations with USB Storage disks hooked up)
01-31-2024 12:39 PM
Did you enable floppy history into Scanned Item Interval?
01-31-2024 01:21 PM
floppy history? Is there any relation to USB Storage disks? you mean this?
02-01-2024 03:56 AM
Any doubts in my words?
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now