Identifying all datasets connected to a credentials account

Colemen
Colemen Member
edited March 2022 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?

Screen Shot 2022-03-16 at 11.43.17 PM.png


Comments

  • MarkSnodgrass
    MarkSnodgrass Coach

    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.

    **Check out my Domo Tips & Tricks Videos

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

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

    image.png
    image.png


    **Check out my Domo Tips & Tricks Videos

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

    That did it! Thank you!

Categories