Is there any information on the structure of the NIS for running SQL queries against it? I can't find any documentation on this.
Try to query the CM_NIMBUS_ROBOT table. This table is populated by a thread in the discovery_server that "crawls" the NMS infrastructure from time to time. All robots and hubs are listed (hubs have is_hub set to TRUE). The idea is to make the infrastructure available to applications via the database (which seemed to be just what you were looking for).
This feature was made available in the previous NMS server.
I am not sure if there is any documentation on the table structure. I have not seen any.
If you want to tell us what you are looking to find, we can probably help. The table structure is not too hard to understand by exploring, but we could give you a head start.
Querying this table seems to work for most servers. Some servers are not appearing in there and we think it might be related to the CDM probe. Still investigating.
Does anyone have a list of valid tables that the NIS uses? I have a server that I can see when I launch the NIS Manager program but I do not see it when I query the CM_NIMBUS_ROBOT table.
Any help would be greatly appreciated.
Are you sure the server in question has a robot installed on it? Have you verified that you can see it in the Infrastructure Manager?
The reason I ask is that the NIS Manager shows information about systems that are not running the robot, such as those that are (or could be) monitored by the rsp probe.
The CM_COMPUTER_SYSTEM table holds all monitored 'Computer Systems'. The CM_NIMBUS_ROBOT table is populated by the Discovery Server "nimbus crawler" thread and should reflect the NMS domain seen from the NMS server. So a robot may be "discovered" by the discovery agent and the discovery server using two different methods. The discovery server thread will query the NMS Server hub for 'gethubs' and then crawl down the infrastructure using a combination of 'gethubs' and 'getrobots'. Finally it populates the CM_NIMBUS_PROBE table with the probes on the robot.
Running through the CM_COMPUTER_SYSTEM table seems to give me the necessary information. We only have one domain so this will work for us.
I do hate to sound like a nag but... can I get a list of all tables that are contained within the NIS? Or, is there any internal documentation that describes all the associated databases and tables that external scripts can call?
We have multiple documents describing various parts of the NiS structure. Currently it is in a form that is more like a combination of an architectural and implementation document. My plan is to revise this document and release it as a whitepaper describing the current NiS implementation when releasing NMS 5.0.
Thanks for that information. I'll look forward to seeing this documentation in the future. :-)
The db does contain the full robot address in the grp_server table as the nimbus address I believe it's also stored in the CM_NIMBUS_ROBOT as well. Not sure on how the structure will be when the current grp_server probe goes away.
Retrieving data ...