Re: identify query (171 Views)
Reply
Regular Advisor
Posts: 237
Registered: ‎03-13-2012
Message 1 of 5 (221 Views)

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

 

Occasional Contributor
Posts: 5
Registered: ‎06-25-2013
Message 2 of 5 (182 Views)

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
Posts: 42
Registered: ‎10-09-2011
Message 3 of 5 (175 Views)

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.

Advisor
Posts: 22
Registered: ‎03-29-2010
Message 4 of 5 (173 Views)

Re: identify query

Hi,

 

Can you please upload the sm.log..

Honored Contributor
Posts: 4,374
Registered: ‎06-17-2010
Message 5 of 5 (171 Views)

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.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.