How to find which Looks are using a Model

[soumyanaidu]

I need to find out which Looks are using a model. Could someone please tell me how to get this information. I am using Looker version 23.2.24 

Thank you

[hgoscar]

https://YOUR_INSTANCE_URL/explore/system__activity/look?fields=query.model,query.view,look.id,look.link,look.title&f[look.mov...


Replace YOUR_INSTANCE_URL  with your instance xyx.cloud.looker.com

[soumyanaidu]

Thank you so much. That worked. 

For anyone else who is searching for answers to the same question, you can do this too

SELECT
    query.model AS `query.model`,
    query.view AS `query.view`,
    look.id AS `look.id`,
    look.id  AS `look.link`,
    look.title AS `look.title`
FROM look
INNER JOIN query ON look.query_id = query.id
WHERE query.view = 'name of explore goes here'