January 11, 2012 at 3:20 pm
Team:
If I run the following SQL, all that I see is a bunch of unique identifiers.
Anyone knows how to decry pt the value to find out who actually created the report ?
Select top 100 created_by, modified_by from CAtALOG
EX:
AB222049-4BB4-46B4-B8E8-000C40155B09
January 12, 2012 at 8:59 am
mw112009 (1/11/2012)
Team:If I run the following SQL, all that I see is a bunch of unique identifiers.
Anyone knows how to decry pt the value to find out who actually created the report ?
Select top 100 created_by, modified_by from CAtALOG
EX:
AB222049-4BB4-46B4-B8E8-000C40155B09
I don't have a 2005 box but on SSRS 2008R2 you'd join to the USERS table. The columns are named CreatedByID and ModifiedByID in 2008R2, but I'm going to assume the same join will work in 2005.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 12, 2012 at 9:18 am
Thanks
That worked!
Great job.I guess why didn't I bother to look whether we had a users table ? Shame of me.
Thanks again
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply