SharePoint Farm Reporter FAQs

Home :: Products :: SharePoint :: SharePoint Farm Reporter

5.0.6261

Does SharePoint Farm Reporter have a client application or web interface to generate reports?

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:

Users can access SharePoint Farm Reporter application installed in SharePoint Server using remote desktop software from a client computer or terminal server.
Use Publish feature to generate reports and publish them to a SharePoint library. The reports can be generated using Quick Reports (interactive mode) and Power Reports (schedule mode) features and have them published to the desired destination SharePoint library. The published reports can be viewed using a standard web browser, as you view any other SharePoint document library contents.
Use E-mail delivery option to e-mail the reports to any user mailbox or distribution group or mail-enabled public folder.

Can I connect to a remote SharePoint Server / Farm using SharePoint Farm Reporter?

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.

Where should I install SharePoint Farm Reporter in the SharePoint server farm?

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.

Does SharePoint Farm Reporter require SQL Server to generate reports?

Yes, SharePoint Farm Reporter requires SQL Server 2005 / 2008 / 2012 (Enterprise / Standard / Developer / Express editions) to connect and create a database.

What user account does SharePoint Farm Reporter use while accessing the SQL Server?

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.

How does SharePoint Farm Reporter manage user accounts to connect to SQL Server?

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.

What user credentials does SharePoint Farm Reporter use to connect to a SharePoint server?

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.

How do I refresh the data for the displayed report?

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.

What permissions or privileges are required to view information about SharePoint on the server?

To view information about SharePoint, the currently logged on user must:

be a valid domain user to view basic information.
be a member in the Administrators group of the target server to view privileges, services and system resources.
read permissions in the SQL Server databases to read the web application and site details.
should be the member of SPS_WPG group for reading Single Sign-on details.

Can I create a custom view for a report in SharePoint Farm Reporter?

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.

Can I publish SharePoint Farm Reporter reports to a SharePoint document library?

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.

Testimonials

We have launched our SharePoint installation and soon learned, that we lack proper administration tools. Our main problem was to keep track of alerts which we as administrators have put into the system to keep certain group of users informed (push alerts). Searching the internet we have spotted ARKSP Admin Report Kit for SharePoint which promised to solve our problems. After downloading and testing we soon found, that ARKSP is indeed returning the information we have been looking for in an easy and understandable way. What we have appreciated most is the responsiveness of the VYAPIN Support. We had encountered a few problems to add specific filters and in printing the information found. Within very few hours VYAPIN responded and sorted out our problems at once. We are very happy to have found this valuable tool.

CFO and CIO, TREUCO Treuhand-Gesellschaft, Switzerland
We have launched our SharePoint installation and soon learned, that we lack proper administration tools. Our main problem was to keep track of alerts which we as administrators have put into the system to keep certain group of users informed (push alerts). Searching the internet we have spotted ARKSP Admin Report Kit for SharePoint which promised to solve our problems. After downloading and testing we soon found, that ARKSP is indeed returning the information we have been looking for in an easy and understandable way. What we have appreciated most is the responsiveness of the VYAPIN Support. We had encountered a few problems to add specific filters and in printing the information found. Within very few hours VYAPIN responded and sorted out our problems at once. We are very happy to have found this valuable tool.

CFO and CIO, TREUCO Treuhand-Gesellschaft, Switzerland
We have launched our SharePoint installation and soon learned, that we lack proper administration tools. Our main problem was to keep track of alerts which we as administrators have put into the system to keep certain group of users informed (push alerts). Searching the internet we have spotted ARKSP Admin Report Kit for SharePoint which promised to solve our problems. After downloading and testing we soon found, that ARKSP is indeed returning the information we have been looking for in an easy and understandable way. What we have appreciated most is the responsiveness of the VYAPIN Support. We had encountered a few problems to add specific filters and in printing the information found. Within very few hours VYAPIN responded and sorted out our problems at once. We are very happy to have found this valuable tool.

CFO and CIO, TREUCO Treuhand-Gesellschaft, Switzerland

Do you have any queries?

Ask Us

Installation Guide

User Manual

Brochure

Online Help

SharePoint Farm Reporter

Do you have any queries?

Customers also tried: