topic Re: Query usage statistics in Application Development and Automation Discussions

Query usage statistics

Former Member — Tue, 22 Jun 2010 10:24:25 GMT

Hi,

I don't know if this is the right place to post this but here goes.

In ST03N I've looked at the usage of transactions etc. to try and find the most commonly run queries defined in SQ01.

It tells me how often transaction SQ01/2 have run, but not what query was executed. Is this possible anywhere else?

Cheers,

Russ.

Re: Query usage statistics

SuhaSaha — Tue, 22 Jun 2010 10:46:44 GMT

You can use the transaction SM20N to check the query that is being used.

Prior to that you need to make the necessary config in SM19. Check the forums for further details.

BR,

Suhas

PS: If you have the necessary authorizations configuration using SM19 should be a piece of cake.

Re: Query usage statistics

Former Member — Tue, 22 Jun 2010 12:50:10 GMT

Thanks for the info.

Unfortunately I'm only interested in historical queries that have run. Is there no table or transaction that can just say Query - Date - Runby ?

Cheers,

Russ.

Re: Query usage statistics

SuhaSaha — Tue, 22 Jun 2010 13:15:10 GMT


> Unfortunately I'm only interested in historical queries that have run. Is there no table or transaction that can just say Query - Date - Runby ?

Hi Russ,

Frankly i don't understand what you mean by "historical queries". From your original post i understand you need to check the queries which were run using SQ01.

If the Audit profile was activated in your system (SM19), the query calls would have been registered in the system. AFAIK the audit log is a file in the SAP app server & not stored in some DB table. Guys, correct me if i am wrong.

BR,

Suhas

Re: Query usage statistics

Former Member — Tue, 22 Jun 2010 13:31:35 GMT

Hi,

Yes you did understand me correctly - by historical queries I meant queries that have been run prior to the logging being set up in SM19.

I still can't see however how this transaction can tell me the most commonly run Queries!?

I did find SPRO -> SAP Netweaver -> Application Server -> SAP Query -> Logging -> Determine Infosets for logging which I believe would give me what I'm looking for!?

Cheers,

Russ.

Re: Query usage statistics

Shafiq_Rehman1 — Mon, 28 Jun 2010 16:01:28 GMT

Try table D010LINF, it stores history of programs run in past.

Re: Query usage statistics

Former Member — Wed, 30 Jun 2010 16:12:04 GMT

Thanks, but that only seems to be last run date.

Re: Query usage statistics

ThomasZloch — Wed, 30 Jun 2010 16:20:13 GMT

It isn't even that, it's the timestamp of the last generation of the source code.

Thomas