Search found 28 matches

by hudatolah
Thu Oct 03, 2019 8:19 am
Forum: ADDM TPL patterns
Topic: CMDB.Synch.Augment.ComputerSystem TPL
Replies: 0
Views: 1454

CMDB.Synch.Augment.ComputerSystem TPL

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...
by hudatolah
Thu Oct 03, 2019 8:18 am
Forum: ADDM TPL patterns
Topic: CMDB.Synch.Augment.Database TPL
Replies: 0
Views: 1398

CMDB.Synch.Augment.Database TPL

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 ...
by hudatolah
Thu Oct 03, 2019 8:14 am
Forum: ADDM TPL patterns
Topic: CMDB.Sync.Document TPL
Replies: 0
Views: 1459

CMDB.Sync.Document TPL

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...
by hudatolah
Thu Oct 03, 2019 6:50 am
Forum: ADDM TPL patterns
Topic: Oracle SQL query
Replies: 0
Views: 1378

Oracle SQL query

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...
by hudatolah
Mon Aug 19, 2019 7:54 pm
Forum: Automated Data Sources
Topic: SQL to relate databases to apps
Replies: 1
Views: 984

Re: SQL to relate databases to apps

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...
by hudatolah
Mon Aug 19, 2019 7:46 pm
Forum: Automated Data Sources
Topic: SQL to relate databases to apps
Replies: 1
Views: 984

SQL to relate databases to apps

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...
by hudatolah
Sat Jul 19, 2014 11:42 am
Forum: Episode 1
Topic: The next step
Replies: 0
Views: 1983

The next step

The Next Step.zip
(24.31 KiB) Downloaded 309 times
by hudatolah
Sat Feb 08, 2014 4:50 pm
Forum: Episode 1
Topic: January2014
Replies: 0
Views: 1918

January2014

The attachment Januraryw2.zip is no longer available
This is my stuff.
Januraryw2.zip
(23.15 KiB) Downloaded 339 times
by hudatolah
Fri Aug 02, 2013 8:46 am
Forum: Episode 1
Topic: ServiceMaster
Replies: 1
Views: 1078

Re: ServiceMaster

Report on 100K CIs in ADDM dataset
ADDM_100000K.zip
(3.88 MiB) Downloaded 248 times