This is a post for people with knowledge of using SQL to query the content store. Not interested in a third party tool.

With report schedules I always end up with the report owner as the schedule owner. I want the person who "Scheduled by" or the "Credentials" that run the schedule. I have the schedule CMID but the owner is the report owner. Have not figured out how to find the credentials of the person that the schedule runs on. 

Any help is appreciated.

For anyone that is interested, this is where i found the Credentials (Account/User Information) for each Schedule

select cp33.name as schedule_credientials_name, cp33.userid as schedule_credientials_userid, 
	left(cp1.objid, charindex(':u:', cp1.objid) - 1) as schedule_credientials_namespace, cp33.cmid as schedule_credientials_cmid,  
	n1.cmid as schedule_cmid
	from cmrefnoord1 n1 inner join								-- n1.cmid is the schedule, n1.refcmid has reference to crediential id
		cmobjects co on n1.refcmid = co.cmid					-- co is the xref between the crediential id and account (person,user)
		inner join cmobjprops33 cp33 on cp33.cmid = co.pcmid	-- c33 has account information (person,user)
		inner join cmobjprops1 cp1 on cp33.cmid = cp1.cmid		-- cp1 has the account namespace, my cognos has multiple namespaces
		where n1.propid = 15									-- credentials only
		and co.classid = 48										-- schedules only

Hi Brenda,

Do you know if Audit model introduced in Cognos 12.1.0 will run in Cognos 11.2.4? if it will not natively run since the Content Store has not changed is there any way to make it work in the old 11.2.4 version?