Note: Known to be incompatible with Excel 2016. Comments on the BigFix Forum
IBM Endpoint Manager (IEM) operators often find that it is useful to extract the wealth of data on the IEM Server for analysis and reporting. They either process the data themselves, or will often send the information to other consumers in an Excel format.
The IEM Excel Connector is created to simplify the data extraction process. It has a Wizard-like interface that makes it easier to extract data from the IEM Server without the need to write Session Relevance language. In addition, the Connector has a built-in session relevance editor to query Web Reports. See a full standalone version of the session relevance editor here.
- TEM 7.2, 8.1, 8.2, 9.0.
- It works with Excel 2003, Excel 2007, Excel 2010 and Excel 2013
- It was tested against XP, Vista, Windows 7, Windows 2008, Windows 8, and Windows 2012 on 32 and 64-bit variants.
- Download the latest Excel Connector version 3.3.3 here.
- Follow the notes in the Installation Readme.txt file. Basically just run the MSI file.
Post questions and comments at the Endpoint Manager Forum. Here is the Link to the Thread.
Videos demonstrating some simple usage scenarios
- Extract Computer Properties (47 secs)
- Single Property Summary (34 secs)
- Import, Open and Save Queries (1 min 28 secs)
- Show Generated Relevance Code (1 min 21 secs)
- The Query Wizard supports extracting data from some common objects such as Fixlets, Actions, Computer properties, etc.
- Users can choose the available properties for the target objects. This makes extracting computer properties particularly easy.
- Filters can be created to limit and hone in on the desired data set.
- Show Relevance Code feature reveals the Session Relevance being generated.
- Query Definitions can be Saved, Opened, Imported, and Exported.
- The Session Relevance Editor allows free form session relevance and the results returned can be automatically split into Excel columns.
- The Session Relevance Editor has syntax highlight for relevance.
Retrieving a single managed property using the Query Wizard. (Excel 2013)
Retrieving multiple managed properties for computers. (Excel 2003)
Adding filtering criteria to the queries.
Show Relevance Code feature is useful to inspect the Session Relevance being generated to retrieve data. (Excel 2010)
Query Definitions can be Opened, Saved, Imported and Exported. (Excel 2013)
Embedded Session Relevance Editor (in Excel 2010)