2 Replies Latest reply on Feb 4, 2013 3:24 PM by frodet73

    vcenter protect database xml question

    Rookie

      Hi!

       

      Is there anyone that can help me do a select against the GenericHardwareAsset table? The result in the rawXmlResults is XML and i have no idea how to do selects twards it...

       

      Help!

       

      Greetings

      Frode

       

      CREATE TABLE [dbo].[GenericHardwareAsset](

                      [id] [int] IDENTITY(1,1) NOT NULL,

                      [categoryId] [int] NULL,

                      [name] [nvarchar](128) NOT NULL,

                      [description] [nvarchar](1024) NULL,

                      [rawXmlResults] [xml] NOT NULL,

                      [scanMachineId] [int] NOT NULL,

        • 1. Re: vcenter protect database xml question
          SupportEmployee

          Hello,

           

          We don't provide database schema information publicly, and we don't support any modifications or queries to the database other than those given specifically from our engineering team for certain issues so unfortunately we won't be of much help on the support team. Sorry for the inconvenience. Hopefully someone else out here on the community can provide some assistance.

          1 of 1 people found this helpful
          • 2. Re: vcenter protect database xml question
            Rookie

            Hi!


            I understad. Just that the VVP database has this huge amount of data that can be used. To bad you cant give me a view or something that would make this strange xml data selectable. Everything else is right there - but then - you have chosen to do something "strange"

             

            Anyway; great product!

             

            Greetings

            Frode