Feature #87
closedFiltering on fact name
Description
We have been using OCS to manage assets previously. Recently we’ve been using foreman and we are now replicating a lot of asset data in both systems. Ideally we would like to use just one and foreman would be preferable but the filtering of asset details in OCS is very flexible and powerful.
It would be really useful to be able to filter asset details by fact names and to be able to selectively view which fact names you want. If this view can then be downloaded in CSV format it means that we can use the data for reporting purposes outside of the foreman like we currently do with OCS. If we also had the ability to add our own fields into the database for each asset this would replicate all the facilities missing that we use in OCS and we could move to the foreman for asset management.
Updated by Ohad Levy over 14 years ago
Dave Whitehouse wrote:
It would be really useful to be able to filter asset details by fact names and to be able to selectively view which fact names you want.
is it per host or in general? can you give me some examples?
If this view can then be downloaded in CSV format it means that we can use the data for reporting purposes outside of the foreman like we currently do with OCS. If we also had the ability to add our own fields into the database for each asset this would replicate all the facilities missing that we use in OCS and we could move to the foreman for asset management.
exporting to csv or any other format is usually not a problem.
which kind of fields would you like to add? adding a fact name and a value is not a problem, however one of the main benefits of using facter is that you can ensure that the data is updated, manual fields usually are not.
Updated by Ohad Levy over 14 years ago
- Status changed from New to Feedback
- Assignee changed from Ohad Levy to Dave Whitehouse
Updated by Dave Whitehouse over 14 years ago
Ohad Levy wrote:
Dave Whitehouse wrote:
It would be really useful to be able to filter asset details by fact names and to be able to selectively view which fact names you want.
is it per host or in general? can you give me some examples?
It’s a general ability to filter on a fact such as BIOS version for example. I’ve used OSC in the past to list all HP servers with BIOS version 008 for example and then downloaded the list into excel.
If this view can then be downloaded in CSV format it means that we can use the data for reporting purposes outside of the foreman like we currently do with OCS. If we also had the ability to add our own fields into the database for each asset this would replicate all the facilities missing that we use in OCS and we could move to the foreman for asset management.
exporting to csv or any other format is usually not a problem.
which kind of fields would you like to add? adding a fact name and a value is not a problem, however one of the main benefits of using facter is that you can ensure that the data is updated, manual fields usually are not.
The adding of manual fields is less important. Like you say it is something that is a pain to keep upto date. We’ve used if for things like adding in authorative contact details but I’m not sure I’d use that long term.
Updated by Matt Moran over 14 years ago
- Assignee changed from Dave Whitehouse to Ohad Levy
Updated by Ohad Levy over 14 years ago
- Status changed from Feedback to New
- Assignee changed from Ohad Levy to Martin Englund
@Martin Englund: Are you planning to implement the to_csv method as well?
I guess its a good idea to split the facts to their own method/view as eventually the active scaffold wont cut it anymore.
Updated by Martin Englund over 14 years ago
I've created the view /hosts/:id/facts but that only covers facts for that specific host.
I am planning to create a view /facts (or perhaps /hosts/facts) where you view them as: hostname, fact name, fact value. I think that is what Matt is asking for.
I'll see if I can create a to_csv method as well.
Updated by Ohad Levy over 14 years ago
- Status changed from New to Rejected
this has been long implemented, somehow this ticket got lost, closing it as its not relevant any more.