Finding active supported devices on SIEM LP with a SQL Query

This article applies to:

• SIEM LP

Question:

• I need a list of the active supported devices from my LP. Is there a simple way to list those from MySQL?

Procedure:

 Log in to MySQL and use the following commands (note the SELECT statement is a single line):

mysql> use sdw                                                                                                                            

Database changed                                                                                                                          

mysql> SELECT supported_devices.device_id,name,expiry_after FROM supported_devices JOIN device_data_expiry ON supported_devices.device_id=device_data_expiry.device_id;

These commands will display a list of the supported devices for a particular installation. This will also display the expiry time. 

Sample output:

+-----------+----------------------------------------------------+--------------+| device_id | name                                               | expiry_after |+-----------+----------------------------------------------------+--------------+|         1 | McAfeeePO                                          |          180 ||         3 | Symantec AntiVirus - Flatfile                      |         NULL ||         4 | OracleAudit Trail                                  |          180 ||         5 | CheckPoint Firewall                                |         NULL ||         6 | CiscoASA/PIX                                       |          180 ||        11 | JuniperSSL VPN                                     |          180 |  

Here is an additional example of the output: