How do I determine the Administrator users of the SQM website?

This article applies to:

• Trustwave MailMarshal (SEG) Spam Quarantine Mangement website
• Trustwave ECM/MailMarshal Exchange 7.X Quarantine Management website

Question:

• SQM Administrator tab is not visible
• What users have Administrator rights to the SQM website? 

Information:

The SQM/QM website installation automatically grants administrator access to the user who first accesses and configures the site. Depending on the option selected, this could be a Windows account or an email address login.

A user with administrator access can grant administrator access to other users.

If you have forgotten which user is configured as administrator, you can run a SQL query to retrieve this information.

1. Determine the SQL server name and instance, and the MailMarshal database name.
2. Use SQL Server Management Studio to connect to the SQL server.
   • For details about obtaining Management Studio, see Trustwave Knowledgebase article Q10576.
3. Run the following query (replace "MailMarshalDBName" with the name of the MailMarshal SMTP or MailMarshal Exchange Database):
   
   use [MailMarshalDBName]
   select UserName, FullName from [user] where UserRole='2'
   
   
   The result lists administrative users of the SQM or QM website.