Re: identify query (61 Views)
Reply
Regular Advisor
mamatha26
Posts: 237
Registered: ‎03-13-2012
Message 1 of 5 (111 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

 

Please use plain text.
Occasional Contributor
youngbeen
Posts: 5
Registered: ‎06-25-2013
Message 2 of 5 (72 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 .

Please use plain text.
Frequent Advisor
bzember
Posts: 42
Registered: ‎10-09-2011
Message 3 of 5 (65 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.

Please use plain text.
Advisor
vivek chaudhary
Posts: 18
Registered: ‎03-29-2010
Message 4 of 5 (63 Views)

Re: identify query

Hi,

 

Can you please upload the sm.log..

Please use plain text.
Honored Contributor
Piku
Posts: 3,663
Registered: ‎06-17-2010
Message 5 of 5 (61 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,
Please use plain text.
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