1
0
-1

Is possible to use spreadsheet to update devices information?, I need to add Asset Number to 500 computers.

Thanks!

    CommentAdd your comment...

    5 answers

    1.  
      1
      0
      -1

      Fernando,

       

      The best way to do this is to activate the "Export Details" query (menu -> Admin -> Queries -> Activate Query and then run that on a Group that contains the devices you wish to update. Run the report and then in the menu bar on the right side you will see an Excel icon. Click this to download the report in Excel format.

       

      The add or change the fields you require. NOTE - they must have the same name as the fields in the database you wish to update and you can only update fields in the 'system' table. You can see the definition of this table by opening the file /open-audit/other/open-audit_mysql.sql and scrolling to the bottom.

       

      Make your changes and upload the file as per the previous wiki link. This will update the existing devices. Make sure you don't delete the important column 'system_id' this is what is used to match the devices when you import the spreadsheet.

       

      Most of your attributes will start with man_*. There are generally two items for most attributes that can be autodetected by Open-AudIT. For example serial and man_serial. If there is a man_* attribute for the item in question, always use that.

       

      Post back and let us know how you go or if you have any issues.

       

      And also don't forget about the bulk update functionality which may be helpful when many devices have the same attribute - How to Bulk Edit device attributes.

        CommentAdd your comment...
      1.  
        2
        1
        0
          CommentAdd your comment...
        1.  
          1
          0
          -1

          Works perfectly.

           

          Thank You!

            CommentAdd your comment...
          1.  
            1
            0
            -1

            Thank you Mark and Alexander; however, I don't need import device, I need update or add information to current devices.

            Regards.

              CommentAdd your comment...
            1.  
              1
              0
              -1

              It is possible to import new devices from a spreadsheet.

              In Open-AudIT Enterprise you'll find that functionality under System -> Devices -> Add Multiple Devices; in Open-AudIT Community it's under Admin -> Devices -> Add Multiple Devices from Spreadsheet.

                CommentAdd your comment...