param.local.xml

<?xml version="1.0" encoding="UTF-8"?>
<!-- Default values for parameters. Do NOT alter this file, copy its content to conf/params.local.xml and edit it instead -->
<parameters>
	<!-- OCS Database -->
	<sql_host>XXXXXX</sql_host>
	<sql_database>XXXXXX;charset=UTF8</sql_database>
	<sql_login>root</sql_login>
	<sql_password>XXXXXX</sql_password>

	<!-- iTop Application -->
	<default_org_id>Demo</default_org_id>
	<default_status>production</default_status>
	<PCCollection>yes</PCCollection>
	<ServerCollection>yes</ServerCollection>
	<VMCollection>yes</VMCollection>

	<!-- TeemIp options -->
	<collect_ips>yes</collect_ips>
	<default_ip_status>allocated</default_ip_status>
	<manage_ipv6>no</manage_ipv6>
	<default_view_name></default_view_name>

	<!-- Data synchro parameters -->
	<json_placeholders type="hash">
		<prefix>OCSng</prefix>
		<full_load_interval>604800</full_load_interval><!-- 7 days (in seconds): 7*24*60*60 -->
		<synchro_status>production</synchro_status>
		<delete_policy>update</delete_policy>l
		<delete_policy_update>status:obsolete</delete_policy_update>
		<delete_policy_retention>0</delete_policy_retention>
	</json_placeholders>

	<!-- Brand -->
	<OCSBrandCollector_query>SELECT DISTINCT SMANUFACTURER as primary_key,
		SMANUFACTURER as name
		FROM bios</OCSBrandCollector_query>

	<!-- OSFamily -->
	<OCSOSFamilyCollector_query>SELECT DISTINCT OSNAME as primary_key,
		OSNAME as name
		FROM hardware</OCSOSFamilyCollector_query>

	<!-- OSVersion -->
	<OCSOSVersionCollector_query>SELECT DISTINCT CONCAT(OSNAME,OSVERSION) as primary_key,
		OSNAME as osfamily_id,
		OSVERSION as name
		FROM hardware</OCSOSVersionCollector_query>

	<!-- Model for Servers -->
	<OCSServerModelCollector_query>SELECT DISTINCT CONCAT(SMANUFACTURER,SMODEL) AS primary_key,
		SMANUFACTURER as brand_id,
		SMODEL as name,
		'Server' As type
		FROM bios
			WHERE TYPE COLLATE utf8_general_ci NOT IN ('Notebook','Laptop')
			AND SMANUFACTURER COLLATE utf8_general_ci NOT LIKE 'VMware%'</OCSServerModelCollector_query>

	<!-- Model for PC -->
	<OCSPCModelCollector_query>SELECT DISTINCT CONCAT(SMANUFACTURER,SMODEL) AS primary_key,
		SMANUFACTURER as brand_id,
		SMODEL as name,
		'PC' As type
		FROM bios
			WHERE TYPE COLLATE utf8_general_ci IN ('Notebook','Laptop')
			AND SMANUFACTURER NOT LIKE 'VMware%'</OCSPCModelCollector_query>

	<!-- PC - TeemIp NOT installed -->
	<OCSPCCollector_query>SELECT b.SSN as primary_key,
		h.ID as tickets_list,
		h.NAME as name,
		h.OSNAME as osfamily_id,
		h.OSVERSION as osversion_id,
		h.PROCESSORT as cpu,
		h.MEMORY as ram,
		b.SMANUFACTURER as brand_id,
		b.SMODEL as model_id,
		b.SSN as serialnumber,
		'$default_status$' as status,
		'$default_org_id$' as org_id
		FROM hardware AS h JOIN bios AS b ON h.id=b.hardware_id
			WHERE b.TYPE COLLATE utf8_general_ci IN ('Notebook','Laptop')
			AND b.SMANUFACTURER COLLATE utf8_general_ci NOT LIKE 'VMware%'</OCSPCCollector_query>

	<!-- PhysicalInterface for PC - TeemIp NOT installed -->
	<OCSPCPhysicalInterfaceCollector_query>SELECT n.ID as primary_key,
		n.DESCRIPTION as name,
		IF(n.SPEED REGEXP '^[0-9]+ ', LEFT(n.SPEED, LOCATE(' ', n.SPEED)), n.SPEED) as speed,
		n.MACADDR as macaddress,
		n.IPADDRESS as ipaddress,
		n.IPMASK as ipmask,
		n.IPGATEWAY as ipgateway,
		h.NAME as connectableci_id
		FROM networks AS n JOIN hardware AS h ON n.hardware_id=h.id JOIN bios AS b ON h.id=b.hardware_id
			WHERE b.SMANUFACTURER COLLATE utf8_general_ci NOT LIKE 'VMware%'
			AND b.TYPE COLLATE utf8_general_ci IN ('Notebook','Laptop')</OCSPCPhysicalInterfaceCollector_query>

	<!-- PC - TeemIp installed -->
	<OCSPCTeemIpCollector_query>SELECT b.SSN as primary_key,
		h.ID as tickets_list,
		h.NAME as name,
		h.OSNAME as osfamily_id,
		h.OSVERSION as osversion_id,
		h.PROCESSORT as cpu,
		h.MEMORY as ram,
		h.IPADDR as ipaddress_id,
		b.SMANUFACTURER as brand_id,
		b.SMODEL as model_id,
		b.SSN as serialnumber,
		'$default_status$' as status,
		'$default_org_id$' as org_id
		FROM hardware AS h JOIN bios AS b ON h.id=b.hardware_id
			WHERE b.TYPE COLLATE utf8_general_ci IN ('Notebook','Laptop')
			AND b.SMANUFACTURER COLLATE utf8_general_ci NOT LIKE 'VMware%'</OCSPCTeemIpCollector_query>

	<!-- PhysicalInterface for PC - TeemIp installed -->
	<OCSPCPhysicalInterfaceTeemIpCollector_query>SELECT n.ID as primary_key,
		n.DESCRIPTION as name,
		IF(n.SPEED REGEXP '^[0-9]+ ', LEFT(n.SPEED, LOCATE(' ', n.SPEED)), n.SPEED) as speed,
		n.MACADDR as macaddress,
		h.NAME as connectableci_id
		FROM networks AS n JOIN hardware AS h ON n.hardware_id=h.id JOIN bios AS b ON h.id=b.hardware_id
			WHERE b.SMANUFACTURER COLLATE utf8_general_ci NOT LIKE 'VMware%'
			AND b.TYPE COLLATE utf8_general_ci IN ('Notebook','Laptop')</OCSPCPhysicalInterfaceTeemIpCollector_query>

	<!-- Server - TeemIp NOT installed -->
	<OCSServerCollector_query>SELECT b.SSN as primary_key,
		h.ID as tickets_list,
		h.NAME as name,
		h.OSNAME as osfamily_id,
		h.OSVERSION as osversion_id,
		h.PROCESSORT as cpu,
		h.MEMORY as ram,
		h.IPADDR as managementip,
		b.SMANUFACTURER as brand_id,
		b.SMODEL as model_id,
		b.SSN as serialnumber,
		'$default_status$' as status,
		'$default_org_id$' as org_id
		FROM hardware AS h JOIN bios AS b ON h.id=b.hardware_id
			WHERE b.TYPE COLLATE utf8_general_ci NOT IN ('Notebook','Laptop')
			AND b.SMANUFACTURER COLLATE utf8_general_ci NOT LIKE 'VMware%'</OCSServerCollector_query>

	<!-- PhysicalInterface for Server - TeemIp NOT installed -->
	<OCSServerPhysicalInterfaceCollector_query>SELECT n.ID as primary_key,
		n.DESCRIPTION as name,
		IF(n.SPEED REGEXP '^[0-9]+ ', LEFT(n.SPEED, LOCATE(' ', n.SPEED)), n.SPEED) as speed,
		n.MACADDR as macaddress,
		n.IPADDRESS as ipaddress,
		n.IPMASK as ipmask,
		n.IPGATEWAY as ipgateway,
		h.NAME as connectableci_id
		FROM networks AS n JOIN hardware AS h ON n.hardware_id=h.id JOIN bios AS b ON h.id=b.hardware_id
			WHERE b.SMANUFACTURER COLLATE utf8_general_ci NOT LIKE 'VMware%'
			AND b.TYPE COLLATE utf8_general_ci NOT IN ('Notebook','Laptop')</OCSServerPhysicalInterfaceCollector_query>

	<!-- Server - TeemIp installed -->
	<OCSServerTeemIpCollector_query>SELECT b.SSN as primary_key,
		h.ID as tickets_list,
		h.NAME as name,
		h.OSNAME as osfamily_id,
		h.OSVERSION as osversion_id,
		h.PROCESSORT as cpu,
		h.MEMORY as ram,
		h.IPADDR as managementip_id,
		b.SMANUFACTURER as brand_id,
		b.SMODEL as model_id,
		b.SSN as serialnumber,
		'$default_status$' as status,
		'$default_org_id$' as org_id
		FROM hardware AS h JOIN bios AS b ON h.id=b.hardware_id
			WHERE b.TYPE COLLATE utf8_general_ci NOT IN ('Notebook','Laptop')
			AND b.SMANUFACTURER COLLATE utf8_general_ci NOT LIKE 'VMware%'</OCSServerTeemIpCollector_query>

	<!-- PhysicalInterface for Server - TeemIp installed -->
	<OCSServerPhysicalInterfaceTeemIpCollector_query>SELECT n.ID as primary_key,
		n.DESCRIPTION as name,
		IF(n.SPEED REGEXP '^[0-9]+ ', LEFT(n.SPEED, LOCATE(' ', n.SPEED)), n.SPEED) as speed,
		MACADDR as macaddress,
		h.NAME as connectableci_id
		FROM networks AS n JOIN hardware AS h ON n.hardware_id=h.id JOIN bios AS b ON h.id=b.hardware_id
			WHERE b.SMANUFACTURER COLLATE utf8_general_ci NOT LIKE 'VMware%'
			AND b.TYPE COLLATE utf8_general_ci NOT IN ('Notebook','Laptop')</OCSServerPhysicalInterfaceTeemIpCollector_query>

	<!-- VirtualMachine - TeemIp NOT installed -->
	<OCSVirtualMachineCollector_query>SELECT h.ID as primary_key,
		h.ID as	tickets_list,
		h.NAME as name,
		h.OSNAME as osfamily_id,
		h.OSVERSION as osversion_id,
		h.PROCESSORT as cpu,
		h.MEMORY as ram,
		h.IPADDR as managementip,
		'$default_status$' as status,
		'$default_org_id$' as org_id
		FROM hardware AS h JOIN bios AS b ON h.id=b.hardware_id
			WHERE b.SMANUFACTURER COLLATE utf8_general_ci LIKE 'VMware%'</OCSVirtualMachineCollector_query>

	<!-- LogicalInterface for VirtualMachine - TeemIp NOT installed -->
	<OCSLogicalInterfaceCollector_query>SELECT n.ID as primary_key,
		n.DESCRIPTION as name,
		IF(n.SPEED REGEXP '^[0-9]+ ', LEFT(n.SPEED, LOCATE(' ', n.SPEED)), n.SPEED) as speed,
		n.MACADDR as macaddress,
		n.IPADDRESS as ipaddress,
		n.IPMASK as ipmask,
		n.IPGATEWAY as ipgateway,
		h.NAME as virtualmachine_id
		FROM networks AS n JOIN hardware AS h ON n.hardware_id=h.id JOIN bios AS b ON h.id=b.hardware_id
			WHERE b.SMANUFACTURER COLLATE utf8_general_ci LIKE 'VMware%'</OCSLogicalInterfaceCollector_query>

	<!-- VirtualMachine - TeemIp installed -->
	<OCSVirtualMachineTeemIpCollector_query>SELECT h.ID as primary_key,
		h.ID as	tickets_list,
		h.NAME as name,
		h.OSNAME as osfamily_id,
		h.OSVERSION as osversion_id,
		h.PROCESSORT as cpu,
		h.MEMORY as ram,
		h.IPADDR as managementip_id,
		'$default_status$' as status,
		'$default_org_id$' as org_id
		FROM hardware AS h JOIN bios AS b ON h.id=b.hardware_id
			WHERE b.SMANUFACTURER COLLATE utf8_general_ci LIKE 'VMware%'</OCSVirtualMachineTeemIpCollector_query>

	<!-- LogicalInterface for VirtualMachine - TeemIp installed -->
	<OCSLogicalInterfaceTeemIpCollector_query>SELECT n.ID as primary_key,
		n.DESCRIPTION as name,
		IF(n.SPEED REGEXP '^[0-9]+ ', LEFT(n.SPEED, LOCATE(' ', n.SPEED)), n.SPEED) as speed,
		n.MACADDR as macaddress,
		h.NAME as virtualmachine_id
		FROM networks AS n JOIN hardware AS h ON n.hardware_id=h.id JOIN bios AS b ON h.id=b.hardware_id
			WHERE b.SMANUFACTURER COLLATE utf8_general_ci LIKE 'VMware%'</OCSLogicalInterfaceTeemIpCollector_query>

	<!-- IPv4Address - TeemIp installed -->
	<OCSIPv4AddressCollector_query>SELECT n.ID as primary_key,
		'$default_org_id$' as org_id,
		n.IPADDRESS as ip,
		'$default_ip_status$' as status,
		h.DNS as short_name
		FROM networks AS n JOIN hardware AS h ON n.hardware_id=h.id JOIN bios AS b ON h.id=b.hardware_id
			WHERE IF(n.IPADDRESS REGEXP '^[:]', false, true)</OCSIPv4AddressCollector_query>

	<!-- IPv4Address - TeemIp with Zone mgmt installed -->
	<OCSIPv4AddressWithZoneCollector_query>SELECT n.ID as primary_key,
		'$default_org_id$' as org_id,
		n.IPADDRESS as ip,
		'$default_ip_status$' as status,
		h.DNS as short_name,
		'$default_view_name$' as view_id
		FROM networks AS n JOIN hardware AS h ON n.hardware_id=h.id JOIN bios AS b ON h.id=b.hardware_id
		WHERE IF(n.IPADDRESS REGEXP '^[:]', false, true)</OCSIPv4AddressWithZoneCollector_query>

	<!-- IPv6Address - TeemIp installed -->
	<OCSIPv6AddressCollector_query>SELECT n.ID as primary_key,
		'$default_org_id$' as org_id,
		n.IPADDRESS as ip,
		'$default_ip_status$' as status,
		h.DNS as short_name
		FROM networks AS n JOIN hardware AS h ON n.hardware_id=h.id JOIN bios AS b ON h.id=b.hardware_id
			WHERE IF(n.IPADDRESS REGEXP '^[:]', true, false)</OCSIPv6AddressCollector_query>

	<!-- IPv6Address - TeemIp with Zone Mgmt installed -->
	<OCSIPv6AddressWithZoneCollector_query>SELECT n.ID as primary_key,
		'$default_org_id$' as org_id,
		n.IPADDRESS as ip,
		'$default_ip_status$' as status,
		h.DNS as short_name,
		'$default_view_name$' as view_id
		FROM networks AS n JOIN hardware AS h ON n.hardware_id=h.id JOIN bios AS b ON h.id=b.hardware_id
		WHERE IF(n.IPADDRESS REGEXP '^[:]', true, false)</OCSIPv6AddressWithZoneCollector_query>

	<!-- lnkIPInterfaceToIPAddress - TeemIp installed -->
	<OCSlnkIPInterfaceToIPAddressCollector_query>SELECT n.ID as primary_key,
		n.MACADDR as ipinterface_id,
		n.IPADDRESS as ipaddress_id
		FROM networks AS n</OCSlnkIPInterfaceToIPAddressCollector_query>

</parameters>