Discover 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 to mark software as approved or unauthorized. Once you’ve set up your software authorization you can easily audit your network for unauthorized software and identify the exact machines they are on to start taking action.
Unauthorized Software Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Description,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftware.Lastchanged,
tsysOS.Image As icon
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
Where tblSoftwareUni.Approved = 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
Software
