Vyapin Software Systems
 
 
 
 
     
 
Admin Report Kit for SharePoint 2007 (ARKSP)
Version 3.7.1

Last Updated: July 7, 2010

 

Sharepoint Server 2007

Windows Sharepoint Services

 

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?
 

1.

What resources does ARKSP report?

ARKSP reports about the following resources from a Microsoft Office SharePoint Server 2007 (MOSS 2007) and Windows SharePoint Services 3.0: 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 / Windows SharePoint Services 3.0 installed server. Please note that ARKSP requires Windows Server 2003 / Windows Server 2008 running Microsoft Office SharePoint Server 2007 (MOSS 2007) / Windows SharePoint Services 3.0 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 Windows SharePoint Services 3.0 / Microsoft Office SharePoint Server 2007 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 machine should be running Windows Server 2003 / Windows Server 2008 with Microsoft Office SharePoint Server 2007 (MOSS 2007) or Windows SharePoint Services 3.0 (WSS 3.0) 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, 32-bit / 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 (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 application path (e.g., "C:\Program Files\ARKSP2007\Log"). 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, 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.

For further information, you can refer to “Change Log Reports” section in the online help file installed with the application, which can be launched from Help menu in the application.

Top

 
     
   
Try and Buy

Free 15 Day Trial

 

Try it now. Get a free trial for 15 days. 

Sharepoint 2007 Reporting Tool Trail Download Download
 

 

Ready to purchase?

Sharepoint 2003 Reporting Tool Online Purchase Buy Now

 
 
Customer Speak
 

"Thanks, nice product, I tested it! Great report."
MVP SharePoint
 

"It seems like a cool application to get quick, concise information about your SharePoint environment in a one-stop shop place. It does a good job giving you a snapshot." 
Government of British Columbia, CANADA

 
 
 
 
 

Copyright © 1998-2010 Vyapin Software Systems (P) Ltd. All rights reserved.   Site Map   Privacy Policy