cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Hendrik_VE
Champion Sweeper III
The report below list newly discovered software (software not previously discovered by Lansweeper) in the last 7 days, and the asset it has been installed on. Please note that this report compares the first 10 characters of recently scanned software with already existing software names in the database to determine if the software is "new" to the database.

The report will only list assets that meet all of the following criteria:
  • The asset state is set to "active".
  • The asset has been successfully scanned at least once.
  • The asset is a Windows asset.
  • The asset has software which was scanned in the past 7 days and which has not been present in the database before.
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.Added,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Right Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tblSoftwareHist On tblSoftwareHist.softid = tblSoftwareUni.SoftID
Where tblSoftwareUni.Added > GetDate() - 7 And
SubString(tblSoftwareUni.softwareName, 1, 10) Not In (Select
SubString(tblSoftwareUni.softwareName, 1, 10) From tblSoftwareUni
Where tblSoftwareUni.Added < GetDate() - 7) And
tblSoftwareUni.SoftwarePublisher Is Not Null And tblState.Statename = 'Active'
Order By tblAssets.Domain,
tblAssets.AssetName
4 REPLIES 4
CyberCitizen
Honored Sweeper
Nice little report, added to our list and setup email alert to monitor for new installs that L1 techs are doing that may breach license agreements (eg personal freeware).
ctopaloglu
Engaged Sweeper
It gives me an empty page 😞
ctopaloglu wrote:
It gives me an empty page 😞


Most likely cause you don't have any that meet the criteria at present.
dpjhoward
Engaged Sweeper
This is great! Thank you!!!!