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_hmemailtaglineapril07
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
