04-30-2024
12:01 PM
- last edited on
05-21-2024
02:41 PM
by
Riley
Hi
We want to know is there any way to generate report from server database with AssetID's - but we want to see that numbers which are in the lsagent.ini on clients computers.
not with these numbers:
Solved! Go to Solution.
05-03-2024 08:43 PM
tblLsAgentAsset - LsAgentAssetID works against my LSAgent.ini file.
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
tblLsAgentAsset.AssetID As AssetID1,
tblassets.AssetUnique,
tblLsAgentAsset.LsAgentAssetID,
tblLsAgentAsset.Version
From tblassets
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join tblLsAgentAsset On tblassets.AssetID = tblLsAgentAsset.AssetID
05-06-2024 09:10 AM
This is exactly what I want ! Thanks !
05-03-2024 08:43 PM
tblLsAgentAsset - LsAgentAssetID works against my LSAgent.ini file.
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
tblLsAgentAsset.AssetID As AssetID1,
tblassets.AssetUnique,
tblLsAgentAsset.LsAgentAssetID,
tblLsAgentAsset.Version
From tblassets
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join tblLsAgentAsset On tblassets.AssetID = tblLsAgentAsset.AssetID
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now