About
MikkiMilligan
Rank:
Community Explorer
Title:
Joined:
Jun 13, 2023 4:54:09 AM
Posts:
8
Solutions:
0
Likes Received:
22
Bio:
An amazing Instructure Community member
Most Liked Posts
We are migrating from CD1 to CD2. In the accounts table the depth_of_account column is a calculation. Does anyone have SQL script to calculate the depth_of_account hierarchy and the subaccount_ids? Cu...
Thank you for your reply.
How the Account_Dim table in CD1 is set up the depth in account are related to
Root Account = University; Depth = 0
Subaccount 1 = Campus; Depth = 1
Subacco...
I believe user_account_associations is a new table. I do not think this table or user_account_settings should be joined and used to calculate the depth in account as mentioned in the Public CD1 to CD2...
Hello,
I've attached an example of the Depth in Account levels we are trying to calculate.
Root Account = University
Subaccount 1 = Campus
Subaccount 2 = College
Subaccount 3 = D...
Sorry - we are not using Splunk.
Hello,
The Canvas 1 to Canvas 2 documentation states Depth in Account is a calculated field:
DepthSetting=20 . The "depth" field in CD2 table: "user_a...
Most Recent Posts
Thank you for your reply.
How the Account_Dim table in CD1 is set up the depth in account are related to
Root Account = University; Depth = 0
Subaccount 1 = Campus; Depth = 1
Subacco...
I believe user_account_associations is a new table. I do not think this table or user_account_settings should be joined and used to calculate the depth in account as mentioned in the Public CD1 to CD2...
Hello,
I've attached an example of the Depth in Account levels we are trying to calculate.
Root Account = University
Subaccount 1 = Campus
Subaccount 2 = College
Subaccount 3 = D...
Sorry - we are not using Splunk.
Hello,
The Canvas 1 to Canvas 2 documentation states Depth in Account is a calculated field:
DepthSetting=20 . The "depth" field in CD2 table: "user_a...
Hello,
I tried your script and it does not provide the correct results. The Canvas 1 to Canvas 2 documentation states Depth in Account is a calculated field:
DepthSetting=20 . The "depth"...
Latest Badges
10 Logins Completed
2024-01-25
5 Logins Completed
2024-01-25
First Login Completed
2024-01-25
5 Replies Posted
2024-01-05