User Report to distinguish between Named vs. Concurrent...

[ShawnPDuffy]

I am using BOXI, and I have some concurrent licenses that are still active. I also have some named user licenses that I have released out to 28 people. Unfortunately, I must have handed out 1 too many and cannot find the erroneous user with named user access.

How do I get a list of users that have named user access?

-Shawn

 

[Turkbear]

Hi,
In the CMC, you can look at each user account and see what type it is. This is manual, but with only 28 to check, maybe it would be practcal..



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ShawnPDuffy]

Actually, there are several hundred that would need to be checked in order to find the erroneous 29th named user.

-Shawn

 

[Turkbear]

Hi,
Oh..Never mind..
Actually, if the CMC can get that data, it must be somewhere that can be queried through an InfoStore connection..I do not know what object it would be part of , however..Perhaps BObj's support can help.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ShawnPDuffy]

I have unsuccessfully tried that as well.

Thanks for the attempts,
Shawn

 

[synapsevampire]

I use the Tracing in SQL Server to reverse engineer queries fairly often, perhaps that can help you.

Turn it on, run the request from CE, and then go look at the resulting query...a thought anyway...

-k

 

[ShawnPDuffy]

Does that work to pull out the Binary information? I have access to the System Database, but a majority of the data is inaccessible.

-Shawn

 

[mdwyer]

Go to your query builder and enter
select si_name, si_nameduser from CI_systemOBJECTS where si_nameduser != 0

 

[ShawnPDuffy]

Exactamundo!

Thanks a bunch. Just curious, do you know if there is a database schema diagram for the system database anywhere? I know of the Audit database schema diagram, but have not seen anything similar for the System database.

-Shawn

 

[Turkbear]

Hi,
The system database does not have a 'standard' schema design. That is why the Query through the InfoStore object is needed...The SDK docs ( or the Com docs) describe the Objects and the collection of properties each has, but, if you look at the the main DataTable created by the CMS,

Oracle example:

SQL> desc CECMS.CMS_INFOOBJECTS3
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OBJECTID                                  NOT NULL NUMBER(38)
 SI_HIDDEN_OBJECT                                   NUMBER(38)
 SI_RECURRING                                       NUMBER(38)
 SI_NAMEDUSER                                       NUMBER(38)
 SI_RUNNABLE_OBJECT                                 NUMBER(38)
 SI_PLUGIN_OBJECT                                   NUMBER(38)
 SI_INSTANCE_OBJECT                                 NUMBER(38)
 SI_GUID                                            VARCHAR2(56)
 SI_CUID                                            VARCHAR2(56)
 SI_RUID                                            VARCHAR2(56)
 SI_TABLE                                           NUMBER(38)
 PARENTID                                  NOT NULL NUMBER(38)
 TYPEID                                    NOT NULL NUMBER(38)
 OWNERID                                   NOT NULL NUMBER(38)
 LASTMODIFYTIME                            NOT NULL VARCHAR2(32)
 OBJFLAGS                                  NOT NULL NUMBER(38)
 USERFLAGS                                          NUMBER(38)
 SCHEDULESTATUS                                     NUMBER(38)
 NEXTRUNTIME                                        VARCHAR2(32)
 OBJNAME                                            VARCHAR2(255)
 OBJNAMEISTRUNCATED                        NOT NULL NUMBER(38)
 ALIASES                                            RAW(255)
 CRC                                       NOT NULL VARCHAR2(32)
 PROPERTIES                                NOT NULL BLOB

you can see the most of the relevant properties are in a Binary Large Object ( BLOB) field and not directly accessable.







To Paraphrase:"The Help you get is proportional to the Help you give.."