04-25-2017 10:53 AM
Solved! Go to Solution.
05-01-2017 02:49 PM
05-05-2017 10:08 AM
05-05-2017 10:06 AM
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
05-03-2017 09:40 AM
Schnepel wrote:
Hello,
i scan a custom registry key to see the TeamViewer ID.
That works great.
05-01-2017 02:49 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now