How to generate report with AssetID but that number which is in lsagent.ini

[Rodney]

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.

Sometimes on some clients the lsagent.ini file becomes empty for no reason. Then we don't know what the AssetID was in it. We would like to recreate this .ini file. If we perform a new installation of the client, we must delete the entire old entry from the server so that the new data begins to be saved under the same client name.

In other words, we want to get report with these numbers:

lsagent.ini

not with these numbers:

[Rodney]

This is exactly what I want ! Thanks !

[rader · Accepted solution]

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