→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎04-08-2015 11:43 AM
Solved! Go to Solution.
‎04-08-2015 12:01 PM
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?
LithiumKid1976 wrote:
also, when querying the software, it pulls back some machines twice in the report.
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
‎05-07-2020 08:01 AM
‎05-05-2020 09:53 PM
‎04-17-2015 09:31 AM
‎04-16-2015 01:56 PM
‎04-08-2015 12:01 PM
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?
LithiumKid1976 wrote:
also, when querying the software, it pulls back some machines twice in the report.
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now