UCMDB API CIs to Record Set

Hi,

I am trying to pull the information from UCMDB using the api(Version 8). This extract needs to be stored in a database. I am able to connect to the server and then iterate thru each of the topology. But all topology CI's have 0 properties.

Please let me know how to read the Topology to convert it to a recorset. I wanted somthing like the way we export it to CSV, so we can store it as a database base.

 

 

P.S. This thread has been moevd from Application Perf Mgmt (BAC / BSM) Support and News Forum to CMS and Discovery Support and News Forum. - Hp Forum Moderator

Parents
  • Thanks for the excellent reply!!!

    I did work on this example and these examples work great., and prints the result as expected.

    For my request, the UCMDB team had created a TQL query, which I am able to access from the UCMDB Reports(front-end).

    I wanted to execute that perticular query and retrive the result. I am able to execute the query and iterate thru the loop, but I am not able to print the different columns what I see in the report via front-end.

    Topology returned prints only 2 values, UCMDBID and the type, rest all other methos either returns a null or blank string("").

    In your reply you mentioned about the Flat collection, not sure if this is what is happening to my queries. Please let me know if you have any suggestions for reading the flat collections.

    Thanks,
Reply
  • Thanks for the excellent reply!!!

    I did work on this example and these examples work great., and prints the result as expected.

    For my request, the UCMDB team had created a TQL query, which I am able to access from the UCMDB Reports(front-end).

    I wanted to execute that perticular query and retrive the result. I am able to execute the query and iterate thru the loop, but I am not able to print the different columns what I see in the report via front-end.

    Topology returned prints only 2 values, UCMDBID and the type, rest all other methos either returns a null or blank string("").

    In your reply you mentioned about the Flat collection, not sure if this is what is happening to my queries. Please let me know if you have any suggestions for reading the flat collections.

    Thanks,
Children
No Data