App Control: How to Export List of Application and Assets

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

How to export a list of applications and assets in App Control

Environment

• App Control Console (formerly CB Protection): All Supported Versions
• Microsoft SQL Server: All Supported Versions

Resolution

Exporting from the Console

1. Log into the App Control console
2. Navigate to Assets > Applications
3. Move to Applications on Computers tab
4. Apply the filters or columns required and click "export to CSV"

Exporting from SQL (Note: If the data is too large to export directly to CSV )

1. Login to SQL Management Studio 
2. Run the following query 

   use das;
   go 
   SELECT c.Computer, ac.appName, ac.appPublisher, ac.appVersion, ai.estimatedDiskUsage, ai.installDate, ai.installDirectory, ai.installedFor, ai.languageId, ai.localPackage,
   ai.repairCommandLine, ai.source, ai.uninstallCommandLine, ai.uninstallKey, ac.aboutURL, ac.comments, ac.company,
   ac.helpTelephone, ac.helpURL, ac.packageCode, ac.productCode, ac.readme,
   ac.upgradeCode, ac.upgradeURL, ac.windowsInstaller
   FROM dbo.API_AppCatalog (NOLOCK) as ac
   JOIN dbo.API_AppInstance (NOLOCK) as ai ON ac.id = ai.appCatalogId
   JOIN bit9_public.ExComputers (NOLOCK) as c ON ai.computerId = c.Computer_Id
   ORDER BY Computer, appName, appVersion

Additional Information

• The Applications page shows Windows applications only
• Applications are shown only for agents reporting to the current server
• There is no Unified Management for applications