3 Replies Latest reply on Feb 24, 2016 7:31 AM by Bill Robinson

    Files saved on BSA's File System?

    Santhosh Kurimilla

      Bill Robinson/Folks,

       

      Can you please confirm what are these files saved on/under BSA's File System?

       

      [user@AppServer ~]$ cd /bladelogic/depot/files/

      [user@AppServer files]$ ls -alt | head

      total 10388

      drwxr-xr-x    3 bladmin bladmin   4096 Feb 22 16:41 38094156

      drwxr-xr-x 2457 bladmin bladmin 557056 Feb 22 16:41 .

      drwxr-xr-x    3 bladmin bladmin   4096 Feb 22 13:41 38094504

      drwxr-xr-x    3 bladmin bladmin   4096 Feb 22 13:41 38095593

      drwxr-xr-x    3 bladmin bladmin   4096 Feb 19 13:30 38012821

      drwxr-xr-x    3 bladmin bladmin   4096 Feb 19 11:37 38004736

      drwxr-xr-x    3 bladmin bladmin   4096 Feb 19 11:35 38006403

      drwxr-xr-x    3 bladmin bladmin   4096 Feb 19 11:35 38003569

      drwxr-xr-x    3 bladmin bladmin   4096 Feb 19 11:32 38001947

       

      As I can find them in DB table too, I believe they are generated/saved under Depot in the console?

       

      SQL> select * from FILE_LOCATION where RELATIVE_PATH like 'files/38094156%';

      FILE_LOCATION_ID FILE_SERVER_ID           RELATIVE_PATH              IS_DELETED
      ---------------------------------------------------------------------------------------

      8105926        2000000               files/38094156/0/1/2000003/2         0

       


      SQL> select * from FILE_LOCATION where RELATIVE_PATH like 'files/38094504%';

      FILE_LOCATION_ID FILE_SERVER_ID    RELATIVE_PATH                      IS_DELETED

      -----------------------------------------------------------------------------------------
               7786635        2000000    files/38094504/0/1/2000003/38         0

       

      But, I don't find any records of respective Depot objects for the same?

       

      SQL> select d.DEPOT_OBJECT_ID,d.FILE_LOCATION_ID,do.name,do.is_deleted,fl.RELATIVE_PATH from depot_object do, depot_object_location d, FILE_LOCATION fl where d.DEPOT_OBJECT_ID=do.DEPOT_OBJECT_ID and d.FILE_LOCATION_ID=fl.FILE_LOCATION_ID and fl.FILE_LOCATION_ID in (8105926,7786635)
        2  /

      no rows selected