Deleted users in Cognos

[Sunchaser]

Dear all,

I have seen that some informations concerning users, groups,roles, etc... are stored in Cognos in the tables:
.CMOBJPROPS1
.CMOBJPROPS33

But when a user is deleted (directly from the active directory), or deleted from a group, the entry is still in the table <CMOBJPROPS33>.

How can I know - while looking in the CMOBJPROPS..X.. tables - that the user has been deleted ?
I have also set up the log service in a schema of my DB, but it seems that I can't find some informations of this kind in the existing tables.

Even with a SDK thing, it should be pointing to somewhere to get the informations, isn't it ?

Thanks,
Regards,
Vinc.

[MFGF]

It would be easier just to fire off a content maintenance task to identify the content belonging to the deleted users.  Is there any reason this would not be an option?

Regards,

MF.

[Sunchaser]

Hi MFGF,

Thanks for your answer.
I'm a little bit confused, and sorry to have to ask this but ... what do you mean by "content maintenance task" ?

Regards,
Vinc.

[RobsWalker68]

Hi Vinc,

MF is referring to the "New Content Maintenance" task in Cognos administration.  This will highlight those users who have been deleted from your authentication providor (AD in your case) but still exist in Cognos. 

It has two options, 'Find' and 'Find and Fix'.  Find will display those users while Find and Fix will in addition remove them from Cognos for you.

To run it:

1.Launch Administration
2.Click on the configuration tab
3. Click on the New Content Maintenance icon (top right)
4. Choose New Consistency Check

Cheers

Rob

[MFGF]

Yep - just like Rob says! :-)

Cheers Rob!!  I'm looking at a trip to Edinburgh again in the next few weeks if you're about?

MF.

[RobsWalker68]

Hi MF

I'm in Chorley at the moment but should be back by then so we will catch up for a few beers

Cheers

Rob

[Lynn]

Yep - just like Rob says! :-)

Cheers Rob!!  I'm looking at a trip to Edinburgh again in the next few weeks if you're about?

MF.

Hi MF

I'm in Chorley at the moment but should be back by then so we will catch up for a few beers

Cheers

Rob

I would crash the party if this pesky Atlantic ocean were not in the way   :D

[MFGF]

I would crash the party if this pesky Atlantic ocean were not in the way   :D

You are more than welcome any time!! :)

[Sunchaser]

Hi all

Thank you all for your answers and explanations.
This "content store maintenance" was exactly what I needed. Perfect.

Now it is time for me too to drink a beer...

Thanks again
Regards
Vinc.

[Sunchaser]

Dear all,

Finally, I'm back on this topic, as I still have some problems.
Let's say that there was a user named "Bean", which use to have access to Cognos, but not know.
He still has a LDAP identity, but he is not anymore recorded in any group / role in Cognos.

My problem is the following: why do this user is still existing in the table cmobjprops33 ?
I'm nearly sure that the last time I ran the Content store maintenace, it has solved the problem and that one user removed from Cognos finally disappeared from this "bloody" table.

Do you have any idea on how this table is managed ?

Thanks,
Regards,
Vincent.

[RobsWalker68]

Hi Vincent,

The user will still appear as they have a valid LDAP entry.  The content maintenance find and fix task will remove those users who no longer have an LDAP entry.

In Cognos Connection

1. Go to Administration -> Click on Security tab
2. Click on your LDAP namespace and find user.
3. Click more and then choose "Delete this users profile"

This will then remove the user from cmobjprops33

Rgds

Rob

[Sunchaser]

Hi,

Thank you for your answer, and sorry for the delay.

I have finally found the solution with  "Delete this users profile" in between, I was searching and searching, it was driving me crazy and I forgot to take a look back to this topic.

Do you know if there is any solution in order to do this "step" automatically or programmatically,with SDK / Java, for example ?

Thanks
Regards,
Vincent.