Listing supported devices/device numbers on SIEM LP with a SQL Query


This article applies to:

  • SIEM LP

Question:

  • How do I get a list of all the supported devices with their device ID numbers without opening all the devices through the UI?

Procedure:

 

Log into the MySQL instance and run the following commands. These commands will display a full list of the supported devices for a particular installation:

mysql> use sdw

Database changed

mysql> select * from supported_devices;

 

Sample output:

+-----------+-----------+--------------------------------------+------------------+| device_id | vendor_id | name                                 |primary_class_id |+-----------+-----------+--------------------------------------+------------------+|         0 |        18 | RSA ACE Server                       |                0 ||         1 |        14 | Mcafee ePO                           |                1 ||         3 |        23 | Symantec Anti Virus                  |                1 ||         4 |        16 | Oracle Audit Trail                   |                2 ||         5 |         1 | Check Point Firewall                 |                3 ||         6 |         2 | Cisco ASA/PIX                        |                3 ||         7 |         2 | Cisco VPN Concentrator               |                3 ||         8 |         3 | Cyberguard                           |                3 ||         9 |        19 | Secure Computing Gauntlet FW         |                3 ||        11 |        13 | Juniper Networks Neoteris VPN        |                3 ||        12 |        13 | Juniper Networks Netscreen           |                3 | +-----------+-----------+--------------------------------------+------------------+

Additional sample of output:

 

 


Last Modified 9/13/2013.
https://support.trustwave.com/kb/KnowledgebaseArticle15434.aspx