I have it on good authority from BMC that they understand that this is an issue and that future releases of EIE and CMDB will accommodate using the DSL to normalize other sources of data.
Regards, Adam Pederson Practice Director IT Service Management Practice Xinify Technologies, Inc. Mobile: +1 925 895 9500 Email: [EMAIL PROTECTED] -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Parker Sent: Thursday, April 26, 2007 2:26 PM To: [email protected] Subject: Re: DSL - How does it normalize? Hi Alfonso: I agree - that works great...if someone has Marimba (or Discovery Service as I think its called now) - but what if someone wants to use SMS (or other discovery method) as their source? Based on the research I've done so far, it looks like those poor folks have to come up with their own methods of normalizing data that goes into the CMDB. I suppose the bottom line is that it "encourages" people to purchase BMC's discovery products...but still... >From: Alfonso Eric B Contr 95 CG/SCCSS <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: Re: DSL - How does it normalize? >Date: Thu, 26 Apr 2007 13:23:28 -0700 > >I posed the same question to BMC and received the response below. > >From BMC: >How is the data normalized from DSL and Inventory? > >Normalization happens inside the "inv_application" view or >"mrb_inv_application" view in case of CD-integration (for EIE purposes). >It happens "on-the-fly" where we join Configuration Management views >with the cache DSL data in certain tables in the CM database. When >data is inserted into the Inventory database from the inv plugin, its >inserted NON-normalized. The normalization happens on the fly when >someone wants to view the app data. > >There is a stored procedure "refresh_pdl_tables" which is used to >normalize the data right away so that we don't have to go over the Data >base-link for EVERY single application normalization. The procedure >will refresh the PDL tables. On SQL there is a explicit job called >"Refresh PDL Tables" which can be scheduled to run every night at >11:59pm which invokes the "refresh_pdl_tables" stored procedure. I >believe there is no such "job" on Oracle, but I'm still verifying the >behavior and will update you once I have confirmed. > >Regarding documentation on the above topics, I could not find a detailed >description explaining the above, so I will be filing a defect for >documentation to include a section in the DSL docs which details the >process for normalizing the data in the Inventory database against the >DSL. > > >Eric Alfonso, Contractor, 95 CG/SCCSS >Remedy Support Team >[EMAIL PROTECTED] > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Mike Parker >Sent: Thursday, April 26, 2007 1:16 PM >To: [email protected] >Subject: DSL - How does it normalize? > >Hi everyone: > >I have a question regarding the DSL that I just can't seem to figure >out. > >In the documentation for the DSL, CMDB, Archtecture, etc. it states that >the "DSL is used to normalize the data going into the CMDB". > >However, I've been searching through all the documentation, and spent a >day going through the workflow, forms, active links, filters, etc. that >touch the DSL, and I simply cannot see how the DSL interacts with the >CMDB at all. > >The closest interaction with anything regarding the DSL is with >Contracts and the Product Catalog (and even that is pretty limited) > >Does anyone have any idea how the DSL normalizes data going into the >CMDB? >Or better yet, even how to set it up to normalize data that goes in the >CMDB? > >_________________________________________________________________ >Exercise your brain! Try Flexicon. >http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglin >eapril07 > >________________________________________________________________________ >_______ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >the Answers Are" > >___________________________________________________________________________ ____ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >the Answers Are" _________________________________________________________________ Exercise your brain! Try Flexicon. http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglineapr il07 ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
