Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.12.3 available

The official documentation can be found on https://wiki.ocsinventory-ng.org. Read it before asking your question.

Help Add column

Hi im trying to add column in the table on all computers. How can i do this?
in Package deployment by (260 points)

4 Answers

0 votes

Hi @daniloqc

in a database, you can a column of a table going through phpmyadmin :

https://my_ocs_server/phpmyadmin

 - Expand the tree of your database (ocsweb for ex.),
 - Choose the table concerned, click on columns,

 - Below the list of columns, you can add a column "at the end of the table", "at the beginning of the table" or "after the ID ..."

CAUTION : Proceed carefully, this action is sensitive !

Tip : Before creating a new column, please note the structure of an already existing identical column (type, collation, attributes, null, default, etc.)

Otherwise, you can also add an administrative data in OCS interface, this will create a new column (fields_x) in the accountinfo table of the database (safe method).

Regards, Stéphane

by (32.6k points)
0 votes

where can i add an administrative data in OCS interface? I dont found this option.

by (260 points)
0 votes
Which version of the OCS server do you have ?

In a recent version of OCS (eg v. 2.3.1 or 2.4) it is in "Manage, Administrative data"

Regards
by (32.6k points)
0 votes
i got it. Thank you for reply ..........................
by (260 points)
 
Powered by Question2Answer
...