TRY NOW

Assets with Unauthorized Software Audit

Security Software

Find Unauthorized Software in Your Network

Discover assets with unauthorized software in your network easily with this audit. Lansweeper will automatically scan software within your network. Once your software has been scanned you use software authorization on-premises or the custom report in Lansweeper Sites to mark software as approved or unauthorized. Once you’ve set up your software authorization you can easily audit your network for assets with unauthorized software to start taking action. You can learn more about this in the Pro Tips 55 blog.

Run The Unauthorized Software Audit Now!

Assets with Unauthorized Software Query

Select Top (1000000) tblAssets.AssetID,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  Count(tblSoftware.SoftwareID) As [Unauthorized Software],
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tsysOS.OSname As OS,
  tblAssets.Firstseen As [Created at],
  tblAssets.Lastseen As [Last successful scan]
From tblSoftware
  Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
  Left Outer Join tsysIPLocations On tsysIPLocations.LocationID =
      tblAssets.LocationID
Where tblSoftwareUni.Approved = 2 And tblAssetCustom.State = 1
Group By tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tsysOS.OSname,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tsysAssetTypes.AssetTypeIcon10

Show

Hide

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.