Environment

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

Objective

Resolution

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"

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 Notes

• 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

Related Content