→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
HomeHardSW
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
JLanane
Engaged Sweeper
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

View solution in original post

2 REPLIES 2
HomeHardSW
Engaged Sweeper
Hi,

Thanks for that report. Work's great.
JLanane
Engaged Sweeper
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