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...
Likes: 22
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...
Likes: 0
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...
Likes: 0
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...
Likes: 0
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...
Likes: 0

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...
Jun 22, 2023 2:29:56 PM
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...
Jun 21, 2023 2:22:54 PM
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...
Jun 21, 2023 4:52:58 AM
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...
Jun 20, 2023 8:17:53 AM
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"...
Jun 20, 2023 8:17:06 AM

Latest Badges

10 Logins Completed

10 Logins Completed

Earned: 2024-01-25

5 Logins Completed

5 Logins Completed

Earned: 2024-01-25

First Login Completed

First Login Completed

Earned: 2024-01-25

5 Replies Posted

5 Replies Posted

Earned: 2024-01-05