+ Start a Discussion
gtuerkgtuerk 

Query against Custom Report Types, Reports

I hate dead code.  And I hate dead reports.  I'd like to be able to query against the Custom Report Types in our instance and return whether or not there are active reports authored against those Custom Reports.  Is there any way to do this?  I can't find any report types in the DataLoader nor in the salesforce.schema
Best Answer chosen by Admin (Salesforce Developers) 
werewolfwerewolf
You would be able to find those using the Metadata API.

All Answers

werewolfwerewolf
You would be able to find those using the Metadata API.
This was selected as the best answer
gtuerkgtuerk
Thanks.  Works with IDE users (so ok with me) but some of my users would like SOQL access to reports.  I'll look for ideas on idea exchange
Shishir VKShishir VK

Hi,

 

If you have found the solution for querying Reports along with Report Format and Type, can you please let me know how to do the same?

 

A link/ small code snippet would be very helpful.

 

Through the Metadata API am not able to get the FullName (Combination of report Name and Folder name), Report Type, Report Last Run and ReportFormat etc..

 

Can you please guide???

 

Its very urgent  for me to get this information in the API .