cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
micos
Engaged Sweeper II

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. 

2 ACCEPTED SOLUTIONS
Mister_Nobody
Honored Sweeper II

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

View solution in original post

Mister_Nobody
Honored Sweeper II

I see that you have setting one scan per 20 days I suggest you change to 1 or 0!

View solution in original post

14 REPLIES 14
Mister_Nobody
Honored Sweeper II

Did you put your LS servername?

Are you LS admin?

micos
Engaged Sweeper II

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)

Mister_Nobody
Honored Sweeper II

Did you enable floppy history into Scanned Item Interval?

micos
Engaged Sweeper II

floppy history?  Is there any relation to USB Storage disks? you mean this? 

micos_0-1706703689300.png

 

Mister_Nobody
Honored Sweeper II

Any doubts in my words?