Hi Claire, You could use Meta-Update. A job like this would take about 5 lines of scripting:
[Desktops] Query = BE, BMC:BMC_AssetBase, "some field' = "some criteria that selects the records" Update = BE Merge = Yes, NoWorkflow Assign = asg [asg] Category = Desktop You could go further by parameterising the query and assignment attributes. The gist of it is to use Merge which the import tool uses (though indeed it does not allow you to turn off Merge workflow. So, you could do it manually by doing an advanced query on BMC:BMC_AssetBase to select those records that are to be (say) Desktops, generating a CSV of the Ids, using the Merge tool to assign "Desktop" to those Ids. And so on. I think the import tool of 6.3 allowed you to specify a constant for assignments but am not sure. If not, just add a column in excel for the category. Note that there are issues with what you want to do in the first place. For example, it IS a change to a CI and so it may want to be audited or a Diary entry appended indicating that the change occurred. Both these can be added to the Meta-Update script above. A trial license is free and would accomplish your goal. Also note that the Category value may be in other tables. I just checked SHR:Association and you're in luck. It's not there. Certainly in 7 it would be a tougher job and you would have to effect the same updates as the workflow would have effected (easily done with Meta-Update). The list of schemas with the Category field is (through a simple egrep): Note this list does not include fields which may have the category value in them (such as SHR:Audit) and will include other Category fields not related to this category field. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: mailto:ben.cher...@softwaretoolhouse.com Web: http://www.softwaretoolhouse.com A free notepad for Diary fields: http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm An ARS API scripting tool used for migrations, integrations, imports, reports, extracts, batch jobs: http://www.softwaretoolhouse.com/products/SthMupd schema: AP:Admin-DeleteVerify 0 11000 Enum 0 0 6 Category schema: AP:Administration 13 11000 Enum 0 0 6 Category schema: AST:ConfigurationSearch_dlg 0 200000003 Char 60 0 1 4 Category schema: AST:InventoryStorage 31 200000003 Char 60 0 1 4 Category schema: AST:ManageInventory 0 200000003 Char 60 0 1 4 Category schema: AST:Notifications 9 200000003 Char 60 0 1 4 Category schema: AST:OSGenericSearch_dlg 2 200000003 Char 60 0 1 4 Category schema: AST:PurchaseLineItem 14 200000003 Char 60 0 1 4 Category schema: AST:Schedule Criteria 13 200000003 Char 60 0 1 4 Category schema: AST:dlgSelectSchedule 0 200000003 Char 60 0 1 4 Category schema: Application Pending 7 8 Char 254 1 0 4 Category schema: BMC:BMC_AssetBase 23 200000003 Char 60 0 1 4 Category schema: CHG:ApprovalID 10 200000003 Char 60 0 1 4 Category schema: CHG:ChangeTemplate 9 200000003 Char 60 0 1 4 Category schema: CHG:PredefinedTasks 0 200000003 Char 60 0 1 4 Category schema: CHG:dlgAddApprovCategory 9 200000003 Char 60 0 1 4 Category schema: CHG:dlgModifyApprovCategory 9 200000003 Char 60 0 1 4 Category schema: Group 15 120 Enum 1 0 6 Group Category schema: HPD:HelpDesk 229 260000123 Char 180 0 0 4 Case Category - Type - Item schema: HPD:SolutionSearch 0 200000003 Char 60 0 1 4 Category schema: HPD:Solutions 29 100000101 Char 152 1 0 4 Case Category - Type - Item schema: RR:SolutionSearch 0 200000003 Char 60 0 1 4 Category schema: Remedy Approver 43 300749200 Column 0 0 34 Category Column(Category) schema: Remedy Asset - Manager 12 200000003 Char 60 0 1 4 Category schema: Remedy Management 81 300749200 Column 0 0 34 Approvals - Category Column(Category) schema: Remedy Requester - New Request 0 200000003 Char 50 0 0 4 Category schema: Remedy Support 85 301144500 Page 0 0 35 By Category schema: Remedy Support - New Request 0 200000003 Char 60 0 1 4 Category schema: Report 31 400094600 Char 128 0 0 4 Category 1 32 400094700 Char 128 0 0 4 Category 2 33 400094800 Char 128 0 0 4 Category 3 schema: SHR:Assignment 9 200000003 Char 60 0 1 4 Category schema: SHR:Categorization 60 300798200 Control 0 0 32 Modify Category schema: SHR:Company 36 260000001 Char 128 0 1 4 Category schema: SHR:ConsolidatedList 9 200000003 Char 60 1 1 4 Category schema: SHR:DefineAssociation 9 200000003 Char 60 0 1 4 Category schema: SHRCFG:ConfigASTNotification 11 200000003 Char 60 0 1 4 Category schema: SHRCFG:ConfigAddSkillsDialog 0 200000003 Char 60 0 1 4 Category schema: SHRCFG:ConfigAssetDepreciationCriteria 11 200000003 Char 60 0 1 4 Category schema: SHRCFG:ConfigCHGEscalations 35 300798200 Control 0 0 32 Modify Category schema: SHRCFG:ConfigCompany 9 200000003 Char 60 0 1 4 Category schema: SHRCFG:ConfigCostRates 10 200000003 Char 60 0 1 4 Category schema: SHRCFG:ConfigGroupSkills 12 200000003 Char 60 0 1 4 Category schema: SHRCFG:ConfigHPDEscalations 39 300798200 Control 0 0 32 Modify Category schema: SHRCFG:ConfigIPAddresses schema: SHRCFG:ConfigIndSkills 13 200000003 Char 60 0 1 4 Category schema: SLA:Flashboards for Asset Management 0 200000003 Char 50 0 1 4 Category schema: SLA:Measurement 39 300426800 Char 80 0 0 4 SLA Goal Category Char schema: SLA:PerformanceMeasurement 24 300426800 Char 80 0 0 4 SLA Goal Category Char schema: SLA:Sample Event Monitor 15 300539300 Enum 0 0 6 Category schema: SLA:Sample Threshold 15 300539300 Enum 0 0 6 Category schema: SLA:Service Request 46 300539300 Enum 0 0 6 Category schema: SLA:TeamMeasurement 21 300426800 Char 80 0 0 4 SLA Goal Category Char -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sanford, Claire Sent: October 7, 2009 7:44 PM To: arslist@ARSLIST.ORG Subject: Update Record and not change Modify Date Other than going in the wrong way and doing it at the DB level, is there a way for me to update/change 30K records without changing the last modified name and date fields? We are starting to do things the right way and are making the distinction between a Laptop and a Desktop Computer in an asset record. So, I will have to go in and change the records to reflect a different Category name. Was: Computer Will be: Desktop Was: Computer Will be: Notebook ARS 6.3 Patch 18 HD 6.0 Oracle 10.2.0.4.0 w/9 libraries Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server Claire Sanford Information Systems Division Memorial Hermann Healthcare System Phone: 713 448 6035 claire.sanf...@memorialhermann.org ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
