ip-discovery

[andreas.moroder-wON1u+O0wKj/]

Hello,

we already have a system ( McAfee rogue detection ) on our network
that discovers and categorizes machines on the network. Would it be
possible to import the data from this system into ocs's tables instead
of a second rescan? What tables are involved and are there pitfalls I
have to pay attention ?

Thanks
Andreas

[Guillaume PROTET]

Hi Andreas,

There is currently no tool to import datas from another tool because the goal of OCS Inventory is to make a snaphshot of your IT network and make a lite asset management on it....

The main question of your request is what do you want to do of your imported data ? Do you want to store it as computers in the main inventory or as discovered devices as the "ipdiscovered" ones ?

If you want to add it as computers in the main inventory, you will have to play with the hardware table and all of the others tables about devices. You will have to manage many tables links between the tables to have a consistent inventory. The other problem you will have is that it could make a confusion because your imported computers may won't have OCS agent and, for example, you won't be able to teledeploy packages on it. So you will have to distinguish imported computers from the computers with OCS agent if you don't want to keep this confusion...

If you want to add your imported computers as the "ipdiscovered" ones, you will have to play with the "network_devices", "netmap" and "networks" tables. This solution will be more easy than the first one and you will see your imported computers in the "Network informations" from the "security" icon of ocsreports.

You just have to make your choice now ;) ;).

Kind regards,

--
Guillaume


----- Mail original -----

Post by andreas.moroder-wON1u+O0wKj/
Hello,
we already have a system ( McAfee rogue detection ) on our network
that discovers and categorizes machines on the network. Would it be
possible to import the data from this system into ocs's tables instead
of a second rescan? What tables are involved and are there pitfalls I
have to pay attention ?
Thanks
Andreas

[andreas.moroder-wON1u+O0wKj/]

Post by Guillaume PROTET
Hi Andreas,
....
If you want to add your imported computers as the "ipdiscovered"
ones, you will have to play with the "network_devices", "netmap" and
"networks" tables. This solution will be more easy than the first
one and you will see your imported computers in the "Network
informations" from the "security" icon of ocsreports.
--
Guillaume

Hello Guillame,

I agree with you that this is the only way to go.
My plan is to check the hardware table if a device is already in this
table ( by MAC ). If it is not inthere I add it to the discovered
devices. This way I don't change anything in the "core" tables but
have all the data I need.

I loaded the schema into DB Designer 4 but it does not show the
relations between the tables. I miss this info on
http://www.ocsinventory-ng.org/uploads/OCS_Inventory_NG_Database_Schema.html
too.
Is there a more detailes documentation about the db schema (
relations, referential integrity ) ? Is the integrity enforced by
mysql itself or ( only ) by ocs ?

Thank you
Andreas