TRY NOW
#DiscoverIT

New Software to Declare? L.S. Customs Has Got You Covered

3 min. read
16/10/2018
By Nils Macharis
LS-Customs-Detect-New-Software
Knowing which software is installed on your network and how many times a specific piece of software is deployed can be a big challenge for any business. Actively identifying newly installed software across your network adds an additional layer of complexity, which is almost impossible without an automated solution.  Accidental or intentional unauthorized software installation on your devices can enable malware to enter your network, which can lead to performance problems and the loss or leakage of sensitive data. Threats come from both inside the organization as well as from hackers on the outside. Employees may unknowingly download and install malicious programs, thereby violating your software installation policy. That is why it is critical to be aware of what software was installed on which device. To reduce the risks of breaches and downtime, IT techs need to be able to detect when new software is installed and quickly determine all the details. Lansweeper delivers complete visibility into what is happening across your network, including newly installed software and unauthorized software installation. You can simply create an email alert and you will immediately receive a detailed e-mail notification whenever new software is installed, so they can fully secure the organization’s assets. Easily detect newly discovered software in the last seven days using the report below. The report will list all newly added software from the last seven days that has not already been discovered by Lansweeper. If you haven’t already, download a free trial of Lansweeper to run the report and keep track of newly installed software.

Get Your Hands on the Latest Network Reports for Free

"*" indicates required fields

This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is for validation purposes and should be left unchanged.

How To Run This Report

  • Open the report builder in the Lansweeper web console under Reports/Create New Report.
  • Paste the SQL query (report) below at the bottom of the page, replacing the default SQL query.
  • Left-click somewhere in the upper section of the page so the query applies.
  • Give the report a title.
  • Hit the Save & Run button to save the report. Export options are listed on the left.
The Report Select 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
NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.