Report Last Modified Date and Modified by User in SSRS
In order to get last modified date of Report and modified by User you have to run below query in your Reporting server Database.
--Below query will Return all the report who has been modified by users
select username,userid,modifiedbyid,modifieddate,name as ReportName,path as ReportPath from catalog c join users u on
u.userid= c.modifiedbyid
--Add where condition if you want to see modifieddate and modified by user for a specific report
--where name ='TestReport'
In order to test manually for a Report to see last modified date and Modified by User
--o you can pick modifiedbyid from catalog table of your ReportServerDB using below query
select name,modifieddate,modifiedbyid from catalog where name ='TestReport'
then you can give that modifiedbyid to below query
select username,userid from users where userid='35ED7F1F-968D-4D36-8254-809EC2163C08'
--Above id is modifiedbyid to get the name of user who modified the Report.
Thanks for providing this quick reference since these fields aren't built-in parameters or variables in SSRS!
ReplyDeleteHello, I have browsed most of your posts. This post is probably where I got the most useful information for my research. Thanks for posting, maybe we can see more on this. Are you aware of any other websites on this subject. ייעוץ עסקי בירושלים
ReplyDeleteinformation created by sensors fitted into an assortment of savvy gadgets, information created unwittingly by individuals who peruse through the pages of an internet business site, information produced by the medicinal services industry as patient data, Data Analytics Course in Bangalore
ReplyDeletePositive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. anaconda install tensorflow
ReplyDeleteRights can be set to permit a few or all benefits to either people or gatherings.Change Site URL Using MySQL
ReplyDeleteJust the way I have expected. Your website really is interesting. ExcelR Data Analytics Course
ReplyDeleteAn interesting dialogue is price comment. I feel that it is best to write more on this matter, it may not be a taboo topic however usually individuals are not enough to talk on such topics. To the next. Cheers. Valorant Smurf Accounts
ReplyDeletePUBG Mobile is littered with vehicles, but most are abandoned and too damaged to be drivable. Learn the visual profiles of the drivable vehicles so you don't waste time. pubg mobile accounts
ReplyDelete