Report - License Keys

[MikeInLa]

I apologize, but I simply have a hard time building a report to do what I want to do. Basically I want to end up with a list of ALL of my workstations showing the following columns: Computer Name, IP Location, Office version, Office license Key.
We can look at Office licenses for each asset by simply going to the software tab and scrolling to the bottom. But I cannot find a table with that information to place in my report. And I can't find a way to replace "ip address" with the "ip location". Here is what I have...

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID

[MikeInLa]

Thank you!!! This is perfect 🙂

[Hemoco]

Please use the following query:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tblSerialnumber.Product,
tblSerialnumber.ProductKey
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID
Where tblSerialnumber.Product Like '%office%'


To use the report above, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.