10-18-2016 11:19 PM
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.
Solved! Go to Solution.
01-03-2017 12:19 AM
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
01-03-2017 12:19 AM
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