Hi,

 

We have an issue with the number of sites that are imported from AD, some of them are typo's that should not exist.  I am trying to cleanse them, however in order to get it to be permanently deleted and not re-imported every evening, I would need to know where the information is being pulled from.  So is there a query that could be run to a) show me all the sites that i can easily export to excel and b) show me which account the site is being pulled from?

 

Thanks Lynne