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

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.

Receive the Latest Network Reports for FREE

Count Me In!

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

 

Try Lansweeper for Free

Learn why Lansweeper is used by thousands of enterprises worldwide.​