How to get the history of a particular IP address in SolusVM?

Updated March 21, 2023 19:20

Bato Tsydenov

Have more questions? Submit a request

Applicable to:

This is not possible to do via SolusVM UI. However, the data can be fetched from SolusVM database directly:

Connect to Master node via SSH
Access the database:
# awk -F: '{ system("MYSQL_PWD='"'"'" $3 "'"'"' mysql -u " $2 " "$1) }' /usr/local/solusvm/includes/solusvm.conf
Run the query:
MYSQL_LIN: SELECT subject FROM systemmessages WHERE subject LIKE '%ip: 203.0.113.2%' AND (subject LIKE '%Build%' OR subject LIKE '%Add additional IP]%' OR subject LIKE '%Destroy%');

0 comments

Please sign in to leave a comment.