→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Evgenii_Kazantc
Engaged Sweeper II

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
3 REPLIES 3
fmculker
Engaged Sweeper
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
Engaged Sweeper
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
Lansweeper Employee
Lansweeper Employee
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.