You can run the following MySQL query against the DDMdb database (Archive Manager) to find the models that were created/discovered in a time frame.
By the way, what is the version of your CA Spectrum?
- Open a bash shell (bash -login)
- Navigate to $SPECROOT/mysql/bin directory
cd mysql/bin
- Launch the MySQL command prompt
./mysql -uroot -proot ddmdb (for Windows)
./mysql --defaults-file=../my-spectrum.cnf -uroot -proot ddmdb (for Linux or Solaris)
- Run the following MySQL query:
mysql> select m.model_h, m.mtype_h, u.user_name, m.landscape_h, m.model_name, e.type, FROM_UNIXTIME(e.utime,'%Y %D %M %h:%i:%s') from model m, event e, user_def u where e.model_h=m.model_h and e.user_key=u.user_key and e.type=0x10201 and e.utime > UNIX_TIMESTAMP('2017-09-01 00:00:00') and e.utime < UNIX_TIMESTAMP('2017-09-06 00:00:00') order by m.model_name;
Could be this known issue:
Juniper routers chassis reconfiguration (reconfiguring) causing SpectroSERVER cpu problems and duplicate chassis module…
Thanks,
Silvio