Search found 27 matches

by hudatolah
Thu Mar 05, 2020 11:44 am
Forum: Pentaho (AI)
Topic: How to connect with SSL
Replies: 0
Views: 1109

How to connect with SSL

First you need import a certificate that is associated with the root authority of the environment you're in. For example if that is BLACKHOLESURFER.COM then export that root cert from the Microsoft Management tool for Certificates (mmc) Look for a youtube video on how to do that, there is plenty of ...
by hudatolah
Thu Mar 05, 2020 11:20 am
Forum: ADDM TPL patterns
Topic: Read a directory
Replies: 1
Views: 826

Re: Read a directory

This also needs an active pattern for BMC.CORE:BMC_Document. As follows: tpl.1.12 module CDMB.Host_Document; from CMDB.Host_ComputerSystem import Host_ComputerSystem 2.2; // make sure to check the parent pattern for version //This version number must the same as the active Host_ComputerSystem patter...
by hudatolah
Thu Mar 05, 2020 10:53 am
Forum: ADDM TPL patterns
Topic: Read a directory
Replies: 1
Views: 826

Read a directory

tpl 1.14 module get_appfiledir_data; metadata tree_path := 'Custom','ComputerSystem hosted documents'; end metadata; pattern getJsonFileDir 1.5 ''' Pattern for reading Json formatted data files on hosts. This pattern reads all files in a directory where the extension is "json" ''' metadata origin :...
by hudatolah
Mon Dec 16, 2019 10:38 am
Forum: Reconciliation (CMDB)
Topic: How to get CMDB Reconciliation errors without Logs
Replies: 1
Views: 830

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

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

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

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

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

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

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