Need a database view to be used in ACC policies as CI Type

[tschneider]

Hi,

I've duplicateed the database view [sn_itmon_http_entrypoint] to a new one which includes all tcp entrypoints and not just the http(s) ones. I would like to use that view to filter CIs in an ACC policy.  The database view configuration is identical to the original one, just that it uses the tcp tables instead of the http ones:

But I'm not able to use this in the ACC policy to select CIs. Only the original view is listed:

I guess, I'm missing something? 

Thanks for your help

Thorsten

[Niklas Peterson]

Hi,

Check the dictionary for the "Monitored CI type" field. In my instance the attribute base_table is set

to base_table=cmdb_ci

This will restrict the field to only include CMDB tables. You may have something else.

Regards,
Niklas

[tschneider]

Thanks for your suggestion. 

It is configured the same for me. Since the view sn_itmon_http_entrypoints is listed I guess it must be a setting on the database view. Or there is something else that has to be configured to make a view or table available in the Monitored CI type list. 

I had also tried to use the Monitored CI Script with the following query instead:

    var monitoredCis = new GlideRecord('sn_itmon_http_entrypoint');

    monitoredCis.addQuery('ip_address', '!=', '');

    answer = monitoredCis;

but it fails on publishing

[Niklas Peterson · Accepted solution]

Hi.

That script failed on publishing for me as well. But this one seemed to get published.

 (function getMonitoredCiType(){
 var monitoredCis = new GlideRecord('sn_itmon_http_entrypoint');
    monitoredCis.addQuery('ip_address', '!=', '');
	monitoredCis.query();
	return monitoredCis;
  
 })();

Not sure it works though, that query should return dbview records and I assume you would like the CI records from those dbview records?

Regards,
Niklas

[Niklas Peterson]

Hello again,

The database view is added to the list of tables by a client script called addDBView. You may be able to modify that to add your own database view.

Regards,
Niklas