REST API - Execute a custom report (Answered)

Customizations
1

Hi

I’m developing an integration that is pulling data out of BigFix via its REST API. For this I have a custom analysis that is collecting data from the clients, and I can retrieve this data, so all good. I also want to pull out general device details, but the complete set of data seems to come from multiple analyses, and I’m not sure how to link all of this data together in a single session relevance query.

I can produce a custom report that has all of the device details I am looking to pull out. I’m looking for details such as:

device name, domain, make, model, cpu name, cpu count, core count, ram, last logged user, BIOS date (and more.)

So I have some questions:

1, Is it possible via the REST API to call a custom report by name to pull out the data?
2, Is it possible to export the report definition so it can be distributed?
3, Is it possible to get the session relevance query definition from a report so that I can re-use it?

Any help and advice in this regard would be helpful.

Thanks

Gary

2

1, Is it possible via the REST API to call a custom report by name to pull out the data?

If by custom report, you mean a custom Web Report, not really, no. That said, you can create a scheduled task within Web Reports to output the data associated with the custom report on a periodic basis to email or file which can potentially be used for your integration.

2, Is it possible to export the report definition so it can be distributed?

If the Custom Report leverages session relevance, than yes (you could extract the session relevance for the report definition by click ‘Edit Source’. Stored reports generated via the Native Web Reports UI do not have associated session relevance.

3, Is it possible to get the session relevance query definition from a report so that I can re-use it?

See answer 2 above.

3

This post seems to be a duplicate of this one: REST API - Session Relevance Query - Join results from multiple analyses (Answered)

It is a bit confusing to follow given that there is slightly different info in both and slightly different answers, so it is not a complete duplicate.

4

Thanks @Aram for your comprehensive answer. :smile:

Cheers

Gary

5

One query was ‘can you call a Web Report from the REST interface’, which @Aram has kindly confirmed that you cannot, and the other was ‘how do you join multiple analysis results into a single session relevance query’, which @Aram informed me of the Excel Connector that can simplify the creation of such queries.

1 Like