I want to know if it would be possible generate one alert if the new robot was installed in order to keep under control.
You can create a db trigger on table CM_NIMBUS_ROBOT after insert (for each row) . In the trigger insert a row with information from row(robot) just inserted into CM_NIMBUS_ROOBT into a custom table. If you are familar with custom probe, create a probe to periodically check this table, and fire alarms accordingly then drop the row. You can also resue this probe for other tasks if you want.
Hope this helps.
also you will have to create this custom table manually before creating this trigger. If this table is later modified or renamed, manually recompile the trigger and make sure its status is valid and enabled.
maybe someone else here has other suggestions.
We do this in another way:
We are investigating the use of mon_config_service to achive the same results - but we can't use that all over the place, as we have some servers we are not allowed to upgrade or reconfigure automatic.
Could you please share with me this script ?
Another possibility is to use the probe: sql_response to execute each hour (or any other freq):
SELECT nm.robot,cs.create_time,nm.check_time, nm.hub from CM_COMPUTER_SYSTEM cs INNER JOIN CM_NIMBUS_ROBOT nm on nm.robot=cs.name where create_time >= DATEADD(hh, -1, GETDATE())
This could generate someting like:
new_robot_discovered/bgbulab53/CA_UIM: name: bgbulab54
Retrieving data ...