This query will list all objects for a location and will determine if report output is sent as an email attachment. Result will show if attachments are sent by the object’s schedule, by a job step, or is sent by a view based on the object. This information can be used to help determine if the objects are necessary, especially when combined with Cognos audit data using the NetVisn UniVisn database views. This is the same as ‘Cognos Objects Sending Attachments by Location’ except this includes all reports that use a specific package.
Use Case: Find out which reports are required (or not) to deliver report output by Email.
Setup: Set the $packageID variable in the script
Category: Cognos Report Usage