Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Exporting the address group in InterScan Messaging Security Suite/Virtual Appliance (IMSS/IMSVA)

    • Updated:
    • 8 Oct 2015
    • Product/Version:
    • InterScan Messaging Security Suite 7.1 Linux
    • InterScan Messaging Security Virtual Appliance 8.2
    • InterScan Messaging Security Virtual Appliance 8.5
    • InterScan Messaging Security Virtual Appliance 9.0
    • Platform:
    • Linux - Red Hat RHEL 3 32-bit
    • Linux - Red Hat RHEL 3 64-bit
    • Linux - Red Hat RHEL 4 32-bit
    • Linux - Red Hat RHEL 4 64-bit
    • Linux - Red Hat RHEL 5 32-bit
    • Linux - Red Hat RHEL 5 64-bit
    • Linux - Red Hat RHEL 6 32-bit
    • Linux - Red Hat RHEL 6 64-bit
    • Linux - SuSE version 10
    • Linux - SuSE version 9
    • Unix - Solaris (Sun) version 10 (SunOS 5.10)
    • Unix - Solaris (Sun) version 8 (SunOS 5.8)
    • Unix - Solaris (Sun) version 9 (SunOS 5.9)
Summary

Export the address group in IMSS or IMSVA as there is no option to do so in the management console.

Details
Public

Using PSQL

You can use psql to export email address by each address group.

Sample result:

# /opt/trend/imss/PostgreSQL/bin/psql -U sa imss
Welcome to psql 8.1.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
imss=# \o
imss=# select content from tb_named_obj where name='';

(If they have several address groups, they can export mail addresses on a per address group basis by changing out file name with "\o")
imss=# \o
imss=# select content from tb_named_obj where name='';
imss=# \o
imss=# \q

Using the Case Diagnostic Tool (CDT)

If you collect CDT data Event2, the tb_named_obj content is exported. You can find the address group content in IMSS_7\LogFile\Event2\tb_named_obj.

Using a browser

You can right click [View Source] on the browser showing the address group edit page, and copy the values in <option> as below:

<select name="selectGroupAddrList" multiple="multiple" size="15" style="width:350px" class="button"><option value="test1000@example.jp">test1000@example.jp</option>

<option value="test1001@example.jp>test1001@example.jp</option>

<option value="test1002@example.jp>test1002@example.jp</option>

<option value="test1003@example.jp>test1003@example.jp</option>

Using the command

/opt/trend/imss/PostgreSQL/bin/psql -U sa imss -tq -c "select content from tb_named_obj
where name='address_group_name' " | perl -n -e 'for (split ";") {s/\s+//g; print "$_\n";}'

Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1055370
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.