Hi Lisa, All
Anytime you want to do bulk updated of any kind to ITSM / Remedy data,
Meta-Update will allow you to do so with ease and security. The discussion
below implies a total effort of under an hour in Meta-Update. If you wanted
to write a small Remedy GUI so others would perform moves, then you could
add a few more hours and as a last filter, simply fire a Meta-Update script
to validate and make the bulk changes.
Here's a short Meta-Update script to look for a floor in all CIs (Yes, use
BaseElement for any attribute common to all classes) and make the
appropriate change to these CIs would be trivial:
[Do]
Query = Src,
BMC.CORE:BMC_BaseElement,
.ARS Query Criteria. and
'Floor' = "$Arg, OldFloor$" and
'Room' = "$Arg, OldRoom$"
Update = Src
Assign = Src-asg
[Src-asg]
Floor = Arg, NewFloor
Room = Arg, NewRoom
The fire it:
SthMupd.exe FloorRoomChange.ini Do -p OldFloor OldRoom NewFloor NewRoom
Of course, the query will need to be improved J You could also load your
arguments from a Remedy record. And, if you wanted to update the
appropriate join, you'd only need a couple more lines to load the class
record from Base Element and update the Class Join.
Trial licenses come with our free "Live Install" service free we introduce
the products. With our free Scripting 101 presentation and the samples, you
should well solve your data problems fast and sure.
For more information, check out the web site or contact us.
Cheers
Ben Chernys
Senior Software Architect
Description: logoSthInc-sm
Canada / Deutschland
Mobile: +49 171 380 2329 GMT + 1 + [ DST ]
Email: Ben.Chernys_AT_softwaretoolhouse.com
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 out Freebies
Section for ITSM 7.6.04 and 8.0.0 Fields spreadsheets.
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.
<http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Pierson, Shawn
Sent: February-14-13 20:40
To: [email protected]
Subject: Re: Bulk Updates (Relocate) CI
**
Unfortunately, there isn't a good way to do this for the average Asset
Management user. The easiest way for someone like you is to find the CIs on
Base Element (since that's the only way to make updates across classes) and
do a Modify All. For example, in our organization we keep moving buildings,
so Floor 12 in this building being moved to the next building will require
an update to the Site and Floor. I've been considering making a
customization to update the Room field in Asset Management from the People
record of the person assigned as the "Used By" in the case of client
technology. That may be something else you'd want to look to keep the data
maintained.
Thanks,
Shawn Pierson
Remedy Developer | Energy Transfer
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Lisa Kemes
Sent: Thursday, February 14, 2013 1:34 PM
To: [email protected]
Subject: Bulk Updates (Relocate) CI
**
ARS 7.6.04 SP2/Linux/Oracle.
Customer would like to include Floor and Room when doing bulk updates when
relocated CI's (right now you can only choose Company, Region, Site Group
and Site). Seems like a valid request. (when you are relocating CI's, the
room and floor are probably going to change as well) Has anyone
successfully done this before? I can probably figure it out, just let me
know of any gotchas or any tips and tricks if you have them. I would
appreciate it!
Thanks!
Lisa Kemes
_ARSlist: "Where the Answers Are" and have been for 20 years_
Private and confidential as detailed here
<http://www.energytransfer.com/mail_disclaimer.aspx> . If you cannot access
hyperlink, please e-mail sender.
_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"
<<image003.jpg>>
smime.p7s
Description: S/MIME cryptographic signature
