Brian, Very interesting. I'll look into this more.
Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: Monday, March 02, 2015 2:31 PM To: arslist@ARSLIST.ORG Subject: Re: CI Relationships ** Maybe it should be a view in the db? Seems that it would be an easier way to set it up. Of course that all depends on your db comfort level. Without getting the field and form names it would simply be: select c.ci, u.used_by, m.managed_by, o.owned_by from ci_form c, used_by_form u, managed_by_form m, owned_by_form o where c.key = u.key and c.key = u.key and c.key = m.key Hope that helps. Brian Goralczyk Phone 574-643-1144 Email bgoralc...@gmail.com On Mon, Mar 2, 2015 at 2:15 PM, Kemes, Lisa A DLA CTR INFORMATION OPERATIONS <lisa.kemes....@dla.mil> wrote: I love this blog and the author (great guy!) but this still doesn't get me what I need. I need to have a report that each row is a ci and on each row you have the Used by, Managed by and Owned by info on one record. I don't think it's possible. It will have to be customized, which we did customize, but it's ugly and that was pre-analytics. Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jarl Grøneng Sent: Monday, March 02, 2015 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: CI Relationships ** Hi This may help you out: https://communities.bmc.com/community/bmcdn/bmc_it_service_support/bmc_asset_management/blog/2013/08/07/the-pulse-getting-the-most-out-of-your-ci-people-relationships -- J 2015-03-02 19:22 GMT+01:00 Kemes, Lisa A DLA CTR INFORMATION OPERATIONS <lisa.kemes....@dla.mil>: For some reason, our customer wants to see all CI relationships (Owned by, Used by, etc) on one row in a report, so we have a TON of customizations to create one record for each CI with all these relationships on it. I've proposed using Analytics (we have this and use it) for this but it wouldn't be on one row. Does anyone else have this need that has been able to provide this type of report out of the box without customizations? Lisa Kemes Remedy Consultant Dev Technology Group DLA Office: (717) 770-6437 <tel:%28717%29%20770-6437> <tel:%28717%29%20770-6437> Cell Phone: (717) 602-9460 <tel:%28717%29%20602-9460> <tel:%28717%29%20602-9460> lisa.ke...@devtechnology.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
