How to find list of universes belongs to a single user ?

[Former Member]

Hello experts ,

How do I find the list of universes belongs to a single user.

Would you please let me know if you can as soon as possible I am struggling to find out this information.

Regards,

Ne0

[Former Member]

Fixed it with query

[Former Member]

Hello ,

Any updaets on this please

[shiva_vishnubatla]

Neo,

If you are on any of the XI* platforms, you should run a query against the App tables. The query can be run on query builder (XI3.x context /AdminTools). A typical universe query looks like -

Select * from CI_APPOBJECTS where SI_NAME = 'my univ name'

>> This will give you all fields of a typical universe which also should have SI_KIND (universe) and SI_OWNER (owner)

based on this you could build further queries like

Select SI_ID, SI_NAME,"any other fields" from CI_APPOBJECTS where SI_KIND = 'Universe' and SI_OWNER = 'userid'

gives you a list of universes....................

Note: I didnt have a reference when i typed these field/table names - but you get the idea. p

hth

Shiva

[Former Member]

Will try out this and let you know shiva thanks .

Regards,

Neo.