09-20-2013 01:06 AM
Product:Ent. Vault 9.0
I want to create a script that will generate a report and show me what are the drives where indexes are closed or open. I ran get-command on Evault Management shell but couldnt find cmdlet that may relate to index (e.g Get-Index) . Is there any?
Thanks,
Aries
Solved! Go to Solution.
09-20-2013 02:12 AM
User following (modified) query with server name.
use EnterpriseVaultDirectory
select IP.IndexRootPath, IP.IndexRootPathStatus, CE.ComputerName, CE.ComputerNameAlternate
from IndexRootPathEntry ip,ComputerEntry CE,IndexingServiceEntry ISE
where CE.ComputerEntryId = ise.ComputerEntryId and
ip.IndexServiceEntryId= ise.ServiceEntryId
'0' means open & '1' means close.
09-20-2013 01:19 AM
There isn't such a command, no.
09-20-2013 01:53 AM
I am not sure via powershell, but you can get this information from SQL query.
Note down IndexServiceEntryID
use EnterpriseVaultDirectory
select CE.ComputerName, CE.ComputerNameAlternate, ise.ServiceEntryId from ComputerEntry CE
INNER JOIN IndexingServiceEntry ISE
ON CE.ComputerEntryId = ise.ComputerEntryId
Ran following query (Replace the value got in step 1).
use EnterpriseVaultDirectory
select IndexRootPath, IndexRootPathStatus, IndexServiceEntryId
from IndexRootPathEntry
where IndexServiceEntryId = 'STEP1'
'0' means open & '1' means close.
09-20-2013 02:12 AM
User following (modified) query with server name.
use EnterpriseVaultDirectory
select IP.IndexRootPath, IP.IndexRootPathStatus, CE.ComputerName, CE.ComputerNameAlternate
from IndexRootPathEntry ip,ComputerEntry CE,IndexingServiceEntry ISE
where CE.ComputerEntryId = ise.ComputerEntryId and
ip.IndexServiceEntryId= ise.ServiceEntryId
'0' means open & '1' means close.
09-20-2013 01:50 PM
I uploaded script for similar task back in 2012, you can check it out here, should save some work:
https://www-secure.symantec.com/connect/downloads/automate-backup-mode-check-email-reporting
You can use the script as-is or pull cmdlets for index location particularly.
09-30-2013 08:35 PM
Do you need any more information from this post?
10-01-2013 06:50 PM
Cool man, it works quickly and easily.