Custom Property size

[Naveen]

Hi,

What is the size limit for customproperty. If we can create a customproperty with the type as blob, what will be the maximum size of it.

Thanks,

Naveen

[dgandhi]

Hi @Naveen 

Customproperty of which object? Users , accounts , entitlement_values or endpoints.

You can check the size of the customproperty from DB or Data analyser

Thanks

[pruthvi_t]

Hi @Naveen ,

In EIC, based in the object, we have few columns which are varhcrar(255) and to store bigger values which need a bigger datatype than varchar(255), we have few columns with datatype longtext.

In general a blob datatype column would allow around 65kb of data to be stored. Also by product design and guidelines, we are not allowed to create any new custom property or change the data type of the any existing customproperty  from the schema that ships with product.

Thanks,

[DixshantValecha]

Regarding the customproperty, I would like to clarify that it pertains to the following objects: Users, Accounts, Entitlement_Values, or Endpoints. To determine the size of the customproperty, you have the option to check the database (DB) or utilize a data analyzer.

Please refer to the attached image for further information.

[Naveen]

Thanks, however when I run desc Saviynt.accounts on DB analyser, I get cannot execute command error.

[rushikeshvartak · Accepted solution]

Hover over i icon in data analyzer

[dgandhi · Accepted solution]

Hi @Naveen 

There are 2 options:

1st Option:

Create one analytics with query like desc users

Run the analytics and in history you should be able to see all the required information.

2nd Option:

In Data analyzer, on left side when you navigate to the table name and expand it, you should see the column name and in the i icon , you should get more details about the column (whether it is longtext or varchar)

Hope this helps.

Thanks

[Naveen]

Option 1: I get the attached error (saying only select commands allowed).

Option 2: I have admin role and when I hover, I do not get any info when I hover over i

Thanks,

Naveen

[pruthvi_t · Accepted solution]

@Naveen ,

desc of any table is restricted from analytics. You can only use select queries to be run from analytics.

For data analyzer, please do not click on the i icon, but just hover over it for the column you're trying to find the data type for and you should be able to see it. 

Thanks,

[dgandhi]

Hi @pruthvi_t 

Is this something changed post 5.5?

I am using Saviynt 5.5 SP3 and in my env, I am able to desc any table from analytics.

Thanks

[Naveen · Accepted solution]

Thanks @pruthvi_t  & @rushikeshvartak and @dgandhi for sortin