Thursday, March 8, 2012

audit UpLoad function

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
--
Rickselect * from catalog where type = 3
all the uploaded files have type 3.
Amarnath.
"Rick" wrote:
> 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
> --
> Rick|||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
"Amarnath" wrote:
> select * from catalog where type = 3
> all the uploaded files have type 3.
> Amarnath.
> "Rick" wrote:
> > 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
> > --
> > Rick|||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
"Rick" wrote:
> 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
>
> "Amarnath" wrote:
> > select * from catalog where type = 3
> > all the uploaded files have type 3.
> >
> > Amarnath.
> >
> > "Rick" wrote:
> >
> > > 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
> > > --
> > > Rick

No comments:

Post a Comment