Skip to main content
Solved

Tenant Creation Date


  • Freshman I
  • 2 replies

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.

Best answer by Kandy Beatty

Hi @kenr  and @RohitBhandurge 

Here is a quick GI that may help:

 

 

View original
Did this topic help you find an answer to your question?

10 replies

RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

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


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

@kenr - UPHistory gave me this information.

 

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


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • September 23, 2022
RohitBhandurge wrote:

@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 


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img
kbeatty21 wrote:
RohitBhandurge wrote:

@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.

 


  • Author
  • Freshman I
  • 2 replies
  • September 23, 2022

@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
Jr Varsity III
Forum|alt.badge.img
kenr wrote:

@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.


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • Answer
  • September 23, 2022

Hi @kenr  and @RohitBhandurge 

Here is a quick GI that may help:

 

 


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img
kbeatty21 wrote:

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.


  • Author
  • Freshman I
  • 2 replies
  • September 23, 2022

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

@RohitBhandurge Thank you for finding the table.


khalme
Freshman II
  • Freshman II
  • 7 replies
  • September 23, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings