Banner.gif (5609 octets)


Project Home
OCS Inventory
   Qu'est-ce-que c'est ?
   Quoi de neuf
   A faire
   Fonctionnalités
   Installation
   Utilisation
   Compilation
   Aide / FAQ

Report Bugs or request new features for OCS Inventory
OCS Inventory Discussion Forums
 Email OCS Developer Team

OCS Inventory CSV files format description

 

Config.csv: Configuration CSV file format

This file store the settings for the agent. It is generated by the Manager and read by the agent.

There is one line by setting. See the manager for settings values and meaning.

Format

Setting name;Setting integer value;Setting text value

NB: Setting name is case sensitive.

 

Apps.csv: Applications to search CSV file format

This file store the informations to allow the agent recognize apps to store. It is generated by the Manager and read by the agent.

There is one line by apps the agent have to search. This file only contains definitions of apps to store. It means that only Apps definition with the CheckFor flag set to TRUE are registered in this file.

Lines must be ordered increasing by Application name and then Version

Format

AppID;App Name;App Version;App Filename;App Filesize

 

Hardware\ComputerID.csv: Computer Hardware CSV file format

This file is created by the agent and store informations about the OS, processors, memory, main IP address, logged on user, last check date and check duration on one line only.

It is read by the manager, but never deleted because agent uses the last check date to know if inventory have to be done or not..

Format

Computer ID;OS Name;OS Version;OS Comment;Processor type;Processor speed;Number of processors;Physical memory;Swap file size;Primary IP address;Execution duration;Last check date;Logged on user;Device type (optional);Computer description (optional)

NB:

  • Optional fields must be write empty if not filed. Also, Last check date and execution duration fields must be write in ISO format YYYY-MM-DD and HH:MM:SS.
  • Processor speed must be set in MHz with the following format "~Speed MHz", example: "~1400 MHz".
  • Processor number must a positive integer value without sign.
  • Physical memory and Swap file size must be written in MB, as a positive interger value without sign.
  • Device type is a positive integer wich can take the following values:
    0 =>Windows workstation device type
    1 => Windows server device type
    2 => Windows notebook or laptop device type
    3 => Novell Netware server device type
    4 => Apple MacOS workstation device type
    5 => Apple MacOS server device type
    6 => Apple MacOS notebook or laptop device type
    7 => Unix workstation device type
    8 => Unix server device type
    9 => Unix notebook or laptop device type
    10 => HandHeld device like Palm or Pocket PC
    11 => Network printer device type
    12 => Hub device type
    13 => Switch device type
    14 => Router device type
    15 => IP phone device type
    16 => IP PABX device type
    17 => User workgroup device type
    18 => Unknown device type

 

LogicalDrives\ComputerID.csv: Computer Logical Drives CSV file format

This file is created by the agent and store informations about logical drives (one logical drive per line). If the file already exist, it is overwritten.

It is read by the manager, and deleted after import. Manager check for this file to see if there is something to import.

Format

Computer ID;Drive letter;Drive type;Drive total size;Drive free space;Drive volum name;Drive filesystem;Number of files

NB:

  • Drive Type means Removable (Floppy, ZIP, LS120...), Hard Drive, CD-Rom, Network).
  • Drive total size,Drive free space and Number of files must be integer values (in MB for Drive size and free space), or -14 if not available (CD-Rom, Removable...).

 

Graphics\ComputerID.csv: Computer Graphic Adapters CSV file format

This file is created by the agent and store informations about graphic adapters (one adapter per line). If the file already exist, it is overwritten.

It is read by the manager, and deleted after import.

Format

Computer ID;Adapter description;Chipset;Memory;Resolution (optional)

NB: Memory must be in MB with the following format "memory MB", example: "32 MB".

 

Printers\ComputerID.csv: Computer Printers CSV file format

This file is created by the agent and store informations about printers (one printer per line). If the file already exist, it is overwritten.

It is read by the manager, and deleted after import.

Format

Computer ID;Printer description;Driver;Port

 

Network\ComputerID.csv: Computer Network Adapters CSV file format

This file is created by the agent and store informations about network adapters (one adaper per line). If the file already exist, it is overwritten.

It is read by the manager, and deleted after import.

Format

Computer ID;Description;Type;TypeMIB;Speed;MAC Address;Operational status;IP Address;IP Net Mask

NB: Speed must be in Mb/s or Gb/s with the following format "speed Mb/s", example: "1 Gb/s".

 

Results\ComputerID.csv: Computer Detected Softwares CSV file format

This file is created by the agent and store informations about detected softwares (one software per line). If the file already exist, it is overwritten.

It is read by the manager, and deleted after import.

Format

Computer ID;App ID;File folder;Filename;File size;File version

NB:

  • App ID is the App ID extracted from the Apps.csv file.
  • File size must be an integer value without sign in bytes.

 

BIOS\ComputerID.csv: Computer BIOS CSV file format

This file is created by the agent and store informations about BIOS (only one line).

It is read by the manager, and deleted after import.

Format

Computer ID;System S/N;System model;BIOS version;BIOS Date;System Manufacturer (optional);BIOS Manufacturer (optional);Machine type (optional)

NB:

  • Optional fields must be write empty if not filed.

 

AccessLogs\ComputerID.csv: Computer Access Logs CSV file format

This file is created by the agent and store informations about BIOS (only one line). If the already file exist, the agent append to the file the new access log.

It is read by the manager, and deleted after import.

Format

Computer ID;User ID;Logon date;Processes status

NB:

  • Logon date must in ISO format with time YYYY-MM-DD HH:MM:SS.
  • Processus status must be written, comma separated as follow: process name + Started or MISSING. Example: "process1_name Started, process2_name MISSING, process3_name Started"