no viable alternative at input ' FROM' in SELECT Clause

HI All

Trying to do a select via the SWQL studio

SELECT+NodeID,NodeCaption,NodeGroup,AgentIP,Community,SysName,SysDescr,SysContact,SysLocation,SystemOID,Vendor,MachineType,LastBoot,OSImage,OSVersion,ConfigTypes,LoginStatus,City+FROM+NCM.Nodes

But as a result I get -

2020-06-30 09:14:37,930 [154] ERROR SolarWinds.InformationService.Core.InformationService - SWQL Studio (null) Exception caught in method SolarWinds.InformationService.Core.InformationService.RunQuery
SolarWinds.Data.SWQL.SWQLSyntaxException: no viable alternative at input 'FROM' in Select clause ---> Antlr.Runtime.NoViableAltException: A recognition error occurred.
at SolarWinds.Data.SWQL.Parser.SWQLParser.unaryExpression()
--- End of inner exception stack trace ---
at SolarWinds.Data.SWQL.Parser.SWQLParser.unaryExpression()
at SolarWinds.Data.SWQL.Parser.SWQLParser.multiplyExpression()
at SolarWinds.Data.SWQL.Parser.SWQLParser.additiveExpression()
at SolarWinds.Data.SWQL.Parser.SWQLParser.relationalExpression()
at SolarWinds.Data.SWQL.Parser.SWQLParser.equalityExpression()
at SolarWinds.Data.SWQL.Parser.SWQLParser.negatedExpression()
at SolarWinds.Data.SWQL.Parser.SWQLParser.logicalAndExpression()
at SolarWinds.Data.SWQL.Parser.SWQLParser.logicalOrExpression()
at SolarWinds.Data.SWQL.Parser.SWQLParser.expression()
at SolarWinds.Data.SWQL.Parser.SWQLParser.aliasedExpression()
at SolarWinds.Data.SWQL.Parser.SWQLParser.selectedPropertiesList()
at SolarWinds.Data.SWQL.Parser.SWQLParser.selectClause()
at SolarWinds.Data.SWQL.Parser.SWQLParser.selectFrom()
at SolarWinds.Data.SWQL.Parser.SWQLParser.queryRule()
at SolarWinds.Data.SWQL.Parser.SWQLParser.selectStatement()
at SolarWinds.Data.SWQL.Parser.SWQLParser.statement()
at SolarWinds.Data.SWQL.SWQLParser.Parse(String query)
at SolarWinds.Data.Query.Engine.QueryProcessor.ProcessInternal(String query, IQueryExecutionContext context)
at SolarWinds.InformationService.Core.QueryPlanCache.GetQueryPlan(String query, String username, Boolean federationEnabled, Func`1 buildQueryPlan)
at SolarWinds.InformationService.Core.InformationService.RunQuery(String query, IDictionary`2 parameters, IDataSerializer serializer)

!some searching leads to this, but yes not quite the answer but maybe something to do with the version we are running

https://thwack.solarwinds.com/t5/EOC-Discussions/EOC-Not-Accepting-SQL-Filter-Queries-for-Custom-Properties/m-p/193354

We are running version 12.4 of the NPM

Is there someone out there who can help me in some way

Thanks in advance

Find more posts tagged with

Accepted answers

dsimpkins

I copied and pasted your query and got the same error.

Replacing the +'s and removing City from the query made it work

SELECT
NodeID,
NodeCaption,
NodeGroup,
AgentIP,
Community,
SysName,
SysDescr,
SysContact,
SysLocation,
SystemOID,
Vendor,
MachineType,
LastBoot,
OSImage,
OSVersion,
ConfigTypes,
LoginStatus
FROM NCM.Nodes

All comments

dsimpkins

I copied and pasted your query and got the same error.

Replacing the +'s and removing City from the query made it work

shuth

I'd say removing the +'s fixes it. The query below runs for me.

SELECT NodeID,NodeCaption,NodeGroup,AgentIP,Community,SysName,SysDescr,SysContact,SysLocation,SystemOID,Vendor,MachineType,LastBoot,OSImage,OSVersion,ConfigTypes,LoginStatus,City FROM NCM.Nodes

tuxPower

Hi dsimpkins

That did the trick, thanks alot

tuxPower

HI Shuth

If City stays it does not work for me -

shuth

Do you have the City node custom property? If your instance does not have this custom property, the column won't exist in your NCM.Nodes table.

I created another custom property called City2 - this now appears in my NCM.Nodes table.