So you’ve found an issue in a Package in a Project for a DataSynchronization in a Integration Services Catalogs ( .dtsx file ) that you want to edit?Install […]
Tag: SQL
N-able Report Manager Maintenance – Reduce Database Size
Login to the Nable Administrator Report Manager ( http://%reportmanagerserver%/Interface/Pages/menu.aspx ) You will need to use the username : [email protected] ( You can reset this password ) Navigate to the followingSelect System Setup and […]
Interactive Training for SQL and RegEx
https://sqlbolt.com/https://regexone.com/
Veeam Writer’s state: [VSS_WS_FAILED_AT_PREPARE_SNAPSHOT]. Error code: [0x800423f4].]
A Server 2012 R2 started getting VSS Writer Errors randomly in Veeam backup job. The server is running AADconnect which is set to autoupdateA restart of the […]
Cannot delete Credentials in Veeam due to Shared Folder
For some reason I couldn’t delete credentials from Veeam due to them being used on a Shared Folder that did not existing in a backup repository or […]
Email Filing Service Gui not showing Failed Folders
As there is no notification with the iManage Email Filing Server when folder status turns from Succeeded to reset the folder , we use the following SQL […]
Search for folder in iManage
It seems the iManage Inbox has difficulties filing items in a folder with a Custom24 Attribute attached to it. Here’s how to search imanage folders and list […]
Worksite iManage History SQL Search Query
Worksite/Imanage Monitor can export a document list based on History using the History search but it’s limited in the way it can display comments as well as […]
How to create a new iManage/Worksite Database
How to create a new iManage/Worksite Database 1) Create new blank Databases on an SQL / Oracle Server and create or use existing iManage user full rights2) […]
How to Find Favorites and My Matters in iManage Worksite SQL
Recently a user lost their favorites in iManage. This was due to a Preferred Database change. Below was an SQL Query you can run on the iManage […]
SQL Indexing and VEAM/VMWare Backups Speed Up
Recently we were having issues with the time period of our Veam backups of SQL database. Veam creates a snapshot of a server, which can then be […]