Identifying all datasets connected to a credentials account

Colemen
Colemen ⚪️
edited March 16 in Connectors

There is a credentials account with 506 datasets that we need to go through and tag/deactivate. Unfortunately the only way I've found to see datasets connected to a credential account is to hover over the DataSets section of the credential account. Unfortunately this is limited to ~ 40 datasets which would prevent us seeing the other 460ish datasets. Does anyone know of a DomoGov or DomoStats dataset I may be overlooking that would have this information? Or some other way of listing the datasets?


Comments

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    I believe you need the Datasets from DomoStats and the Accounts dataset from DomoStats. You can then join the Datasets table to the Accounts table on AccountID.

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    I had to set the Account_ID to floating decimal in the datasets configuration so the data type would match, but that was it.


    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Colemen
    Colemen ⚪️

    That did it! Thank you!