Vyapin Software Systems

Microsoft Network Partner

 
 
 
     
 
ARK for SharePoint 2010 (ARKSP)
Version 1.8

Last Updated: April 30, 2012

 

Sharepoint Server 2010

 

Frequently Asked Questions

  1. What resources does ARKSP report?
  2. Can you explain ARKSP license model?
  3. Does ARKSP have a client application or web interface to generate reports?
  4. Can I connect remote SharePoint using ARKSP?
  5. Where should I install ARKSP in the SharePoint server farm?
  6. Does ARKSP require SQL Server to generate reports?
  7. What user account does ARKSP use while accessing the SQL Server?
  8. How does ARKSP manage user accounts to connect to SQL Server?
  9. What user credentials does ARKSP use to connect to SharePoint?
  10. What permissions or privileges are required to view information about SharePoint?
  11. How do I refresh the data for the displayed report?
  12. What value does the 'Last Modified' field in the Summary report under Site report category signify?
  13. I am unable to view the 'Page Hits', 'Site Visitors' information in the Site report category and 'List Hits Summary', 'List Visits' information in the List report category.
  14. I am unable to view the 'Page Visits' information in the 'Virtual Server' report category and 'Last Deleted Items' information in the 'List' report category.
  15. Can I create a custom view for a report in ARKSP?
  16. Can I print and export reports?
  17. Can I run a report at periodic intervals in ARKSP?
  18. Can I create multiple tasks scheduled to run at the same time in Power Reports tool?
  19. Can I view the history information for a task created using Power Reports?
  20. Can I publish ARKSP reports to a SharePoint document library?
  21. The application error log file "ARKSPErrorLog.txt" is gradually increasing in size. Can I delete it?
  22. Why do I get empty value for the 'Disk Size Required for Backup' field in Content Databases report?
  23. For how many days, can I generate Change Log Reports (‘Newly Added Items’, ‘Last Modified Items’, ‘Last Deleted Items’ and ‘List Activity’) in ARKSP?
  24. I am unable to run a Power Reports task at the scheduled time interval when the user is not logged on to the server running Windows Server 2008 x64. What can I do to fix this problem?
  25. Can ARK for SharePoint 2010 Power Reports tasks be invoked from the command line?
  26. What permission is required to view "Change Log Reports"?
  27. Why do I get an error while exporting a report to MDB format? 
 

1.

What resources does ARKSP report?

ARKSP reports about the following resources from a Microsoft SharePoint Server 2010: Web Applications, Site Collections, Webs and Lists.

Top

2.

Can you explain ARKSP license model?

ARKSP license model is based on the number of computers on which you will install ARKSP. Server License means per Front-end Web Server. Please note that ARKSP requires Windows Server 2008 running Microsoft SharePoint Server 2010 (or) Microsoft SharePoint Foundation 2010 for it to generate reports.

Top

3.

Does ARKSP have a client application or web interface to generate reports?

No. ARKSP does not have a web or client application interface to generate reports. ARKSP requires Microsoft SharePoint Server 2010 (or) Microsoft SharePoint Foundation 2010 to be installed locally to connect to the SharePoint Server. You may consider using the following method or feature to overcome this situation:

a.

Access ARKSP tool (installed in SharePoint Server) using a remote desktop software from a remote client machine. 

b.

Use 'Publish' feature available in ARKSP to view the reports from a remote client machine. Using the Publish feature, you can 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 web browser as you view any other SharePoint library contents. 

c.

Use 'E-mail' delivery option available in ARKSP to e-mail the reports to any user mailbox or a public folder. The reports can be generated using 'Power Reports' (schedule mode) feature in ARKSP and have the reports e-mailed to the desired set of users and public folders.

Top

4.

Can I connect to remote SharePoint Server using ARKSP?

No. ARKSP only connects to local SharePoint, where ARKSP is installed. The local computer should be running Windows Server 2008 with Microsoft SharePoint Server 2010 (or) Microsoft SharePoint Foundation 2010 for ARKSP to function properly.

Top

5.

Where should I install ARKSP in the SharePoint server farm?

If you are using SharePoint in a web server farm, please ensure ARKSP is installed in the front-end web server / application server running Windows SharePoint Services, 64-bit platform for the application to work correctly. For IIS log file based reports in ARKSP, you can install ARKSP in any one of the front-end servers / application servers in your server farm environment. For STS log file based reports, you must enable usage logging in all front-end servers for ARKSP to generate the relevant reports for the corresponding web servers.

Top

6.

Does ARKSP require SQL Server to generate reports?

Yes, ARKSP requires SQL Server 2005 or SQL Server 2008 (Enterprise / Standard / Developer / Express editions) to connect and create a database. ARKSP uses SQL Server database for its data storage to generate SharePoint reports.

Top

7.

What user account does ARKSP use while accessing the SQL Server?

ARKSP 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, ARKSP uses the relevant user accounts based on the authentication mode as listed below:

Windows Authentication: ARKSP uses the currently logged on user account while running Quick Reports (under interactive mode) and uses 'Run As' account while running Power Reports task (run as a scheduled task or using Run Now option) to authenticate the user in SQL Server.

SQL Authentication: ARKSP uses the specified SQL user account and password for running Quick Reports and Power Reports tasks. ARKSP stores the SQL user name and password as a user profile in 'Stored User Names and Passwords' applet for its usage. Read Profile Manager in the application help file for more details.

Top

8.

How does ARKSP manage user accounts to connect to SQL Server?

ARKSP creates an 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.

Top

9.

What user credentials does ARKSP use to connect to a SharePoint server?

By default, ARKSP 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.

Top

10.

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

Top

11.

How do I refresh the data for the displayed report?

ARKSP stores the data in the local application database, once it gathers the data from SharePoint for the first time. ARKSP displays data from the local data store until the data is refreshed. To “Refresh” data, clickRefresh’ from the menu/toolbar

Top

12.

What value does the 'Last Modified' field in the Summary report under Site report category signify?

The 'Last Modified' column shows the date on which the site was last modified. The modification to the site includes only the modification to any of the items in the site.

Top

13.

I am unable to view the 'Page Hits', 'Site Visitors' and 'Site Hits Summary' information in the Site report category and 'List Hits' information in the List report category.

To view the said information, enable the "Processing Settings" and "Logging Settings" options in Configure Usage Analysis Processing in the SharePoint Central Administration.

Top

14.

I am unable to view the 'Page Visits' information in the 'Web Application' report category, 'List Visits' and 'Last Deleted Items' information in the 'List' report category.

To view the said information, enable the "Enable Logging" option in the desired web application in IIS.

Top

15.

Can I create a custom view for a report in ARKSP?

Yes. ARKSP allows you to select the desired fields available in rows & columns using the 'Custom View' and 'Quick Filter' tools respectively and display the selected fields and values in the report.

Top

16. Can I print and export reports?

Yes. ARKSP allows you to preview the report, set print options and finally print the reports in the desired layout. You may also export the report data and save it in HTML, XLS, CSV, MDB, TIFF and PDF formats.

Top

17.

Can I run a report at periodic intervals in ARKSP?

Using the Power Reports tool, you can schedule reports to run at scheduled intervals. Refer to Power Reports section in ARKSP Help for more information.

Top

18.

Can I create multiple tasks scheduled to run at the same time in Power Reports tool?

Yes, ARKSP allows you to create multiple tasks scheduled to run at the same time.

Top

19.

Can I view the history information for a task created using Power Reports?

Yes, ARKSP allows you to view the history information for a task created using Power Reports. To view, go to Power Reports->Task Activity View. You can view the task run times, reports and URLs configured in the task and exported files in the history.

Top

20.

Can I publish ARKSP reports to a SharePoint document library? 

You can use the Publish feature available in ARKSP to publish your reports to a SharePoint document library in the following format: HTML, XLS, CSV, MDB, TIFF and PDF. Please ensure the user context (running ARKSP) has sufficient permissions to write content to the specified document library.

Top

21.

The application error log file "ARKSPErrorLog.txt" is gradually increasing in size. Can I delete it?

Yes, you may manually delete this error log file when ARKSP is not running. ARKSP generates an error log file in the Log folder in the application path (<Application Data Folder>\ARKSP2010). The error log file tends to increase in size over a period of time especially if the application meets with frequent error conditions. The application does an "append" to the error log each time it runs. This is required for diagnostic purposes during trouble shooting. You may delete the error log file periodically.

Top

22.

Why do I get empty value for the 'Disk Size Required for Backup' field in Content Databases report?

This is primarily due to insufficient permissions for the user account to retrieve the 'Disk Size Required for Backup' data. The currently logged on user (in Quick reports) or the Run As user (in Power Reports ) should have sufficient permissions to access that data. An application pool account can show the correct data for the specific web application. If the currently logged on user is an administrator in both SharePoint server and SQL server, you can view the exact size for all the web applications.

Top

23.

For how many days, can I generate Change Log Reports (‘Newly Added Items’, ‘Last Modified Items’, ‘Last Deleted Items’ and ‘List Activity’) in ARKSP?

Using ARKSP, you can generate change log based reports for the maximum duration (days) the change log data is maintained in the content database. The last date from which log data is maintained in the content database can be determined as follows:

[Last run time of the timer job corresponding to the web application - Number of days in Change Log retention settings]

If the number of days or the date range specified exceeds the resultant date, ARKSP will throw the 'As per the Change Log configuration, << REPORT_NAME >> report can be generated for << MAXIMUM_DAYS >> days only. Refer Change Log Reports help section for more information.' message. 

If there is no data available in the specified input days / date range, ARKSP reports the ‘No record found’ message.

Top

24.

I am unable to run a Power Reports task at the scheduled time interval when the user is not logged on to the server running Windows Server 2008 x64. What can I do to fix this problem?

For the Power Reports task to run under logged off state in Windows Server 2008 x64 platform, enable 'Run with highest privileges' flag for the corresponding scheduled task in Windows Task Scheduler.

Top

25.

Can ARK for SharePoint 2010 Power Reports tasks be invoked from the command line?

Yes, ARKSP can invoke its Power Reports tasks from DOS command prompt anytime after the task has been created using Power Reports task wizard. Please refer to the relevant sections in the application help file for more information.

Top

26.

What permission is required to view "Change Log Reports"?

To view Change Log Reports, you must use the application pool account of central administration web application to view all information.

Top

27.

Why do I get an error while exporting a report to MDB format? 

MDB format export is supported in x86 platform only. Since Microsoft does not ship Microsoft Jet providers in Windows x64 platform (used by ARKSP), MDB export format will not work correctly. You can overcome this limitation by exporting the report to CSV format and re-importing the CSV file manually into MDB format if required.

Top

 
     
   
Try and Buy

Download 30-day trial

ARKSP for SharePoint tour

Product Tour (Video)
Purchase Info
Buy Now *
   

* Starting at $1099 

  Perpetual license

 
 
 
 
solutions products support purchase resources company
SharePoint Migration SharePoint Product FAQ Product Purchase Downloads About Us
SharePoint Management Active Directory Software Upgrade Policy Partners& Resellers Case Studies Customers
Windows Audit & Reporting Windows Request License Key Custom Quote Request Product Tours Alliances
Application Audit & Reporting Exchange Software Registration   Sample Reports Testimonials
  IIS Contact Tech Support   Product Brochures Contact Us
    Software Feature Request   Online Help Site Map
        User Manuals Privacy Policy
        White Papers & Data Sheets  

Copyright © 1998-2012 Vyapin Software Systems (P) Ltd. All rights reserved.