-
Suggestion
-
Resolution: Unresolved
-
None
-
4
-
5
-
Is it possible to generate a report (or export to excel) an object with its attributes, and the attributes of referenced objects?For example, if I have an employee named A who uses "laptop1" with S/N "SN1".I created an object called Laptop with attributes:name, and S/NI created another object called "employee" with attributes: name and laptop.Can I export the employee name, laptop name, and S/N in one excel sheet?I know too much details, but just to make the request clear 
- links to
[JSDSERVER-7860] More detailed asset management report
So, from what I understand it is the feature I'm missing as well since ever and it is simple:
A Report / AQL search result should not only be able to show the attributes of one object type but also of referenced objects. Period.
It is as simple as in this SQL example:
select tableA.col1, tableA,col2, tableB.col2 from tableA, tableB where tableA.tableB_id = tableB.id
But Insight/Assets-reports can not do something equivalent.
So, if this issue is about exactly this, then it's a joke that there is only one person asking for this before me. It was asked in the Riada-Jira already which is mentioned in community posts.
And seriously, it's a joke that I have even to write this comment. This is not something what needs to be asked, that must be expected as a feature to be there. Period.
Asset Reports are straight useless without this.
Having the ability to run a SQL-ish join when generating reports would be an incredibly useful feature.
Currently, we are much like the OP where we have objects that reference other objects that reference others and would love some way to create a report that can traverse those links, de-duplicate if necessary, and provide our report.
Example Schema:
Software
+ Applications
Name: Text
Security Guidelines: Object-> Security Guidelines
+ Application Suites
Name: Text
Suite Member(s): Object -> Applications
+ Baselines
Name: Text
Baseline Members(s): Object->Software (AQL `objectType IN ("Applications", "Application Suites")`
Equipment
+ Compute Node
Name: Text
Software Baseline: Object->Software Baselines
Non-Baseline Software: Object->Software (AQL `objectType IN ("Applications", "Application Suites")`
Cybersecurity
+ Security Guidelines
Name: Text
Guideline: Text
If I run a report on Compute Nodes, I would expect the ability to create joins such that the compute node is shown with a complete list of its software (resolved and de-duplicated via `Software Baselines`, `Application Suites` and `Applications` as well as all available `Security Guidelines` from the resolved application objects.