SharePoint Farm Reporter requires Microsoft SharePoint Server 2013 / 2010 / 2007 to be installed locally to connect to the SharePoint Server. SharePoint Farm Reporter does not have a web interface or client application interface to generate reports. SharePoint reporting can be setup & configured once within SharePoint Farm Reporter product and the reports can be distributed to the respective SharePoint users in the following manner:
No. SharePoint Farm Reporter only connects to the local SharePoint farm, where SharePoint Farm Reporter application is installed. The local computer should be running Windows Server 2012 / 2008 / 2003 with Microsoft SharePoint Server 2013 / 2010 / 2007 for SharePoint Farm Reporter to function properly.
If you are using SharePoint in a web server farm, SharePoint Farm Reporter must be installed in the front-end web server / application server running SharePoint 2007 / 2010 / 2013. For STS log file based reports, you must enable usage logging in all front-end servers for SharePoint Farm Reporter to generate the relevant reports for the corresponding web servers.
SharePoint Farm Reporter will connect to the specified SQL Server based on authentication mode and user credential to manage its own application databases. To connect to SQL Server, SharePoint Farm Reporter uses the relevant user accounts based on the authentication mode as listed below:
Windows Authentication: SharePoint Farm Reporter uses the currently logged on user account while running Quick Reports (under interactive mode) and uses 'Run As' account while running Power Reports task to authenticate the user in SQL Server.
SQL Authentication: SharePoint Farm Reporter uses the specified SQL user account for running Quick Reports and Power Reports tasks. SharePoint Farm Reporter stores the SQL user name and password as a user profile in Stored User Names and Passwords or Credential Manager Applet for its usage. Read Profile Manager section in the application help file for more details.
SharePoint Farm Reporter creates a user profile in Windows Stored User Names and Passwords applet to store the SQL user context for generating reports. Read Profile Manager in the application help document for more details.
By default, SharePoint Farm Reporter uses the currently logged on user context to connect to a SharePoint server. The currently-logged-on-user should be a Member of Administrator's group (highly recommended) to access all resources in SharePoint.
SharePoint Farm Reporter stores the data in the local application database, once it gathers the data from SharePoint for the first time. SharePoint Farm Reporter displays data from the local data store until the data is refreshed. To “Refresh” data, click ‘Refresh’ from the menu/toolbar.
Yes. SharePoint Farm Reporter allows you to select the desired report fields (report columns) by using the Custom View tool. You can use the Quick Filter tool to filter the data that needs to be shown in the reports.
You can use the Publish feature available in SharePoint Farm Reporter to publish your reports to a SharePoint document library in the following format: HTML, XLSX and CSV. Please ensure the user context (running SharePoint Farm Reporter) has sufficient permissions to store files in the target document library.