‎01-14-2016 05:15 PM
Solved! Go to Solution.
‎12-10-2018 01:16 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblRegistry.Value
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblAssetCustom.State = 1 And tblRegistry.Valuename = 'ClientID'
$server = $args[0]
$ARG = import-csv "\\<LansweeperServer>\export\TeamViewer_DeviceID.csv" -Delimiter ';' |where-object assetname -like $server | select value -ExpandProperty value
start-process -filepath "C:\Program Files (x86)\TeamViewer\TeamViewer.exe" -argumentlist "-i $ARG"
‎12-04-2018 12:19 AM
CREATE TRIGGER MK_IU_tblRegistry
ON [dbo].[tblRegistry]
AFTER INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON
UPDATE A SET
A.Custom1 = B.Value
FROM tblAssetCustom A
INNER JOIN inserted B
ON A.AssetID = B.AssetID
WHERE B.Regkey LIKE '%TeamViewer%'
AND B.Valuename = 'ClientID'
END
‎06-12-2017 04:22 PM
‎06-08-2017 03:32 PM
‎06-08-2017 01:50 PM
For each path below, the RegValue is: ClientID
RegPath(s):
HKLM\SOFTWARE\TeamViewer
HKLM\SOFTWARE\Wow6432Node\TeamViewer
HKLM\SOFTWARE\Wow6432Node\TeamViewer\Version6
HKLM\SOFTWARE\Wow6432Node\TeamViewer\Version7
HKLM\SOFTWARE\Wow6432Node\TeamViewer\Version8
HKLM\SOFTWARE\Wow6432Node\TeamViewer\Version9
UPDATE dbo.tblAssetCustom
SET dbo.tblAssetCustom.Custom1 = dbo.tblRegistry.value
FROM dbo.tblAssetCustom INNER JOIN dbo.tblRegistry
ON dbo.tblAssetCustom.AssetID = dbo.tblRegistry.AssetID
WHERE tblRegistry.Regkey LIKE '%teamviewer%'
‎07-07-2017 01:13 PM
esr wrote:
I've added custom registry scans for the client id, and then use a script to populate one of the custom fields so the client id is easily found on any asset page. It's not interactive or anything, but at least the ID is easily found so you don't need to search or ask the user...
The registry keys we scan-
For each path below, the RegValue is: ClientID
RegPath(s):
HKLM\SOFTWARE\TeamViewer
HKLM\SOFTWARE\Wow6432Node\TeamViewer
HKLM\SOFTWARE\Wow6432Node\TeamViewer\Version6
HKLM\SOFTWARE\Wow6432Node\TeamViewer\Version7
HKLM\SOFTWARE\Wow6432Node\TeamViewer\Version8
HKLM\SOFTWARE\Wow6432Node\TeamViewer\Version9
Note that HKLM\SOFTWARE\Wow6432Node\TeamViewer works for versions 10, 11 & 12
Then just a quick SQL UPDATE to the custom field of your choice:UPDATE dbo.tblAssetCustom
SET dbo.tblAssetCustom.Custom1 = dbo.tblRegistry.value
FROM dbo.tblAssetCustom INNER JOIN dbo.tblRegistry
ON dbo.tblAssetCustom.AssetID = dbo.tblRegistry.AssetID
WHERE tblRegistry.Regkey LIKE '%teamviewer%'
NOTE THAT Lansweeper Tech Support does not really support or provide assistance for playing around with your database. Always backup and if possible test in a dev environment.
‎06-05-2017 11:20 PM
‎01-19-2016 11:27 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now