Re: identify query (126 Views)
Reply
Regular Advisor
mamatha26
Posts: 237
Registered: ‎03-13-2012
Message 1 of 5 (176 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
youngbeen
Posts: 5
Registered: ‎06-25-2013
Message 2 of 5 (137 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
bzember
Posts: 42
Registered: ‎10-09-2011
Message 3 of 5 (130 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
vivek chaudhary
Posts: 19
Registered: ‎03-29-2010
Message 4 of 5 (128 Views)

Re: identify query

Hi,

 

Can you please upload the sm.log..

Honored Contributor
Piku
Posts: 3,972
Registered: ‎06-17-2010
Message 5 of 5 (126 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.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
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.