Audit: All Windows Server - Include Windows OS Version, Model, CPU (№, Cores), IPLocation

[Evgenii_Kazantc]

Select Top (1000000) tblAssets.AssetName As [Name],
  tblAssets.AssetID,
  tsysOS.Image As icon,
  RTrim(LTrim(Coalesce(tblOperatingsystem.Caption, '') + ' ' +
  Coalesce(tblOperatingsystem.OtherTypeDescription, ''))) As [OS Version],
  tblAssetCustom.Model As [Model/Platform],
  tblAssets.Processor As [Model CPU],
  tblAssets.NrProcessors,
  Sum(tblProcessor.NumberOfCores) As [CPU Cores],
  dbo.tsysIPLocations.IPLocation
From tblComputersystem
  Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
  Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
    tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Group By tblAssets.AssetName,
  tblAssets.AssetID,
  tsysOS.Image,
  RTrim(LTrim(Coalesce(tblOperatingsystem.Caption, '') + ' ' +
  Coalesce(tblOperatingsystem.OtherTypeDescription, ''))),
  tblAssetCustom.Model,
  tblAssets.Processor,
  tblAssets.NrProcessors,
  tblAssets.AssetUnique,
  tsysIPLocations.IPLocation
Having RTrim(LTrim(Coalesce(tblOperatingsystem.Caption, '') + ' ' +
  Coalesce(tblOperatingsystem.OtherTypeDescription, ''))) Like '%Server%'
Order By tblAssets.AssetName

[fmculker]

Yes It is hosted in SQL compact. I will try to run this report in SQL Server.

Thanks for your reply Mr. Bart.E

[fmculker]

I am getting the below error while creating this report.

There was an error parsing the query. [ Token line number = 1,Token line offset = 395,Token in error = tsysIPLocations ]

[Bart_E]

fmculker wrote:
I am getting the below error while creating this report.

There was an error parsing the query. [ Token line number = 1,Token line offset = 395,Token in error = tsysIPLocations ]

The report uses an SQL function which is only supported by SQL Server. Most likely your database is hosted in SQL Compact, which doesn't support this function. This is an SQL Compact limitation, not a Lansweeper limitation. You can verify which database server you're using under Configuration\Database Scripts.