cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
3653
Views
15
Helpful
7
Replies

User list for CUIC

Lenny.Cerrone1
Level 1
Level 1

Looking to automate export of user list for CUIC 10.x

 

The CUIC user list is stored on the informix database, not familiar with the schema.

 

I know the ICM database schema pretty well, but not sure about CUIC's internal database.

 

The goal is to be able to export the entire list of all CUIC users.

1 Accepted Solution

Accepted Solutions

Chintan Gajjar
Level 8
Level 8

create a report definition and report from that definition and run and export the result.

CUIC.PNGyour Query should be "Select * from cuicuser"

View solution in original post

7 Replies 7

Chintan Gajjar
Level 8
Level 8

create a report definition and report from that definition and run and export the result.

CUIC.PNGyour Query should be "Select * from cuicuser"

Ha! That's freaking genius, use CUIC to report on CUIC.

 

david

There are more David,

for CUIC collection:

SELECT * FROM CUICCOLLECTION

 

for CUIC collection Value:

SELECT * FROM cuiccollectionvalue

 

for CUIC valuelist:

SELECT * FROM CUICVALUELIST

 

and if you want to look at all the table which CUIC db holds:

 

select * from "informix".systables

 

Create definition for each of the table and you can see what columns they have.


@Chintan Gajjar wrote:

There are more David,


There are indeed.

 

COLLECTIONS

SELECT c.autoupdate
,c.collectionidentifier
,c.collectionorigin
,c.collectiontype
,c.description
,c.id
,c.isactive
,c.lastrefreshed
,c.name as Collection
,c.owner
,c.partition
,c.refreshperiod
,c.sharingpermission
,c.valuelistid
,c.version
,c.wildcardstring
,v.name as ValueList
,v.valuelistquery
,v.collectionquery
,d.name as Datasource
FROM cuiccollection c
JOIN cuicvaluelist v on  c.valuelistid = v.id
JOIN cuicdatasource d on v.datasourceid = d.id

 

GROUP MEMBERS

select g.id
,g.groupfullname
,g.description
,gm.groupid
,u.name
from cuicgroup g
join cuicgroupmember gm on g.id = gm.groupid
join cuicuser u on gm.memberid = u.id

 

SCHEDULED JOBS

select

sr.scheduledreportname

,sr.userid

,u.firstname

,u.lastname

from cuicscheduledreports as sr

join cuicuser as u ON sr.userid = u.id

 

If you use the CLI you can execute "run sql" commands to see the schema. For example

 

run sql select first 1 * from cuic_data:cuicuser

 

Or for simple queries - like to get a list of reports

 

run sql select name from cuic_data:cuicreport

 

Don't forget the cuic_data: when running from the CLI.

 

Regards,

Geoff

 

 

 

Thanks Geoff, always learning something from you.

thanks, I will give that a try

thanks that worked!

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: