Liz, Can't help you with the Ghosting question, but here is the Oracle SQL I use to find fixed references to servers. I can't guarantee it'll catch every possible place a server is referenced, but it covers the major ones. Fixing the references is a different issue, this SQL just finds them.
select 'Table' Item, a.name Form, f.fieldname ObjectName, ft.tfserver ReferredToServer from ARSCHEMA a, field f, field_table ft where a.SCHEMAID = f.schemaid and f.SCHEMAID = ft.SCHEMAID and f.FIELDID = ft.FIELDID and NOT ( tfserver = '@' OR tfserver LIKE '$%$') union select 'AL Push Fields',s.name, a.NAME, substr(ap.assignshort,INSTR(ap.assignshort, '\')+1,substr(ap.assignshort,1,INSTR(ap.assignshort, '\')-1)) from arschema s,actlink a,actlink_mapping am,actlink_push ap where s.schemaid = am.schemaid and am.actlinkid = a.actlinkid and a.ACTLINKID = ap.actlinkid and (not(ap.assignshort like '[EMAIL PROTECTED]') or not(ap.assignlong like '[EMAIL PROTECTED]')) union select 'Active Link Open Window', '', al.name, alo.servername from actlink al, ACTLINK_OPEN alo where al.ACTLINKID = alo.ACTLINKID and NOT ( SERVERNAME = '@' OR SERVERNAME LIKE '$%$') union select 'Active Link CallGuide', '', al.name, alc.servername from actlink al, ACTLINK_CALL alc where al.ACTLINKID = alc.ACTLINKID and NOT ( SERVERNAME = '@' OR SERVERNAME LIKE '$%$') union select 'Menu-Search','', cm.name, cmq.server from char_menu cm, CHAR_MENU_query cmq where cm.CHARMENUID = cmq.CHARMENUID and NOT ( SERVER = '@' OR SERVER LIKE '$%$') union select 'Menu-DataDictionary','', cm.name, cmq.server from char_menu cm, CHAR_MENU_DD cmq where cm.CHARMENUID = cmq.CHARMENUID and NOT ( SERVER = '@' OR SERVER LIKE '$%$') union select 'Menu-SQL','', cm.name, cmq.server from char_menu cm, CHAR_MENU_sql cmq where cm.CHARMENUID = cmq.CHARMENUID and NOT ( SERVER = '@' OR SERVER LIKE '$%$') union select 'Filter CallGuide', '', f.name, fc.servername from filter f, filter_call fc where f.filterid = fc. filterid and NOT ( SERVERNAME = '@' OR SERVERNAME LIKE '$%$') order by 1,2,3 Hope that helps, Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Liz Feulner" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 08/30/2007 11:08 AM Please respond to [email protected] To [email protected] cc Subject Ghosting remedy server ** Environment: Windows 2003, Oracle 10g, ARS 7.0.1, cmdb 2.0.1 patch 3, full ITSM 6 (yes, e have ITSM6 with CMDB 2), DLS 7.0.1, EIE, SMS, Remedy sql link, SLM 7.0.03 We have this environment set up on a test server and this will shortly become our production system. We will then need to quickly build a development serer. To redo all these installs and scripts to make ITSM 6 work with CMDB 2 would take days and days of effort. We would like to take this test server and use it to ghost the new development server and then do a database copy from the current test server to the new development server. Obviously we would have to get the proper licenses for the development server. We anticipate that we may have issues with tables pointing to the wrong server. Are there other likely issues? Is this a reasonable approach? Has anyone successfully done this before? Liz __20060125_______________________This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
