Find out the user name who created the variant of a query

Business Warehouse

Moderators: Snowy, thx4allthefish

Post Reply
martin79
Posts: 58
Joined: Sat May 17, 2008 1:59 pm
Location: Barcelona (Catalunya - Spain)

Find out the user name who created the variant of a query

Post by martin79 » Mon Sep 12, 2011 10:52 pm

Dear all.

I have a query with several variants. I would need to know which user created which variant. Please tell me where to find this.

Very kind regards,

Martin

Gothmog
Posts: 1952
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: Find out the user name who created the variant of a query

Post by Gothmog » Mon Sep 12, 2011 11:09 pm

Have a look at table VARID, using the query report name (AQ.....).
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67

martin79
Posts: 58
Joined: Sat May 17, 2008 1:59 pm
Location: Barcelona (Catalunya - Spain)

Re: Find out the user name who created the variant of a query

Post by martin79 » Tue Sep 13, 2011 12:47 am

Thanks for your answer. In your table VARID, I found field ENAME. I downloaded the list for a specific query in an Excel fashion, and then just edited it for my needs. Thanks again,

Martin

Post Reply