How to – FAQ

If you purchased your consultant subscription using an email address issued from Gmail, Yahoo, Hotmail, or a “Catch-all” email address like support@abc.com, or ITprofessionals@abc.com, you will not be able to activate your subscription with Acceleratio. Activation requires a company issued email registered to a single user.
If you were not able to activate your subscription, please contact us, and include the following:

  1. The Order ID reference number of the purchased license.
  2. A company issued email address.
  3. Your first and last name.

Please note: Owing to the consultant subscriptions EULA, only one consultant can use this license and the license can only be for services provided to third-party companies. It cannot be used on internal company farms. This is the reason we require a name and a business issued email address in the end user’s name to activate the license. Thank you for your understanding.

Problem:

How do I cancel my SPDocKit subscription?

Solution:

While we are sad to see you go, you may cancel your subscription at any time before the subsequent renewal is due, by notifying our support team. You will still be able to use the remaining days, but your subscription will be canceled at the end of your term.

  1. To set up automatic email sending, SPDocKit service must be set up and running.
  2. You can check that and make adjustments by using the configuration wizard.
  3. Then, go to File > Configuration > Options and select Email Settings.
  4. After you configure the service and delivery dates of your email, you can navigate to Subscription Manager and create subscriptions.

By executing this SQL query you will get the overall size of your database as well as the used and free space inside the database:

SELECT
name
, filename
, convert(decimal(12,2),round(a.size/128.000,2)) as FileSizeMB
, convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)) as SpaceUsedMB
, convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) as FreeSpaceMB
from dbo.sysfiles a

To determine the size of each table in your database, please use this SQL query:

SELECT
t.NAME AS TableName,
s.Name AS SchemaName,
p.rows AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
SUM(a.used_pages) * 8 AS UsedSpaceKB,
(SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
FROM
sys.tables t
INNER JOIN
sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
sys.allocation_units a ON p.partition_id = a.container_id
LEFT OUTER JOIN
sys.schemas s ON t.schema_id = s.schema_id
WHERE
t.NAME NOT LIKE 'dt%'
AND t.is_ms_shipped = 0
AND i.OBJECT_ID > 255
GROUP BY
t.Name, s.Name, p.Rows
ORDER BY
t.Name

In case you wish to reduce the size of your database, please follow the instructions below.

There is a data retention feature that helps manage your database size in SPDocKit. If you turn this feature on, the retention job will usually happen once a day, and occurs by default at 4 a.m. (this is explained more below). However, even when our tool deletes old data from the tables, the SQL server will still use the same amount of disk space.

There are two parts of storage that are used by any database:

  • the data itself, stored in a database file (.MDF)
  • transaction logs, stored in log files (.LDF). (Check to see if there are any SPDocKit related entries in your Windows event logs.)

In order to reduce the database size you can do the following:

  1. Please look at how to define the retention policies. If you have defined your retention policies already, you can go to step 2.
  2. Open your Options Wizard, and in the left menu select Data Retention. Here is where you will see how your retention policies are defined.
  3. If you are running version 3.3.0 and newer, you will see Force Data Retention, and next to that is an “Execute” Button. Pressing “Execute” will automatically delete old information, then attempt to shrink your database (the way this runs is determined by the settings in step 1). Please note: this can take a little bit of time to run.
  4. If you are not running the latest version, you can do this manually:
    • Shrink the database by following these instructions.
    • Change the database to the Simple Recovery Model and perform backup (This article explains the differences between SQL’s different recovery models).

Your database will probably shrink successfully, but if you need help we can assist you remotely. If you need remote assistance, please make sure to have TeamViewer installed. Here is the link for that.

To reset your password, please go to the following link.

1. Enter the email address associated with your account
2. Click on Reset Password.
3. Instructions on how to reset your password will be emailed to you. Please note: sometimes these notifications can end up in your junk folder, so please check there if you don’t see our email within a few minutes. To avoid these situations, please add our email address to your Safe Senders List.
4. If for some reason you are still unable to retrieve the new password email, please contact us for further assistance.

This message is sometimes generated when there are insufficient rights given to an end user.
To load User Profile Synchronization connections you need to do the following:

  1. Start the User Profile Synchronization Service.
  2. You need to be a member of the Administrators group for the UPA service and have Full control access.

The executing user must have “full control” permissions for the UPA. This is done by adding them as an administrator using the “Administrators” button on the ribbon.

For more information, please see the following article.

This article describes how to restore SharePoint farm settings and permissions to a local computer without SharePoint.
To view SharePoint farm settings on a local computer you have to save them to a spdfarm file that you then transfer to your local computer. If you also wish to view the permissions on your local computer you will need to transfer SPDocKit’s database to your local SQL server.

  1. To transfer a SPDocKit’s database to another computer you first have to create a backup of the database. Open Microsoft SQL Server Management Studio and find the database you are using. Right-click on the database and select Tasks>Backup1-sql-back-up
  2. Select the path where the database backup will be created and make sure that “Backup type” is set to Full.2-SQL-backup
  3. On the Options tab select Overwrite all existing backup sets.SPDocKit-SQL-overwriteFinally click OK to generate the SQL bak file.
  4. Save the .bak file and transfer it to your local SQL server. You now have the SPDocKit database.
  5. Now create the .SPDFarm file by clicking on the Save As button. Choose a name and location and remember them.1-SaveAs

That’s it, you now have both the .SPDFarm file and the SQL database backup file.
Now you need to restore SQL database backup to your local SQL server where you do not have SharePoint.

  1. Open locally SQL Server Management Studio and right-click the Databases and then Restore Database.4-SQL-restore-database
  2. Select the Device option and click on the three dots to select the database location.
    TSL_restore_database
  3. Leave the Backup media type as File and click the Add button.SPDocKit-SQL-add-button
  4. Select the backup file location and locate the .bak file. The database will be restored to your local SQL server.
  5. Open SPDocKit and choose File > Configuration > Configure and select “Use existing database” in the Configuration Wizard.2-Use-a-database
  6. Enter your local SQL server where the database is and the name of the database. After providing the information, click the Test Connection button to ensure that the settings are correct.3-Specify-SQL-ServerDatabase-name-and-authentication
  7. Run the Configuration Wizard till the end.
  8. SPDocKit will now connect to the existing database where all the permissions from the production SharePoint farm are.
  9. Go to File > Open > Computer and open the .spdfarm file which you copied from the production SharePoint farm. All other farm settings will be loaded.4-Open
  10. That’s it! You can now explore their full SharePoint farm on your local computer.

In order to retrieve farm information, the product needs to be installed or executed on a SharePoint server. Once installed, follow this guide to load farm information.

Once you load it, you will also be able to save it to a file. These files can be opened from any other computer running SPDocKit and further explored, printed or compared.


To find out which version of SPDocKit you are using, please follow these steps:
  1. Open SPDocKit.
  2. From the File menu choose Help.
  3. Your version will be written under About SPDocKit part of the screen.

With the SPDocKit installed on your PC workstation, you can connect to the SharePoint Online site and manage SharePoint Online permissions. However, you cannot view SharePoint Online permissions reports. You can only view reports you have already loaded on SharePoint Server using SPDocKit.

For more information on how to configure the SPDocKit workstation, consult our workstation configuration guide. Also, for more on how to manage SharePoint Online permissions with the SPDocKit workstation, check out the SPDocKit Workstation help.

To view the SharePoint Online permissions and Office 365 reports, we recommend using CloudKit 365. CloudKit 365 is a cloud-based service created by our company, Acceleratio Ltd., to help you review Office 365, report on Exchange Online and explore SharePoint Online.

Dive deep into your SharePoint Online environment. With SharePoint Online reports, you can compare permissions between different sites and at different points in time. Also, you can explore permissions across sites, as well as document libraries and documents. Use it to view SharePoint Online site structure and content, SharePoint objects with unique permissions, subsite permissions, or Office 365.

Uncover the CloudKit 365 features and start exploring your Office 365 tenant, track changes and generate Office 365 documentation.