Forum Discussion

bruphi10's avatar
bruphi10
Level 3
7 years ago

ItemId decode

Hi all,

I would like to decode the name of FSA archived files in the ExpressVaultStore Database of EV12.
I think that this name is coded in dbo.view_saveset2.ItemId  (SHA256).

May i decode this name with Microsoft SqlServer 2014.

Thanks

Bruno

 

2 Replies

  • Pradeep-Papnai's avatar
    Pradeep-Papnai
    Level 6
    7 years ago

    Hi Bruno,

    I don’t think you need to decode the FileID. There is one more column Properties in the same view dbo.view_saveset2 that can give you the name of FSA archived files. You need to use SQL inbuilt function (don’t know yet) to take the file name out of entire string.

    Regards

    Pradeep

     

    • ChrisLangevin's avatar
      ChrisLangevin
      Level 6
      7 years ago

      Pradeep's right that the Properties column has the filename. It's actually encoded a couple different ways depending on the version of EV that archived the item. The below SQL will decode the filename and stick it at the front of the view_Saveset2 view.

      SELECT CASE
    WHEN LEFT(sp.properties,2) = '<?'
              THEN SUBSTRING(properties, (CHARINDEX('<filename>', properties)+10), (CHARINDEX('</filename>', properties)-(CHARINDEX('<filename>', properties)+10)))
    WHEN LEFT(sp.properties,6) = 'FSA/3/'
              THEN SUBSTRING(properties, 7, CHARINDEX('/', properties, 7)-7)
    WHEN LEFT(sp.properties,6) = '<C v="'
              THEN SUBSTRING (properties, 7, CHARINDEX('|',properties, 7)-7) /* for sharepoint */
END AS Filename,
*

FROM view_Saveset2 AS sp

      Sample results:

       

      --Chris