Teamviewer ID Report

[HomeHardSW]

Hi,

I have managed to get LanSweeper to scan our assets to grab all the Teamviewer ID's on the network for different versions But I am looking for a way to put all this information into one report.

Here are the registry paths:

http://f74i.imgup.net/2016-04-1167d6.png

What SQL would I need to use to list the following information:

Asset Name | Description | Last User | Domain | Teamviewer ID

Thanks.

[HomeHardSW]

Hi,

Thanks for that report. Work's great.

[JLanane · Accepted solution]

This won't get you all of those registry values but it gives you a base:

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Firstseen,
  SubQuery1.Value As [TeamViewer ID],
  tblAssets.Domain,
  tblAssets.Description,
  tblAssets.Username
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
  Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
  Left Join (Select Top 1000000 tblRegistry.AssetID,
    tblRegistry.Regkey,
    tblRegistry.Valuename,
    tblRegistry.Value,
    tblRegistry.Lastchanged
  From tblRegistry
  Where tblRegistry.Regkey Like '%SOFTWARE\Wow6432Node\Teamviewer' And
    tblRegistry.Valuename = 'ClientID') SubQuery1 On SubQuery1.AssetID =
    tblAssets.AssetID
Where tblAssetCustom.State = 1 And TsysWaittime.CFGname = 'registry'
Order By tblAssets.Domain,
  tblAssets.AssetName