Skip to main content

Is there a way to find the creation date of a tenant?  We’re interested in knowing the creation dates for the tenants in our sandbox.  Thanks.

@kenr - Surprised to see there is no table called UPCompany in the sql.


@kenr - UPHistory gave me this information.

 

There should be a way to pull this on the front end. You can pull this in GI.


@kenr - UPHistory gave me this information.

 

There should be a way to pull this on the front end.

The only thing to add is that you would need SQL access @kenr 


@kenr - UPHistory gave me this information.

 

There should be a way to pull this on the front end.

The only thing to add is that you would need SQL access @kenr 

@kbeatty21 @kenr - Right. You can write a GI for “UPHistory” table.

 


@RohitBhandurge

“There should be a way to pull this on the front end.”

 

That’s what I’m looking for, but haven’t found it.


@RohitBhandurge

“There should be a way to pull this on the front end.”

 

That’s what I’m looking for, but haven’t found it.

Try with a GI for UPHistory.


Hi @kenr  and @RohitBhandurge 

Here is a quick GI that may help:

 

 


Hi @kenr  and @RohitBhandurge 

Here is a quick GI that may help:

 

 

@kbeatty21 - This could do the job since UPHistory is the only table keeping the history of tenants.


@kbeatty21 Thank you!  The GI is very helpful.  I appreciate your help.

@RohitBhandurge Thank you for finding the table.


Another option, if you only need to quickly find the dates, is to use the Source Data link on the Schema Browser (if your version has it).

 


Reply