→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
CMCSDIT
Engaged Sweeper
I would like to scan to see if a certain profile is on any machines. example I Replaced Jim. I want to delete his profiles off all PCs, I was wondering if i could scan for a folder like this? or if i would have to look for ntuser inside JIM. Either way i donot know how to do this.


i thought i would scan for c:/documents and settings/Jim
3 REPLIES 3
Hemoco
Lansweeper Alumni
Please use the following report instead:

Select tblComputers.ComputerUnique, tblFileVersions.Found,
tblFileVersions.FilePathfull
From tblComputers Inner Join
tblFileVersions On tblComputers.Computername = tblFileVersions.Computername
Where (tblFileVersions.Found = '1' And tblFileVersions.FilePathfull =
'C:\Documents and Settings\Jim\NTUSER.DAT') Or
(tblFileVersions.Found = '1' And tblFileVersions.FilePathfull =
'C:\Users\Jim\NTUSER.DAT')
Order By tblComputers.ComputerUnique
CMCSDIT
Engaged Sweeper
So i modified yours a little bit because i only want the report to only show positives, But it is still showing negitives, can you assist.

Select tblComputers.ComputerUnique, tblFileVersions.Found From tblComputers Inner Join tblFileVersions On tblComputers.Computername = tblFileVersions.Computername Where tblFileVersions.FilePathfull = 'C:\Documents and Settings\Jim\NTUSER.DAT' Or tblFileVersions.FilePathfull = 'C:\Users\Jim\NTUSER.DAT'
and found like '%1%'
Order By tblComputers.ComputerUnique
Hemoco
Lansweeper Alumni
You cannot scan for folders, but scanning the NTUSER.DAT file should work.

- Add the file path to the Lansweeper configuration console under Scanning Options\File Scanning. Example: C:\Documents and Settings\Jim\NTUSER.DAT
If your environment has mixed operating systems, you may need to scan for multiple paths. Under Windows 7 the path would be C:\Users\Jim\NTUSER.DAT for instance.
- To immediately scan for the file, perform a "Full Rescan" of the workstations you need.
- Scanned file info can be found on computer pages under Config\Scanned Info\File Info.
- Use the following report for an overview of the scanned information:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblFileVersions.FilePathfull As [Attempted to scan], tblFileVersions.Found,
tblFileVersions.FileVersion, tblFileVersions.CompanyName,
tblFileVersions.Filesize
From tblComputers Inner Join
tblFileVersions On tblComputers.Computername = tblFileVersions.Computername
Where tblFileVersions.FilePathfull = 'C:\Documents and Settings\Jim\NTUSER.DAT'
Order By tblComputers.ComputerUnique

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now