A non-trivial view should do it. You might need to add a proc or two to accumulate all AST:AssetPeople into strings. That and some joins. It’s trickier if you do need class and/or people specific attributes. You’d have to devise a syntax for a “Used By” string.
A simple Meta-Update script would do it do (about 1 hr dev/test time). You’d have a repeatable process you could run on any CI subset at any time. Meta-Update required absolutely zero server changes and goes through the API. The script would be ready for a free 30-day trial J CI Name Class Used By Supported By Other data from the CI's and CTM:People as needed including class specific attributes Server1 Computer System Ben, John, Grimus Group IT 1, Group 2 Cheers, Ben Chernys Senior Software Architect logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:[email protected]> [email protected] Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as the tree of data and forms that it is it is. Pre ITSM 7.6.04? Clarify? Roll your own? No problem! You can keep your valuable data! <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa A DLA CTR INFORMATION OPERATIONS Sent: March-02-15 11:59 To: [email protected] Subject: Re: CI Relationships That information is there, but not in one record. So if you have 3 relationships to a CI, it will be 3 records. -----Original Message----- From: Action Request System discussion list(ARSList) [ <mailto:[email protected]> mailto:[email protected]] On Behalf Of Rick Cook Sent: Monday, March 02, 2015 1:27 PM To: <mailto:[email protected]> [email protected] Subject: Re: CI Relationships ** I think that's in the Asset people Form. Rick On Mar 2, 2015 10:23 AM, "Kemes, Lisa A DLA CTR INFORMATION OPERATIONS" < <mailto:[email protected]> [email protected]> wrote: 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> <mailto:[email protected]> [email protected] _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at <http://www.arslist.org> 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 <http://www.arslist.org> www.arslist.org "Where the Answers Are, and have been for 20 years" ----- No virus found in this message. Checked by AVG - <http://www.avg.com> www.avg.com Version: 2015.0.5645 / Virus Database: 4299/9212 - Release Date: 03/02/15 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
smime.p7s
Description: S/MIME cryptographic signature
