0

Cannot delete Credentials in Veeam due to Shared Folder

Posted by paris on Jul 12, 2017 in Fixes

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 Tape to Folder. In the end I had to use SQL remove this.

  1. Verify the record to be deleted by running the following query against the configuration database (VeeamBackup by default);

    SELECT * FROM [backup.model.mrulist]
  2. Run the following query, changing <share path> to match the record to be deleted.

    DELETE FROM [backup.model.mrulist] WHERE url = ‘<share path>’
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Tags: , , ,

 
0

Email Filing Service Gui not showing Failed Folders

Posted by paris on Sep 10, 2015 in Random

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 Statement to notify us via email when there are problems

 

$PSEmailServer = "smptserver"
 
##SQL Query Function no SQL installs needed all powershell baby
function Invoke-SQL ($SQLServer, $SqlQuery) {
#Uncomment below to double check the statement
#Write-Host $SqlQuery
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Server = $SQLServer; Integrated Security = True"
 
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = $SqlQuery
$SqlCmd.Connection = $SqlConnection
 
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
 
$DataSet = New-Object System.Data.DataSet
[void]$SqlAdapter.Fill($DataSet)
 
$SqlConnection.Close()
return $dataset.tables
}
 
$sqlresult = Invoke-SQL imanagesqlserver "select COUNT(1) from [imanagedatabase].[MHGROUP].EM_PROJECTS where ENABLED='Y' AND (STATUS=-1 or STATUS=-3)"
 
$DocGenCount = $sqlresult| select -expand Column1
 
if ($DocGenCount -gt 0 ) {
 
Send-MailMessage -From "email@domain.com.au" -to "email@domain.com" -Subject "EFS Problem Database Support" -Body "Current number of Issues $DocGenCount "
 
}

 

We recently got alerts through however logging into the Worksite Email Filing Server Management GUI there were no marked folders for resetting. This was due to the email address of the iManage user not matching the users filing email

 

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Tags: , , , , , , ,

 
0

Search for folder in iManage

Posted by paris on Sep 9, 2015 in Code

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 Workspaces/Folders with this attribute to remove where required.

SELECT PF.PRJ_NAME AS 'Folder Name', PWS.PRJ_NAME AS 'Workspace Name', PN.VALUE AS 'Cust 24 Value'
FROM MHGROUP.PROJECTS PF
JOIN MHGROUP.PROJECT_NVPS PN ON PF.PRJ_ID = PN.PRJ_ID
JOIN MHGROUP.PROJECTS PWS ON PF.TREE_ID = PWS.PRJ_ID AND PWS.PRJ_ID <> PF.PRJ_ID 
JOIN MHGROUP.DOCMASTER DWS ON DWS.DOCNUM = PWS.DOCNUM
WHERE PN.NAME = 'iMan___48'
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Tags: , , , ,

 
0

Worksite iManage History SQL Search Query

Posted by paris on Jul 24, 2015 in Code

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 duplicate Document Numbers. Below is SQL of how to get this direct in SSSM

Change the WorksiteDB to your DB and APPName to your application

SELECT DISTINCT [WORKSITEDB].[MHGROUP].[DOCHISTORY].[DOCNUM]
     ,[WORKSITEDB].[MHGROUP].[DOCHISTORY].[VERSION]
	 ,[WORKSITEDB].[MHGROUP].[DOCMASTER].DOCNAME
	 ,[WORKSITEDB].[MHGROUP].[DOCMASTER].T_ALIAS
      ,[ACTIVITY]
      ,[ACTIVITY_CODE]
      ,[ACTIVITY_DATETIME]
      ,[DURATION]
      ,[DOCUSER]
      ,[APPNAME]
      ,[LOCATION]
	  , CAST([WORKSITEDB].[MHGROUP].[DOCHISTORY].[COMMENTS] AS NVARCHAR(MAX))
  FROM [WORKSITEDB].[MHGROUP].[DOCHISTORY] JOIN [WORKSITEDB].[MHGROUP].[DOCMASTER] ON [WORKSITEDB].[MHGROUP].[DOCHISTORY].[DOCNUM]=[WORKSITEDB].[MHGROUP].[DOCMASTER].[DOCNUM] WHERE (APPNAME = 'APPLICATIONNAME') AND (ACTIVITY = 'Checkin')
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Tags: , , , , , ,

 
0

How to create a new iManage/Worksite Database

Posted by paris on Apr 30, 2015 in Random

How to create a new iManage/Worksite Database

worksite1) Create new blank Databases on an SQL / Oracle Server and create or use existing iManage user full rights
2) Add these Databases to the ODBC Sources under Administrative Tools with correct credentials ( Make sure it’s 32bit C:\Windows\SysWOW64\odbcad32.exe ) 
3) Use Imanage Database Administrator to Register a new Database ( right Click on Worksite Databases and Click Register )
4) When it asks for Operating System Path , this is the file server location so point it to the file server e.g. \\imanagefilesvr\sharename
5) This creates all the tables and meta data in the table.
6) Once done open Worksite Service Manager and click the databases button
7) Choose Add Database
8) Find the ODBC Source and add a loginID and password.
9) Add indexing if needed e.g. IDOL Indexer as well as server name of indexer
10) Restart Worksite Server and check logs of connection sucessful

To configure WorkSite Indexer to index content from a new WorkSite library
1. Ensure that you have a backup of your index data.
2. Back up all WorkSite Indexer configuration files.
3. Start the Deploy Tool by running the deploy-8_5.bat file located in the
installation directory.
4. Specify a new output directory that does not overwrite any existing
configuration files.
5. Ensure that the settings that you used to deploy the WorkSite Indexer are still
shown in the Deploy Tool. If the settings are not shown, reconfigure the
Deploy Tool with the same settings that you originally used.
6. Select the Indexer tab.
7. Click Add to add another WorkSite Library. The Add Library Configuration
dialog box opens.
8. In the Add Library Configuration dialog box, type the new WorkSite database
and connection information, then click Test.
9. After the connection test has completed successfully, click OK.
10. Click Grey Cog (Regenerate configuration files). NOT Deploy ( Green Arrow)
11. When the deploy process is complete, click Done, and then close the Deploy
Tool.
12. Stop the WorkSite Indexer services. See “Stop Individual WorkSite Indexer
Services” on page 88.
13. Navigate to the output folder you specified in the Deploy Tool.
14. If you have not made any additional manual configuration changes, you can
run the _deploy_services.bat file with the new configuration files. If you
have made manual changes to the configuration files, continue with Step 15.
15. Open the following new configuration files, and compare them to the deployed
versions from Step 1.
? WorkSite Connector.cfg
? WorkSite IDOL.cfg
? Worksite ContentN.cfg (if multiple Content servers exist, you must
copy all the configuration files)
? Worksite Active Content.cfg (if applicable)
? Worksite DiffTool.cfg
? Worksite Metadata Content.cfg (if applicable)
? Worksite Workspace Content.cfg (if applicable)
Add Content Servers
WorkSite Indexer Administration Guide 149

16. After confirming all configuration parameters, replace the existing
configuration files in your deployed directories with the new versions.
17. Restart the Indexer services. Use the Index Browser to ensure that the new
index database exists, and that the Indexer starts to process files from this
new WorkSite library.

How to Add Database to Communication Server

  • Add the Database to the Communication Service Properties with a user which is in NTRADMIN Group ( If this group doesn’t exist create it! ) and add user
  • Add the database to the Email Filing Server under Worksite Connect. You may need to stop the service to do this, and add on the end of Databases, Save
  • Restart the Communication Service and Filing Service
VN:F [1.9.22_1171]
Rating: 7.0/10 (1 vote cast)
VN:F [1.9.22_1171]
Rating: +1 (from 1 vote)

Tags: , , , , , , ,

 
0

How to Find Favorites and My Matters in iManage Worksite SQL

Posted by paris on Oct 1, 2014 in Code

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 database server to check where the users old favorites are and also check for Duplicates

SELECT PRJ_OWNER, PRJ_ID, PRJ_NAME, SUBTYPE FROM MHGROUP.PROJECTS
 WHERE PRJ_OWNER = 'imanage username' AND SUBTYPE = 'S' 
 OR PRJ_OWNER = 'imanage username' AND SUBTYPE = 'F' 
 ORDER BY PRJ_NAME

This will give you the PRJID for My  Favorites ( F ) and My Matters ( S )

To query the folders for thoose workspaces perform the following  :

SELECT PRJ_OWNER, PRJ_ID, PRJ_NAME, PRJ_DESCRIPT FROM MHGROUP.PROJECTS WHERE TREE_ID = 'PRFID'

 

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: +1 (from 1 vote)

Tags: , , , , ,

 
0

SQL Indexing and VEAM/VMWare Backups Speed Up

Posted by paris on Aug 20, 2013 in Random

DH_2D00_073113_2D00_1[1]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 copied to disk or to tape subsiquently. The SQL servers were having their Indexes fully rebuilt every night.

“If you’re using the FULL recovery model, the entire index rebuild operation is fully logged, which means the transaction log file must be at least as large as the index being rebuilt. It also means the next
transaction log backup will essentially contain the entire index.” ( Per http://sqlmag.com/blog/it-bad-idea-rebuild-all-indexes-every-night  )

This balloned the storage needed on the SAN nightly by more than 1TB due to the writes of the transaction log and the changes from the inital snapshot and also slowed down the overall backup process

A smarter way to index the servers each night is to analyse the fragmented indexes , and only reindex thoose

This can be found here : http://blogs.technet.com/b/sql_server_isv/archive/2010/10/18/index-fragmentation-if-it-isn-t-broke-don-t-fix-it.aspx

Indexing tasks and scipts can be found here : http://technet.microsoft.com/en-us/library/ms189858.aspx

 

 

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Tags: , , , ,

Copyright © 2017 Welcome to Pariswells.com All rights reserved. Theme by Laptop Geek. Privacy Policy