Groups | Blog | Home
all groups > sql server reporting services > june 2006 >

sql server reporting services : audit UpLoad function


Rick
6/7/2006 12:00:03 PM
I'd like to create an audit report identifying all UpLoads that have been
done. Is it possible to identify this from the ReportServer or
RSExecutionLog databases?

Thanks
--
Amarnath
6/8/2006 1:09:01 AM
select * from catalog where type = 3
all the uploaded files have type 3.

Amarnath.

[quoted text, click to view]
Rick
6/8/2006 6:19:02 AM
The Type column in the Catalog table appears to be the object type:

1 Folder
2 Report
3 Resource
4 Linked Report
5 Data Source

I'd like to track each time a report (Type = 2) has been Uploaded.

Thanks,
--
Rick


[quoted text, click to view]
Amarnath
6/8/2006 9:47:01 PM
Rick,
You want to find out the deployed report or uploaded because type =2 will
give you deployed report and from "report manager" when you upload then it is
option type =3

Amarnath

[quoted text, click to view]
AddThis Social Bookmark Button