What Spectrum user removed a Landscape from an IP Domain?

Products

• Spectrum
• Network Observability
• CA Performance Management

Issue/Introduction

How to determine which Spectrum user removed a Spectrum Landscape from a Performance Management IP Domain?

Environment

All supported DX NetOps Spectrum releases

Resolution

Login to the landscape that was removed and had to be re-added as the Spectrum install user.

Enter the MySql prompt using this, entering the password when prompted.

cd <SPECROOT>/mysql/bin
./mysql --defaults-file=../my-spectrum.cnf -uroot -p ddmdb -A

Now in my test, I had a landscape associated to the Default domain, then removed it and then re-added. Therefore, the below command should produce two different models with unique handles.

mysql> select * from model where model_name="Default Domain";
+----------+-------------+----------+----------------+
| model_h | landscape_h | mtype_h | model_name |
+----------+-------------+----------+----------------+
| 50331759 | 50331648 | 96731137 | Default Domain |
| 50331760 | 50331648 | 96731137 | Default Domain |
+----------+-------------+----------+----------------+
2 rows in set (0.01 sec)

The top model is the older one, or the one that was deleted when the user removed the landscape from the Domain. We can take that number (50331759) and run:

mysql> select * from event where model_h=50331759 and type=66050 \G;
*************************** 1. row ***************************
model_h: 50331759
utime: 1675963205
counter: 770
clk_seq: 675
version: 1
node_id: €ý Î
user_key: 5
type: 66050
severity: 0
vardata_string:
1 row in set (0.01 sec)

NOTE: Type (66050) is the decimal equivalent of the event generated when a model is destroyed.

Now we take the user_key from above (5) and do this to give us the username:

select * from user_def where user_key=5;
+----------+----------------------------+
| user_key | user_name |
+----------+----------------------------+
| 5 | spectrum@<host> |
+----------+----------------------------+

In this case the user "spectrum" removed the landscape from the GC.