Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Ops Center 7.1 and 7.5 Schema and transact SQL examples please?

Created: 24 Aug 2012 | 8 comments
firstlight's picture

Hi

First does anyone have a copy of the Ops Center Scheema for 7.1 and 7.5 so I can see if I can create some custome reports uaing SQL commands

Second as I am not good with Transact SQL or SQL plus if people can share the commands they have used to create custom reports and what the report was intended to show this would be helpful for me.

I intend to share here what I manage to get working for others to use as they wish.

 

Thanks in advance.

Discussion Filed Under:

Comments 8 CommentsJump to latest comment

MilesVScott's picture

I've also been looking for a DB Schema. All I can find is the enterprise vault schema. If anyone else has info on how to find the other it'd be awesome.

 

The Enterprise Vault Directory Database Schema Version can be found by running the following SQL query:-

USE EnterpriseVaultDirectory
SELECT SchemaVersion
FROM DirectoryEntry

The Enterprise Vault VaultStore Database Schema Version can be found by running the following SQL query:-

USE EnterpriseVaultDirectory
SELECT SchemaVersion
FROM VaultStoreEntry

The Enterprise Vault Binaries Version can be found in:-

[HKEY_LOCAL_MACHINE\SOFTWARE\KVS\Enterprise Vault\Install]
"Version"=  

On a 64bit OS everything is under a WOW6432Node key:

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\KVS\Enterprise Vault\Install]

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist

firstlight's picture

Thanks for this but are we talking about the same thing I am looking for the NetBackup Opscentre 7.1 and NetBackup Opscenter 7.5 database schema  not the Enterprse Vault schema?

MilesVScott's picture

Ha, I didnt even check that it was the right schema. So much for my google-foo recently.

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist

SRP's picture

 

A similar post from 22/08/12 should provide you with the answer.

Regards

Sean

 

Sean

firstlight's picture

Sean

Please can you put the URL of your"similar post" here as I am being inept at findng this URL?

MilesVScott's picture

Has the Schema changed since 7.0? That pdf, says its only valid for 7.0.1.

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist

SRP's picture

Miles

In the link that I gave, you will notice my post that said:

if you go to (in windows):

program files\symantec\opscenter\server\db\db_sqls.zip\70\

the Schema.xml will detail all the info you need.

I am not aware of an "official" schema having been released yet for 7.5... unless someone wishes to disprove and post the link...

 

Sean

 

Sean