Notification

Icon
Error

Show newly discovered software

Posted: Wednesday, March 28, 2018 3:24:58 PM(UTC)
Hendrik.VE

Hendrik.VE

Member Original PosterPosts: 101
8
Like
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.
Code:
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
Options
dpjhoward
#1dpjhoward Member Posts: 1  
posted: 12/16/2020 10:15:05 PM(UTC)
This is great! Thank you!!!!Pray
1
ctopaloglu
#2ctopaloglu Member Posts: 1  
posted: 6/15/2021 4:51:03 PM(UTC)
It gives me an empty page :(
0
CyberCitizen
#3CyberCitizen Member Posts: 470  
posted: 6/16/2021 12:05:54 AM(UTC)
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).
0
CyberCitizen
#4CyberCitizen Member Posts: 470  
posted: 6/16/2021 12:06:21 AM(UTC)
Originally Posted by: ctopaloglu Go to Quoted Post
It gives me an empty page :(


Most likely cause you don't have any that meet the criteria at present.
0

Active Discussions

Lansweeper Report showing app even after it has gone
by  Andy.S   Go to last post Go to first unread
Last post: 5/30/2022 3:19:37 PM(UTC)
Lansweeper Creating a schduled task on remote computer
by  TassieTrooper   Go to last post Go to first unread
Last post: 4/12/2022 8:49:36 AM(UTC)
Action Internet history of an user (IE and Firefox)
by  Tizi@no   Go to last post Go to first unread
Last post: 4/1/2022 1:32:49 PM(UTC)
Action Remote Uninstaller
by  Tizi@no   Go to last post Go to first unread
Last post: 4/1/2022 9:29:17 AM(UTC)
Lansweeper uVNC Config
by  RatWolf   Go to last post Go to first unread
Last post: 3/17/2022 3:16:53 PM(UTC)
Lansweeper Force Adobe Acrobat Reader/Standard/Pro to update itself
by  Apaulcolypse   Go to last post Go to first unread
Last post: 3/15/2022 3:11:20 PM(UTC)
Lansweeper Change computer name by custom field
by  Don   Go to last post Go to first unread
Last post: 3/4/2022 3:44:08 AM(UTC)
Lansweeper Creating a new Ticket with Action and having autocompleted new fields.
by  Georgios Tsimogiannis   Go to last post Go to first unread
Last post: 1/18/2022 10:19:14 AM(UTC)