Search found 24 matches

by hudatolah
Mon Dec 16, 2019 10:38 am
Forum: Reconciliation (CMDB)
Topic: How to get CMDB Reconciliation errors without Logs
Replies: 1
Views: 57

Re: How to get CMDB Reconciliation errors without Logs

Run this query to create a report related to your data: select be.name as CIName, be.classid as ClassId, be.category as Category, be.type as Type, be.item as Item, be.model as Model, be.manufacturername as Manufacturer, a.JobName as JobName, case when a.Module_Name = 1 and be.MarkAsDelete = 1 then '...
by hudatolah
Mon Dec 09, 2019 11:01 am
Forum: Reconciliation (CMDB)
Topic: How to get CMDB Reconciliation errors without Logs
Replies: 1
Views: 57

How to get CMDB Reconciliation errors without Logs

First you should begin with a SQL query that gives you an idea on the size of the errors per job: SELECT count(*) as CI_Failure#, JobName case when Module_Name = 0 then 'Reconciliation' ELSE 'Normalization' END as JobType from CMDB_JobRunInfo group by JobName, Module_Name order by CI_Failure# DESC T...
by hudatolah
Mon Oct 21, 2019 12:40 pm
Forum: Automated Data Sources
Topic: Using NTLM with jTDS 1.3.1 driver and ADDM
Replies: 0
Views: 209

Using NTLM with jTDS 1.3.1 driver and ADDM

This is the out of the box driver that BMC ships with heir ADDM appliance.
The only thing to know about this driver is the Additional JDBC Parameters:

domain=us
useNTLMv2=true
authenticationScheme=NTLM

That's it.
by hudatolah
Fri Oct 11, 2019 12:52 pm
Forum: Automated Data Sources
Topic: Using Kerberos to authenticate with MSSQL from Linux
Replies: 0
Views: 141

Using Kerberos to authenticate with MSSQL from Linux

These are the exact steps to add Kerberos configuration to BMC's ADDM appliance version 11.2 . I have not tested any other version, but I would have to guess it would be the same for all given that the Linux image they're using is the same. First you will need to make sure that the MSSQL Server DB i...
by hudatolah
Mon Oct 07, 2019 11:22 am
Forum: Automated Data Sources
Topic: How to use Python with json to get job started
Replies: 0
Views: 535

How to use Python with json to get job started

import csv import json import requests url = "https://ADDMApplianceHost/api/v1.1/discovery/runs" targetRanges = [] with open("/usr/tideway/job_queue/tmssubnet.csv") as csvFile: foundRanges = [] next(rows) for row in rows: range2 = '' if row[1] == '32': range = row[0] elif row[1] == '31': ipParts = ...
by hudatolah
Thu Oct 03, 2019 9:07 am
Forum: ADDM TPL patterns
Topic: MSSQL Get SQL TPL
Replies: 0
Views: 224

MSSQL Get SQL TPL

tpl 1.14 module AssetInfoFromSQL_MSSQL; metadata origin := "BlackholeSurfer"; tree_path := 'BlackholeSurfer','Database,'MSSQL'; end metadata from SearchFunctions import SearchFunctions 1.5; definitions MSSQLDetailsSerialNumber 2.0 """ Relational Database Queries for MSSQL """ type := sql_discovery; ...
by hudatolah
Thu Oct 03, 2019 8:19 am
Forum: ADDM TPL patterns
Topic: CMDB.Synch.Augment.ComputerSystem TPL
Replies: 0
Views: 109

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: 106

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: 141

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: 94

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...