| |
|
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, click ‘Refresh’ 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
|