‎02-10-2010 02:56 PM
Solved! Go to Solution.
‎02-11-2010 01:46 PM
Select Top 1000000 dbo.tblComputers.Computername As Computer,
dbo.tblOperatingsystem.Description, dbo.tblFileVersions.Lastchanged
From dbo.tblComputers Inner Join
dbo.tblComputersystem On dbo.tblComputers.Computername =
dbo.tblComputersystem.Computername Left Outer Join
dbo.tblOperatingsystem On dbo.tblComputers.Computername =
dbo.tblOperatingsystem.Computername Left Outer Join
dbo.tblFileVersions On dbo.tblComputers.Computername =
dbo.tblFileVersions.Computername
Where dbo.tblFileVersions.FilePathfull Like '%fsav.exe%' And
dbo.tblFileVersions.Found = 0
Order By dbo.tblFileVersions.Lastchanged Desc
‎02-11-2010 10:13 AM
Lansweeper wrote:
In the configuration tool you can add "scanned files"
All computers are scanned if this file exists and what the version number is.
You can then use this information to build custom reports.
‎02-11-2010 09:40 AM
‎02-11-2010 09:42 AM
Lansweeper wrote:
This is an example report that uses the scanned file '%fssm32%'
If you don't scan this file or don't use f-secure you can safely remove the report.
‎02-11-2010 09:28 AM
‎02-11-2010 09:36 AM
Lansweeper wrote:
Could you give me the sql definition of the report please.
Select Top 100 Percent dbo.tblComputers.Computername As Computer, dbo.tblOperatingsystem.Description, dbo.web30repdomainswithfsecure2.Domain, dbo.tblFileVersions.Lastchanged From dbo.tblComputers Inner Join dbo.tblComputersystem On dbo.tblComputers.Computername = dbo.tblComputersystem.Computername Inner Join dbo.web30repdomainswithfsecure2 On dbo.tblComputers.Domain = dbo.web30repdomainswithfsecure2.Domain Left Outer Join dbo.tblOperatingsystem On dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername Left Outer Join dbo.tblFileVersions On dbo.tblComputers.Computername = dbo.tblFileVersions.Computername Collate Latin1_General_CI_AS Where dbo.tblFileVersions.FilePathfull Like '%fssm32%' And dbo.tblFileVersions.Found = 0 And dbo.tblComputersystem.Domainrole = '1' Order By dbo.web30repdomainswithfsecure2.Domain, dbo.tblFileVersions.Lastchanged Desc
‎02-10-2010 05:05 PM
‎02-11-2010 08:53 AM
Lansweeper wrote:
Do you scan for this file using the file scanning?
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now