In the Solr console, we would see for each site there are two indexes for a catalog. SolrIndex table holds information on which is active. To get the Active index information, run this below query. select
{c.name},
{it.identifier},
{i.active},
{i.qualifier}
from…