Lisa,
We do the very thing that you're asking for in Spoon. It requires a
couple of lookups from asset people and the dependency form, but the
output is to a spreadsheet with one line per CI (with each association
on the same line).
Once you get the hang of spoon, you'll find other ways of using it.
rp
On 3/2/2015 1:56 PM, Ben Chernys wrote:
**
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: [email protected]
<mailto:[email protected]>
Web: www.softwaretoolhouse.com <http://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/
-----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]] On Behalf Of Rick Cook
Sent: Monday, March 02, 2015 1:27 PM
To: [email protected] <mailto:[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" <[email protected] <mailto:[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>
Cell Phone: (717) 602-9460 <tel:%28717%29%20602-9460>
[email protected] <mailto:[email protected]>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at
www.arslist.org <http://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
<http://www.arslist.org> "Where the Answers Are, and have been for 20
years"
-----
No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2015.0.5645 / Virus Database: 4299/9212 - Release Date: 03/02/15
_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"
