As you probably know, in SEPM GUI, under Policies > Tasks > Search For Applications, you can search for learned applications. If you insert "My company" in "Search for applications" and enable "Search in subfolders" you'll get all learned applications in your SEP domain.
Now you can highlight a result and click on "View Details". This reveals much more infos for every app such as host name, MD5 hash and so on. That's not exactly what you want, but perhaps a step forward.
The only other solution is to access the SEP database directly. For example, to get a minimal list with computer name and application name, you could try this:
SELECT c.COMPUTER_NAME, a1.APPLICATION_NAME
FROM V_SEM_COMPUTER AS c
INNER JOIN COMPUTER_APPLICATION AS a2
ON c.COMPUTER_ID = a2.COMPUTER_ID
INNER JOIN SEM_APPLICATION AS a1
ON a1.APP_HASH = a2.APP_HASH
No warranty though. It's a q&d approach.
SEP database schema:
| Article:DOC6039 |
| |
Created: 2012-09-25 |
| |
Updated: 2014-03-14 |
| |
Article URL http://www.symantec.com/docs/DOC6039
|