What version of bdssa? I think this was an issue addressed in sp2 or sp3 or a hotfix for one of those versions.
BDSSA 2.0 SP3
1 of 1 people found this helpful
I want to say this was addressed in sp3hf2 but I could be wrong..
The other thing to look at – if your bdssa server is w2k8, are you running the update_cognos_model.bat after the etl ? (I think that’s the right bat name)
Thanks Bill it could be one of them I will check!
Just FYI, I have found that we can check for the existance of the new extended property by accessing Query/Reports studio and checking BladeLogic > Report Layer > Server > Server Property
Nothing actually shows there so i think the customer has missed a key step.
That sounds like the defect I ran into. I would check the upgrade steps they performed and how they are running the etl…
Bill, are you saying that properties can make it to the CMDB without no modifications to the SQL queries added by BL2Atrium?
I had to deeply modify them in order to achieve this.
Hi G, I haven't done the CMDB integration with BL (just Marimba, old ADDM and Eye of The Storm), but I would also expect it to be necessary to modify the views created for AIE. What does the BL integration use for multi-tenancy, it must map the ITSM Company field from somewhere in BL to handle this? The logical way to do this would be based on a server property ...
No, but if they aren’t showing up in bdssa, that is the first part of the problem.
what I did is to edit the property view created by the BL2Atrium installer.
Find the file called "create_bl2atrium_schema.sql"
Edit the SQL code for BL2ATRIUM_SERVER_PROPERTY_VIEW creation.
It will look like:
CREATE OR REPLACE FORCE VIEW BL2ATRIUM_SERVER_PROPERTY_VIEW
select distinct M.SERVER_HIST_ID,min(case when P.property_name='AGENT_STATUS' then P.property_char_val else null end) "AGENT_STATUS",
At some point, you will find entries such as:
min(case when P.property_name='RSCD_DIR' then P.property_char_val else null end) "RSCD_DIR",
min(case when P.property_name='RSCD_VERSION' then P.property_char_val else null end) "RSCD_VERSION",
Here you can create and add your own piece of code:
min(case when P.property_name='MY_PROPERTY' then P.property_char_val else null end) "MY_PROPERTY",
Please remember that you need to re-rerun the stored procedure creation.
I recommend to delete all BL2Atrium views, tables and procedures and run the sql script again.
This will allow you to make sure that your custom create_bl2atrium_schema.sql script works fine.
For anyone that may be interested.
BL8.0 using SQL DB
BL2Atrium installer loads a SQL script called x:\Program Files\BMC Software\BL2AI\8.0.00\DBScripts\sqlserver\2.0\install_bl2atrium_schema.sql
Add the following to the BL2ATRIUM_SERVER_PROPERTY_VIEW view creation:
MIN(CASE WHEN srvprop.property_name=''_COMPANY'' THEN srvprop.property_char_val ELSE NULL END) AS _COMPANY,
This loads the new custom property as a column in the BL2ATRIUM_SERVER_PROPERTY_VIEW view
The following code will create a new view that contains all the nessesary columns for customising AIE to pull in the _COMPANY property that will form the basis of access controls across both BladeLogic and CMDB.
print 'creating View BL2ATRIUM_AIE_VIEW'
select @sql='Create View BL2ATRIUM_AIE_VIEW
select CS.Server_Name AS Server_Name,
CS.ServerID AS ServerID,
CS.Domain AS Domain,
CS.Category AS Category,
CS.Type AS Type,
CS.Item AS Item,
CS.Host As Host,
CS.Server_State AS Server_State,
CS.Description AS Description,
CS.LastScanned AS LastScanned,
CS.Agent_Status AS Agent_Status,
CS.Is_Virtual AS Is_Virtual,
SP._COMPANY AS _COMPANY
from BL2ATRIUM_COMPUTERSYSTEM_VIEW CS join BL2ATRIUM_SERVER_PROPERTY_VIEW SP
on CS.ServerID = SP.FQN'