Menu

CMDB: How to automatically populate and maintain itop with server software releases.

Eric M
2013-11-14
2013-11-26
  • Eric M

    Eric M - 2013-11-14

    Hi,

    In my organization group that I am part of, we maintain multiple servers whom each of them has many products installed, and each of those products comes in various flavors (different releases).
    We would like to know how people maintain their system software tab in Itop. Is there a process that can automatically load and refresh the information displayed by querying the different Oracle database we have distributed across multiple servers? Or is there an app that can run on the servers to push the information back to itop?

    We are planning to create our home-grown solution to create a routine that:
    1. Fetch the list of servers by querying the itop database.
    2. Query the servers found in last step.
    3. Input the information selected back to the Itop database.

    If we can find something already pre build

    Any ideas/solutions would be extremely helpful,

    Thank you in advance,
    -Eric

     
  • Besmir Zanaj

    Besmir Zanaj - 2013-11-25

    Hi,
    You can achieve this by using an appropriate ETL like Talend and automate the thing.

     
  • TheBigOne

    TheBigOne - 2013-11-26

    Hi,

    I`m not done with the complete solution, but I wrote a perl script to collect the serverdata and put it to an ini file. This ini file will be encrypted sent via curl and sslv3 to our target itop server where a cronjob collects the files and pushes the data into an iTop synchronization datasource which is updating the iTop database.

    Collecting software from linux machines is quite easy, if its installed as rpm or another package manager.

    I`m not a Windows guy, but you could collect the software with powershell, put the files to a share or scp them to your server.

    There is an opensource solution which is collecting a lot of data: OCSinventory.
    http://www.ocsinventory-ng.org/en/

    It will collect data and put them to a mysql DB where you can grep it. It also collects installed software and it`s free.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.