legal contact
 

asset_lookup ('al')

For the asset lookup to work, you first need to create the appropriate CSV files as an export from your CMDB.

Find below the CSV files with the CSV format definitions.

asset_lookup_by_str.csv:

key,ip,mac,nt_host,dns,owner,priority,lat,long,city,country,bunit,category,pci_domain,is_expected,should_timesync,

should_update,requires_av,asset_tag,asset_id

asset_lookup_by_cidr.csv:

key,ip,mac,nt_host,dns,owner,priority,lat,long,city,country,bunit,category,pci_domain,is_expected,should_timesync,

should_update,requires_av,asset_tag,asset_id

 

lookup asset_lookup_by_str key as host OUTPUTNEW asset_id as host_asset_id,ip as host_ip,mac as host_mac,nt_host as host_nt_host,dns as host_dns,owner as host_owner,priority as host_priority,lat as host_lat,long as host_long,city as host_city,country as host_country,bunit as host_bunit,category as host_category,pci_domain as host_pci_domain,is_expected as host_is_expected,should_timesync as host_should_timesync,should_update as host_should_update,requires_av as host_requires_av,asset_tag as host_asset_tag |

lookup asset_lookup_by_cidr key as host OUTPUTNEW asset_id as host_asset_id,ip as host_ip,mac as host_mac,nt_host as host_nt_host,dns as host_dns,owner as host_owner,priority as host_priority,lat as host_lat,long as host_long,city as host_city,country as host_country,bunit as host_bunit,category as host_category,pci_domain as host_pci_domain,is_expected as host_is_expected,should_timesync as host_should_timesync,should_update as host_should_update,requires_av as host_requires_av,asset_tag as host_asset_tag |

lookup asset_lookup_by_str key as orig_host OUTPUTNEW asset_id as orig_host_asset_id,ip as orig_host,mac as orig_host_mac,nt_host as orig_host_nt_host,dns as orig_host_dns,owner as orig_host_owner,priority as orig_host_priority,lat as orig_host_lat,long as orig_host_long,city as orig_host_city,country as orig_host_country,bunit as orig_host_bunit,category as orig_host_category,pci_domain as orig_host_pci_domain,is_expected as orig_host_is_expected,should_timesync as orig_host_should_timesync,should_update as orig_host_should_update,requires_av as orig_host_requires_av,asset_tag as orig_host_asset_tag |

lookup asset_lookup_by_cidr key as orig_host OUTPUTNEW asset_id as orig_host_asset_id,ip as orig_host,mac as orig_host_mac,nt_host as orig_host_nt_host,dns as orig_host_dns,owner as orig_host_owner,priority as orig_host_priority,lat as orig_host_lat,long as orig_host_long,city as orig_host_city,country as orig_host_country,bunit as orig_host_bunit,category as orig_host_category,pci_domain as orig_host_pci_domain,is_expected as orig_host_is_expected,should_timesync as orig_host_should_timesync,should_update as orig_host_should_update,requires_av as orig_host_requires_av,asset_tag as orig_host_asset_tag |

lookup asset_lookup_by_str key as src OUTPUTNEW asset_id as src_asset_id,ip as src_ip,mac as src_mac,nt_host as src_nt_host,dns as src_dns,owner as src_owner,priority as src_priority,lat as src_lat,long as src_long,city as src_city,country as src_country,bunit as src_bunit,category as src_category,pci_domain as src_pci_domain,is_expected as src_is_expected,should_timesync as src_should_timesync,should_update as src_should_update,requires_av as src_requires_av,asset_tag as src_asset_tag |

lookup asset_lookup_by_cidr key as src OUTPUTNEW asset_id as src_asset_id,ip as src_ip,mac as src_mac,nt_host as src_nt_host,dns as src_dns,owner as src_owner,priority as src_priority,lat as src_lat,long as src_long,city as src_city,country as src_country,bunit as src_bunit,category as src_category,pci_domain as src_pci_domain,is_expected as src_is_expected,should_timesync as src_should_timesync,should_update as src_should_update,requires_av as src_requires_av,asset_tag as src_asset_tag |

lookup asset_lookup_by_str key as dest OUTPUTNEW asset_id as dest_asset_id,ip as dest_ip,mac as dest_mac,nt_host as dest_nt_host,dns as dest_dns,owner as dest_owner,priority as dest_priority,lat as dest_lat,long as dest_long,city as dest_city,country as dest_country,bunit as dest_bunit,category as dest_category,pci_domain as dest_pci_domain,is_expected as dest_is_expected,should_timesync as dest_should_timesync,should_update as dest_should_update,requires_av as dest_requires_av,asset_tag as dest_asset_tag |

lookup asset_lookup_by_cidr key as dest OUTPUTNEW asset_id as dest_asset_id,ip as dest_ip,mac as dest_mac,nt_host as dest_nt_host,dns as dest_dns,owner as dest_owner,priority as dest_priority,lat as dest_lat,long as dest_long,city as dest_city,country as dest_country,bunit as dest_bunit,category as dest_category,pci_domain as dest_pci_domain,is_expected as dest_is_expected,should_timesync as dest_should_timesync,should_update as dest_should_update,requires_av as dest_requires_av,asset_tag as dest_asset_tag |

lookup asset_lookup_by_str key as dvc OUTPUTNEW asset_id as dvc_asset_id,ip as dvc_ip,mac as dvc_mac,nt_host as dvc_nt_host,dns as dvc_dns,owner as dvc_owner,priority as dvc_priority,lat as dvc_lat,long as dvc_long,city as dvc_city,country as dvc_country,bunit as dvc_bunit,category as dvc_category,pci_domain as dvc_pci_domain,is_expected as dvc_is_expected,should_timesync as dvc_should_timesync,should_update as dvc_should_update,requires_av as dvc_requires_av,asset_tag as dvc_asset_tag |

lookup asset_lookup_by_cidr key as dvc OUTPUTNEW asset_id as dvc_asset_id,ip as dvc_ip,mac as dvc_mac,nt_host as dvc_nt_host,dns as dvc_dns,owner as dvc_owner,priority as dvc_priority,lat as dvc_lat,long as dvc_long,city as dvc_city,country as dvc_country,bunit as dvc_bunit,category as dvc_category,pci_domain as dvc_pci_domain,is_expected as dvc_is_expected,should_timesync as dvc_should_timesync,should_update as dvc_should_update,requires_av as dvc_requires_av,asset_tag as dvc_asset_tag iseval = 0