Repository / Event Task definition in database

[former_member2987]

Hey there,

Does anyone know where the Repository details are stored in the database. Specifically I'm looking for the Event Task relationship, but I wouldn't mind learning about the other tabs too

As a follow up, I've found some information in mc_repository_type_vars which lists the jobs and other information, however int information in VarValue does not seem to match with any GUIDS of jobs.

If you execute a seelct * from mc_repository_type_vars and then choose a task and check the guids from your MMC they don't seem to match anywhere. I've attached a screenshot to help out with this.

I'm working with IDM 7.2 SP9 SQL Server, BTW

Thanks!

Matt

[jared_kobe]

I always thought the event tasks were stored as repository constants found in MC_REPOSITORY_VARS.

Can you query the database itself for the taskGUIDs? (select * from mxp_tasks where taskguid = '')

[former_member2987]

Hey Jared,

Hmm... I would have thought that the comparison from the GUID in the MMC and VarValue in mc_repository_vars would do it.  Let me take a look.

Thx,

Matt

[former_member2987]

Yeah it works fine and has absolutely no relationship to what's in the table.  As expected.

[jared_kobe]

I don't have anything in MC_REPOSITORY_TYPE_VARS, so I cannot make a true comparison.

I did run this:

select * from MXP_Tasks where taskguid in (select distinct varvalue from mc_repository_template_vars where varname like '%task')

Everything that came back from the query was part of the Provisioning Framework. I also did a search for the GUIDs in your screenshot, none of the ones that were given by the MMC came back, but the ones from the SQL were also from the Framework.

Also, for the repositories that I have configured, all of the tasks are stored by TASKID and not GUID.

[former_member2987]

Yeah, so that's from the task table as opposed to the repository table so it doesn't really apply.

gonna have to play with this some more.  Thanks for your help!