Forum Discussion

Beth Mahoney's avatar
Beth Mahoney
Brass Contributor
Nov 28, 2018

SharePoint Audit

I have a need to perform an audit of my SharePoint. Generally, I need to know how many "real/authentic" sites I have. When I go into the SharePoint Admin Center, I see ALL SharePoint sites (most are ...
admin
SharePoint Online
jcgonzalezmartin's avatar
jcgonzalezmartin
MVP
Nov 28, 2018
AFAIK, there is not a way to know if a SPO Team Site was created because a Planner Plan was created, a Group was created or a Team was created
  • Dean_Gross's avatar
    Dean_Gross
    Silver Contributor
    Nov 30, 2018

    jcgonzalezmartinthere is some information in the Audit log that shows when a Service Account creates a Site. For example if you go to the Azure AD Audit log, and use Microsoft Teams Services as the Actor, you will find every that account did.

    If you choose Add Group as the Activity, it will show all of the different account that have been used.

     

    It is tricky and poorly documented, the filters seem to be "Case Sensitive" which makes it even more difficult

  • Anonymous's avatar
    Anonymous
    Nov 28, 2018

    I think this script can help you detect how many sites originated from MS Teams and how many from other apps and also inactive groups based on activity. You can also find powershell script for yammer originated groups but not other sources yet i guess.

     

    https://gallery.technet.microsoft.com/Check-for-obsolete-Office-c0020a42

     

    • Beth Mahoney's avatar
      Beth Mahoney
      Brass Contributor
      Nov 30, 2018

      Ok, thanks so much. This seems a bit complicated. I spoke with MS, they indicated they are working on an interface. But we'll have to see how that goes. Reporting has always be very lacking with SharePoint. I hope they are working on making it easier for those of us who have to provide statistical analysis. Thanks again.

Resources