recover license keys for installed software

Select Top 1000000 tblAssets.AssetName,tblAssets.IPAddress,tblAssets.Username, tblSerialnumber.Product, tblSerialnumber.ProductKeyĪnd tblSerialnumber.Product = 'Microsoft Office Visio Professional 2007 Volume license' I’ve been through the table you’ve suggested and I’m still having difficulty. However, if I use a query similar to the below, it pulls information about software that is no longer installed. I simply want to be able to use SQL in order to accurately audit the software currently (Not previously) installed on any machine in our network. I’ve used the software tables you’ve mention and have many scripts created to monitor the error logs too.

However the SQL I’m using returns results/details of the software and even when it’s been removed/uninstalled, “as per you mentioning“ some software may leave old registry details like a key relating to software previously installed. When I talk about the product/licensing keys being referenced, I’m basically attempting to audit software currently installed on any machine within our company. Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetIDĪnd tblSerialnumber.Product like '%office%'Īnd tblSerialnumber.Product = 'Microsoft Office Visio Professional 2007’Īnd (tblAssets.IPAddress like '192.168.3.%' Inner Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID

Select Top 1000 tblAssets.AssetName,tblAssets.IPAddress,tblAssets.Username, tblSerialnumber.Product, tblSerialnumber.ProductKey Is there a way to omit the historical / Recovered license keys data from being audited ?

When looking at the main Lansweepers dashboard and against a specific machine, the product and licence keys are contained within the “Recovered license keys area” NOT within the actual software currently installed. I then find the software is no longer actually installed on the machines I'm auditing. I’m currently working on a software audit and although using the below SQL I’m finding Microsoft office products such as (Microsoft Office Visio Professional 2007). I have a question about the Recovered license keys data section in Lansweeper.

Recover license keys for installed software