Audit PowerPivot and PerformancePoint - are they being used?

%3CLINGO-SUB%20id%3D%22lingo-sub-724050%22%20slang%3D%22en-US%22%3EAudit%20PowerPivot%20and%20PerformancePoint%20-%20are%20they%20being%20used%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724050%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20doing%20an%20audit%20of%20SP2013%20environment.%20I%20can%20see%20the%20service%20applications%20and%20configuration%20for%20PowerPivot%20and%20PerfPoint%20are%20all%20set%20but%20I%20need%20to%20understand%20if%20they%20are%20being%20used%20at%20all.%3C%2FP%3E%3CP%3EMy%20understanding%20is%20that%20you%20can%20have%20data%20connections%20(e.g.%20from%20Excel)%20to%20external%20databases%20and%20display%20the%20results%2Fdashboards%20in%20SharePoint.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20find%20if%20those%20services%20are%20being%20used%3F%20e.g.%20do%20I%20need%20to%20find%20specific%20files%20like%20data%20sources%20or%20data%20connections%3F%20what%20type%20of%20files%20would%20I%20need%20to%20look%20for%3F%3C%2FP%3E%3CP%3EAny%20other%20tip%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-724050%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPower%20Pivot%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esharepoint%202013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%202013%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hi,

I am doing an audit of SP2013 environment. I can see the service applications and configuration for PowerPivot and PerfPoint are all set but I need to understand if they are being used at all.

My understanding is that you can have data connections (e.g. from Excel) to external databases and display the results/dashboards in SharePoint.

Is there a way to find if those services are being used? e.g. do I need to find specific files like data sources or data connections? what type of files would I need to look for?

Any other tip welcome

0 Replies