LithiumKid1976 wrote:
We use "Nuance PDF Converter Professional 8" on site, and i want to see if its possible to retrieve the license key that was used on each PC?
The short answer is: yes, if the key is stored in the registry and you know where it is. More info on how license key scanning works can be found in
this knowledge base article.
LithiumKid1976 wrote:
also, when querying the software, it pulls back some machines twice in the report.
We can't really comment on this without knowing which page you are accessing or which SQL query you are running. Your report may simply be written incorrectly. The built-in report "Software: List of software by computer", also seen below, should list all of your software installations. Note that:
- There will be multiple lines per machine, one for each software. This is expected behavior. SQL displays each table record (e.g. software) as a line, not a column.
- Software installations have nothing to do with software license keys. This knowledge base article provides more information on how software installation scanning works and this knowledge base article outlines the difference between software installation and software license key scanning.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon,
tblAssets.Username,
tblAssets.Userdomain
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
Order By tblAssets.AssetName,
software,
version