‎07-28-2014 09:56 PM
Solved! Go to Solution.
‎07-29-2014 12:51 PM
‎07-31-2014 09:22 PM
MikeInLa wrote:
Yeah, I want to setup a report within Lansweeper.
MikeInLa wrote:
...but I can't figure out which table/entry to add to my report.
‎07-29-2014 06:28 PM
‎07-29-2014 12:51 PM
‎07-29-2014 01:09 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1
‎07-28-2014 11:16 PM
‎07-28-2014 11:33 PM
MikeInLa wrote:
GMFDE,
Thanks for your reply, but your code gives me errors. I am using the report builder in Lansweeper.
‎07-28-2014 10:12 PM
GO
SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name,c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%address%' /* CHANGE NAME BETWEEN THE % */
ORDER BY schema_name, table_name;
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now