There isn't a direct relationship between the software table and the license keys, so it's conceivable - probable, even - that you may end up finding more than one associated key on some machines. The condition on the JOIN will limit license keys to those associated with a product containing "Acrobat" in the name. The two conditions in the WHERE clause should limit the software to the full version of Acrobat, excluding Reader from the result set. Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softIDĪND tblSoftwareUni.softwareName Like 'Adobe Acrobat%'ĪND tblSoftwareUni.softwareName Not Like 'Adobe%Reader%' Retrieve keys and product IDs from computers and find the results on their respective web pages or in the built-in product key reports. Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID Learn how to scan your network for installed software and how to use the License Compliance tool. Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID Software Inventory Management & License Compliance. Inner Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID And tblSerialnumber.Product Like '%Acrobat%' Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype In terms of computer name changes: currently, the correct way to rename a computer is to first rename it in Lansweeper and then rename the machine itself. Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID You need to check the 'lock against scanning' checkbox next to the serial number field to ensure that your manual changes are not overwritten.
0 Comments
Leave a Reply. |