www.blackholesurfer.com

tpl 1.5 module CMDB.Extension.ComputerSystem_Augment; from CDMB.Host_ComputerSystem import Host_Computer 2.0; syncmapping ComputerSystem_Augment 1.0 """ Add or more attributes to BMC_ComputerSystem CI """ overview tags CMDB, Extension; end overview mapping from Host_ComputerSystem.host as host // No...

tpl 1.5 module CMDB.Extension.Database_Augment_CTI; metadata origin := 'BlackholeSurfer'; tree_path := 'BlackholeSurfer','CMDB sync','Database'; end metadata; from CMDB.Database import Database 2.3; syncmapping Database_Augment 2.0 """ Describe what this does for those that will need it and what it ...

tpl 1.12 module CMDB.Host_Document; from CMDB.Host_ComputerSystem import Host_ComputerSystem 2.2; syncmapping Host_Document 1.0 """ Maps Hosted info to be Documented to BMC_Document """ overview tags CMDB, Extension; end overview; mapping from Host_ComputerSystem.host as host document -> BMC_Documen...

tpl 1.14 module AssetInfoFromSQL_Oracle; metadata origin := "BlackholeSurfer"; tree_path := 'BlackholeSurfer','Database','Oracle'; end metadata; from SearchFunctions import SearchFunctions 1.5; from Oracle.OracleRDBMS import DatabaseServer 6.0; definitions OracleDetails 4.0 """ Relational Database Q...

select ap.instanceid as ap179, ap.serialnumber as apsnlist, cs.instanceid as CS179, cs.apmlistonhost as csapidlist from bmc_core_bmc_computersysterm cs left join BMC_CORE_BMC_application ap ap.datasetid = 'MYDATA.STAGE' and cs.datasetid = 'MYDATA.STAGE' and cs.APMListOnHost is not null where cs.data...

select distinct db.instanceid as db179, sa.instanceid as SA179 from BMC_CORE_BMC_Database db left join BMC_CORE_BMC_Dependency r on r.Source_InstanceID = DB.InstanceId and r.name = 'APPLICATIONDATABASE' left join BMC_CORE_BMC_Application a on a.InstanceId = r.destination_instanceid left join BMC_COR...

Take a look at the 9.1 class hierarchy:

http://www.blackholesurfer.com/temp/9.1/

This is my stuff.

Report on 100K CIs in ADDM dataset