Cisco Cisco Mobility Unified Reporting
MURAL Software Standard Installation Guide
Validating Bulk Stats Data on the Insta Blade
1.
Use SSH to log in to the master Insta node and check the name of the
database configured for EDR:
>
en
#
_shell
#
cli -t "en" "conf t" "show runn full" |
grep "insta instance 1 cubes-database" | awk -F ' ' '{print $5}
'bulkstats
2.
Open the
idbmysql
user interface and select
bulkStats
as the database.
#
idbmysql
Welcome to the MySQL monitor.
Commands end with ; or \g.
...
mysql>
use bulkStats;
Database changed
3.
Display the values in the
mints
and
maxts
columns for the 900
aggregation interval (shown in the second row in the example).
mysql>
select * from bin_metatable;
+----------+---------------------+------------+------------+---------+
| binclass | aggregationinterval | mints
| maxts
| binType |
+----------+---------------------+------------+------------+---------+
| 5min
|
-1 |
0 |
0 | NULL
|
| 5min
|
900 | 1406713500 | 1409301900 | NULL
|
| 5min
|
3600 |
0 |
0 | NULL
|
| 5min
|
86400 |
0 |
0 | NULL
|
| 5min
|
604800 |
0 |
0 | NULL
|
| 5min
|
2419200 |
0 |
0 | NULL
|
+----------+---------------------+------------+------------+---------+
6 rows in set (12.18 sec)
mysql>
quit
4.
Convert the date format. Run the
date
command with the value of
maxts
(captured from the step above) for the row which shows
aggregationinterval
as 900.
120
Copyright © 2015, Cisco Systems, Inc.