What is metricColumn in QueryService ?

[arun2arunraj]

Hi Developers,

    I am following this article. In that article, I have been stopped in the following line.

The one quirky thing about this is the query needs to return a single row of two columns - the first column must have a value of "metricColumn" (literally) and the second column must be a numeric value. To follow the earlier example (tracking the number of users currently logged in), it could be something like:

SELECT 'metricColumn', count(id) FROM my_application_user WHERE is_logged_in = true

  In that what is mean by metricColumn. If I came to what it means, then i can easily do my scenario.

My Scenario,

Table Name : status

Fields are following

Pid	loginstatus
1	invalid
2	valid
3	valid
4	valid
5	invalid

I have to count invalid loginstatus. So I have mentioned like this.

SELECT 'loginstatus',count(loginstatus) status WHERE loginstatus='invalid'.

But it is not working. Please help me to monitor my table.

[pilhuhn]

From how I read it, you need to literally return 'metricColumn' - not sure why. So your query should read

SELECT 'metricColumn' ,count(loginstatus) status WHERE loginstatus='invalid'

[arun2arunraj]

Hi Developers,

             Please check out this image below. At the Left Side, My Query Service is not available. Help me out to fix the problem. I want to retrieve value form my query. Please help me as soon as possible.

[arun2arunraj]

Hi Developers,

    I have checked my database, table and query. Even I have reinstalled my agent. But Still I cant access Query Service. Please reply me.

Regards,

ArunRaj