IMPORTANT ANNOUNCEMENT: On May 6, 2024, Carbon Black User eXchange (UeX) and Case Management will move to a new platform!
The Community will be in read-only mode starting April 19th, 7:00 AM PDT. Check out the blog post!
You will still be able to use the case portal to create and interact with your support cases until the transition, view more information here!

App Control: How To Find The Number of Global Approvals in an Environment

App Control: How To Find The Number of Global Approvals in an Environment

Environment

  • App Control Console: All Supported Versions

Objective

Find all Global Approvals in the environment.

Resolution

From the Console:
  1. Log in to the Console and navigate to Rules > Software Rules > Files
  2. Add a filter of "Type = Approval" 
  3. Group by: Type
  4. If any groups are expanded - click the "-" to shrink
  5. Item count is listed for group type "Approval"

From SQL Server Management Studio:
  1. Log in to the application server as the Carbon Black Service Account.
  2. Launch SQL Server Management Studio and connect to the database.
  3. Execute the following query:
    USE das;
    SELECT First_Created, Last_Updated, First_Seen_Name, First_Seen_Path, Publisher_or_Company, Global_State, State_Source, Hash, description from dbo.AntibodiesGUI (nolock) WHERE Global_State='Approved'; 

Related Content


Labels (1)
Tags (2)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎09-17-2018
Views:
532
Contributors