Forum Discussion

puneet102's avatar
puneet102
Level 4
6 years ago

How can I Export netbackup policy details in excel?

Hi,

I want to export all netbackup policy details like policy name, client name, policy type, active status, backup selection, schedule name, storage etc . In an excel format.

I can get this data in text format using bppllist command but it gives me all details of policy and if I am importing this data in excel it is taking time to remove unrequited data as number of policies are more than 150.

Is it possible to get any report in excel format from netbackup or opscenter? Please help me on this.

7.7
Linux
  • Systems_Team's avatar
    Systems_Team
    6 years ago

    Hi Puneet,

    Yes this is quite possible.  I've written a couple of posts regarding this - in particular please read my comment in this post:

    https://vox.veritas.com/t5/OpsCenter/Policy-Report-for-SOX-Audit/m-p/841065#M4548

    This download was created in 2010, but I have used it on NetBackup versions up to 7.7.3. A big shout out to Satkay_Satish if he's still around for creating this.

    I've documented everything to get you going, but if you have any queries let me know.  If this post solves your problem, please remember to mark it as solved to help others.

    Hope this helps,

    Steve

5 Replies

Sort By
Replies have been turned off for this discussion
  • Systems_Team's avatar
    Systems_Team
    Level 6
    6 years ago

    Hi Puneet,

    Yes this is quite possible.  I've written a couple of posts regarding this - in particular please read my comment in this post:

    https://vox.veritas.com/t5/OpsCenter/Policy-Report-for-SOX-Audit/m-p/841065#M4548

    This download was created in 2010, but I have used it on NetBackup versions up to 7.7.3. A big shout out to Satkay_Satish if he's still around for creating this.

    I've documented everything to get you going, but if you have any queries let me know.  If this post solves your problem, please remember to mark it as solved to help others.

    Hope this helps,

    Steve

    • puneet102's avatar
      puneet102
      Level 4
      6 years ago
      Can I get the source code of the script? If yes, please let me know how?

      The reason for it that i am using libre office and as I notice its dependency is on Microsoft office.
      • Systems_Team's avatar
        Systems_Team
        Level 6
        6 years ago

        Hi Puneet,

        You would have to ask Satkay Satish who created this great little tool, to see if he's prepared to share the source code.

        He has been active on Vox this year, so I guess he's still around.  Here is the link to his profile page:

        https://vox.veritas.com/t5/user/viewprofilepage/user-id/84791

        You can send him a PM and see what he has to say regarding your query.

        Steve

    • Yable's avatar
      Yable
      Level 3
      5 years ago

      Hi Steve

      I am getting Run-time error '5'. What's can i do to resolve this.

      Find attached the error.

      • Marianne's avatar
        Marianne
        Level 6
        5 years ago

        Yable 

        As per the previous post - you need to contact the author of the tool.