It can be useful to extract the list of devices from each Device Server (DS) from the database. This provides the steps, and commands needed, in order to do so.
NCM 10.1.X
There is no relationship created in the controlDB for a device server and its associated devices. You can however, get this information from the cflist (infraDB) as follows:
source /etc/voyence.conf
opt/voyence/cgi-bin/
./cflist.cgi > cflist.out
HEAD RTypeList= PollTypeList= UserList= DispositionList= DeliveryList= UrlList= PopList=1000 NetList=999 :
POP 1000 "vm-smts-28-197" NetList= RsrcList= DevList=1001,1002,1003,1004,1005 EmsList= : ADDR="127.0.0.1" AGE_DAYS=730 CLEANUP_DAYS=90 AD_ENABLE=0 AD_ARPCACHE=0 AD_DFLTROUTE=0 AD_AUTO_RESOURCE=0 AD_DEFAULT_POLL=0 SNMP_TIMEOUT=500 SNMP_RETRY=3 CM_DEBUGSESSION=0 SORTCONFIG=1 CM_MAXMAINTASKS=20 CM_PULLTIMER=1200 CUTTHRU_PULLTIMER=10 MAX_COMM_ATTEMPTS="5" CM_SMGR_CACHING_ENABLED=1 CM_SMGR_SESSION_TIMEOUT=60 CM_SMGR_SESSIONS_PER_DEVICE=4 AD_BATCHSIZE=1000 AD_NUMHOP=10 AD_TIMEOUT=10 AD_LOOPCNT=2 CM_NATTEDIP_LOOKUP=1 RECORDVER="1.0"
DEV 1001 "Cisco261111111111" ElemList= PopParent=1000 EmsParent= : UID="1234" SYSOBJECTID="1.3.6.1.4.1.9.1.186" ADDR="10.64.22.39" PACKAGE=1 PACKAGE_IS_SET=0 CM_MANAGED=1 CREATE_DATE=1435042487 AUTO_DISCOVERED=1
DEV 1002 "Switch2969-163" ElemList= PopParent=1000 EmsParent= : UID="FOC1136W0VM" SYSOBJECTID="1.3.6.1.4.1.9.1.694" ADDR="10.64.22.163" PACKAGE=2 PACKAGE_IS_SET=0 CM_MANAGED=1 CREATE_DATE=1435042487 AUTO_DISCOVERED=1
DEV 1003 "dave16555" ElemList= PopParent=1000 EmsParent= : UID="FOC1138Z2UH" SYSOBJECTID="1.3.6.1.4.1.9.1.695" ADDR="10.64.22.165" PACKAGE=2 PACKAGE_IS_SET=0 CM_MANAGED=1 CREATE_DATE=1435042487 AUTO_DISCOVERED=1
DEV 1004 "conor" ElemList= PopParent=1000 EmsParent= : UID="FOC1136W13T" SYSOBJECTID="1.3.6.1.4.1.9.1.694" ADDR="10.64.22.164" PACKAGE=2 PACKAGE_IS_SET=0 CM_MANAGED=1 CREATE_DATE=1435042492 AUTO_DISCOVERED=1
DEV 1005 "Switch167" ElemList= PopParent=1000 EmsParent= : UID="FDO1139Y32M" SYSOBJECTID="1.3.6.1.4.1.9.1.516" ADDR="10.64.22.167" PACKAGE=2 PACKAGE_IS_SET=0 CM_MANAGED=1 CREATE_DATE=1435042492 AUTO_DISCOVERED=1
NET 999 "Default Network" RsrcList= PopList= :
DEV 1005 "Switch167" ElemList= PopParent=1000
su - pgdba -c 'psql voyencedb voyence'
voyencedb=# select device_idx AS "Device ID",
voyencedb-# management_ip_address AS "IP Address"
voyencedb-# from voyence.cm_device;
Device ID | IP Address
-----------+--------------
-1 |
1002 | 10.64.22.163
1004 | 10.64.22.164
1001 | 10.64.22.39
1003 | 10.64.22.165
1005 | 10.64.22.167
voyencedb=# select * from cm_device_server;
device_server_id | device_server_name | device_server_idx | version
---------------------------------------------------+--------------------+-------------------+---------
\012@\034\305\2257\357?\352\370/\037N\001\000\000 | vm-smts-28-197 | 1000 | 0
(1 row)