Service Manager / Service Center Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

identify query

Regular Advisor

identify query

Hi All,

 

 

I can see below query in my log file mutliple times but unable to find out from where it is coming?

 

SELECT m1."NUMBER" FROM PROBSUMMARYM1 m1 WHERE ((m1."PROBLEM_STATUS" <> :Y or m1."CLOSE_TIME">:Y and m1."PROBLEM_STATUS"=:Y) AND (m1."NUMBER">'IM131313')) ORDER BY m1."NUMBER" ASC

 

If any one had same issue or can any one tel me from where exactly is this query fired ??

 

Regards

mamatha

 

4 REPLIES
Occasional Contributor

Re: identify query

Hi mama,

 

could you tell me HPSM server IP or server name? and HPSM database name?

I also want to access data from other tool .

Frequent Advisor

Re: identify query

try search "IM131313" in tables as "inbox", "link", "formatctrl", "querystored"

if you have sm 9xx use *afind.string command from comand line.

Re: identify query

Hi,

 

Can you please upload the sm.log..

Highlighted
Honored Contributor Honored Contributor

Re: identify query

Hi,

Queries are convert in to Sm syntax before sending to rdms .
So here we can not say from where here you have to check the lines nearby of the above query in sm.log file.
But why are you concerned about the query , there will lots of such query in log file ?

hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.