SQL Query

[GTK]

i am after a SQL query to display:

• user
• vault store
• EV server

We are on EV 8sp5 using SQL 2005.

Can anyone provide such a SQL query please?

[AmolB]

Try the below query on Directory Database.

select A.ArchiveName,V.VaultStoreName, C.ComputerName from ArchiveView A

inner join 

view_VaultStore_Entity V on A.VaultStoreEntryId = V.VaultStoreEntryId

inner join 

ComputerEntry C on V.ComputerEntryId = C.ComputerEntryId

[GTK]

running that query i get the attached error ?

[AmolB]

I am sorry, unfortunately I dont have EV 8 setup.

Above query works fine in EV11 setup.

[GTK]

can anyone else assist please?

[JesusWept3 · Accepted solution]

You probably forgot to change the Database from Master to EnterpriseVaultDirectory
Anywho, without the VIEW query, it would look like the following

 

SELECT A.ArchiveName, VSE.VaultStoreName, CE.ComputerName
  FROM EnterpriseVaultDirectory.dbo.Archive A, 
       EnterpriseVaultDirectory.dbo.VaultStoreEntry VSE, 
       EnterpriseVaultDirectory.dbo.StorageServiceEntry SSE,
       EnterpriseVaultDirectory.dbo.ComputerEntry CE
 WHERE A.VaultStoreEntryId = VSE.VaultStoreEntryId
   AND VSE.StorageServiceEntryId = SSE.ServiceEntryId
   AND SSE.ComputerEntryId = CE.ComputerEntryId
ORDER BY A.ArchiveName ASC

[GTK]

thanks JesusWept3.. exactly what i need!