Fetches records for database in a specified cluster.
Examples
Example 1:
The following is an example of fetching 30 records starting from 10 index from an IPv6 database in a binding cluster for the
query "{'uuid': {'$regex': 'vpas-system-1200'}}”.
Default <= 5 records are displayed, all 30 records are saved in /data/config/Query.log. admin@orchestrator[Binding-master]#
database query clustername binding dbname IPV6 query "{'uuid': {'$regex': 'vpas-system-1200'}}" method find max 30 start 10
Press yes to continue
(yes/no) << yes
{'_id': '2507:9903:1808:0583',
'fqdn': 'site-d-client-calipers21-gx.pcef.gx',
'sessionid': 'kmanchan21411kunalmanchanda2',
'srk': 'server.sitedstandalone',
'staleBindingExpiryTime': datetime.datetime(2021, 5, 10, 13, 27, 24, 762000),
'systemId': 'vpas-system-1',
'ts': 1620048444762,
'uuid': 'vpas-system-12002439730'}
{'_id': '2507:9903:1808:061a',
'fqdn': 'site-d-client-calipers21-gx.pcef.gx',
'sessionid': 'kmanchan21562kunalmanchanda2',
'srk': 'server.sitedstandalone',
'staleBindingExpiryTime': datetime.datetime(2021, 5, 10, 13, 27, 24, 763000),
'systemId': 'vpas-system-1',
'ts': 1620048444763,
'uuid': 'vpas-system-12002439881'}
{'_id': '2507:9903:1808:065d',
'fqdn': 'site-d-client-calipers21-gx.pcef.gx',
'sessionid': 'kmanchan21629kunalmanchanda2',
'srk': 'server.sitedstandalone',
'staleBindingExpiryTime': datetime.datetime(2021, 5, 10, 13, 27, 24, 763000),
'systemId': 'vpas-system-1',
'ts': 1620048444763,
'uuid': 'vpas-system-12002439948'}
{'_id': '2507:9903:1808:0694',
'fqdn': 'site-d-client-calipers21-gx.pcef.gx',
'sessionid': 'kmanchan21684kunalmanchanda2',
'srk': 'server.sitedstandalone',
'staleBindingExpiryTime': datetime.datetime(2021, 5, 10, 13, 27, 24, 764000),
'systemId': 'vpas-system-1',
'ts': 1620048444764,
'uuid': 'vpas-system-12002440003'}
{'_id': '2507:9903:1808:06b7',
'fqdn': 'site-d-client-calipers21-gx.pcef.gx',
'sessionid': 'kmanchan21719kunalmanchanda2',
'srk': 'server.sitedstandalone',
'staleBindingExpiryTime': datetime.datetime(2021, 5, 10, 13, 27, 24, 766000),
'systemId': 'vpas-system-1',
'ts': 1620048444766,
'uuid': 'vpas-system-12002440038'}
Default <= 5 records are displayed, Kindly check records in /data/config/Query.log based on max value provided.
Example 2:
The following is an example for fetching maximum record value starting from 10 index from an IPv4 database in a binding cluster.
Default <= 5 records are displayed, all the records are saved in /data/config/Query.log.
admin@orchestrator[site2-binding-master-1]# database query clustername binding dbname IPV4 query "" method find max 5 start
10
Press yes to continue
(yes/no) << yes
{'_id': '2001:0000:0000:01d9',
'fqdn': 'site-b-client-calipers21-gx.pcef.gx1',
'sessionid': 'ClpGx0:192.168.31.213:4007:1608137498:0000000474',
'srk': 'server.sitebstandalone',
'staleBindingExpiryTime': datetime.datetime(2020, 12, 26, 17, 18, 14, 518000),
'ts': 1608138406690,
'uuid': 'site1-system552221945'}
...
Default <= 5 records are displayed, Kindly check records in /data/config/Query.log based on max value provided.
admin@orchestrator[site2-binding-master-1]#