View Related Objects
Ryan_Ephgrave
Customer IT Monkey ✭
in Asset Excel
Is there a way to view related objects when searching for assets? For instance, see what computers have software installed.
0
Best Answer
-
Brett_Moffett
Cireson PACE Super IT Monkey ✭✭✭✭✭
Sorry. I should have been more clear.
There is no way to do this in Asset Excel.
If you wish to do it, then the best way is via the console in the way described above and export it to CSV then open it in Excel.
Asset Excel was more for the manipulation of bulk Assets rather than a reporting tool.
If you are wanting to report in Excel then i would suggest the Asset OLAP Cube's and using pivot tables to report on what you need.
Hope this answers your question.5
Answers
The Cireson Portal or the SCSM Console?
If you are looking for each computer that has a certain Software Asset installed then it appears on the Related Assets tab.
You can even export this list out to a CSV file if you like.
Hope this is what you are after.
If not, you can use the Software Asset (Full) type projection within Advanced Search of the console if you want to search across all Software assets for something in particular.
Hope this answers your question.
Can the Excel app show relationships? My client wants to be able to pull up a list of computers and primary users of those computers in Excel.
There is no way to do this in Asset Excel.
If you wish to do it, then the best way is via the console in the way described above and export it to CSV then open it in Excel.
Asset Excel was more for the manipulation of bulk Assets rather than a reporting tool.
If you are wanting to report in Excel then i would suggest the Asset OLAP Cube's and using pivot tables to report on what you need.
Hope this answers your question.