Highlighted

Opscenter query to list configured reports

Hello Team,

Can anyone help me with opscenter query to list all configured reports. I need to run some clean-up with configured reports. Thanks for help.

1 Solution

Accepted Solutions
Accepted Solution!

Re: Opscenter query to list configured reports

Pinku,

Check report_SavedReport table.

Run select * from report_SavedReport . This will list all the saved report Ithas colums like reporttype ,reportviewtype, createdby , ispublic etc.

reporttype   1 = canned,   2 = custom,  3=CustonSQL

reportviewtype  0=Distribution, 1 = Tabular, 2=TimeLIne, 3=Ranking, 4=HTML

For createdby , you can get the login id for the vaule increatedBy from the table security_User (select * from security_User).

Hope this will help.

DeepS

 

View solution in original post

1 Reply
Accepted Solution!

Re: Opscenter query to list configured reports

Pinku,

Check report_SavedReport table.

Run select * from report_SavedReport . This will list all the saved report Ithas colums like reporttype ,reportviewtype, createdby , ispublic etc.

reporttype   1 = canned,   2 = custom,  3=CustonSQL

reportviewtype  0=Distribution, 1 = Tabular, 2=TimeLIne, 3=Ranking, 4=HTML

For createdby , you can get the login id for the vaule increatedBy from the table security_User (select * from security_User).

Hope this will help.

DeepS

 

View solution in original post