David buric

Hello, thanks for reply. As I stated in my second comment, I have already figured it out. There was a syntax problem and it is now fixed. David

Hello I figured out how to do it: SELECT IPv4Address, VirtualMachine FROM IPv4Address JOIN VirtualMachine ON VirtualMachine.managementip_id = IPv4Address.id Next time ill dig a little bit deeper into the documentation. David

Hello community, I am facing an issue. I have this OQL command phrase: SELECT IPv4Address AS IP JOIN VirtualMachine AS VM ON VM.managementip_id = IP.id However I cannot use the second alias behind the JOIN clausule. If i try to filter IP.ip and VM.name, I receive an error, that VM is an unknow alias. That the only known alias is IP. Error: Invalid alias 'VM' for the column 'VM.name'. Availables aliases: 'IP' Funny enough, if I dont filter column VM.name, the phrase is ok, so the clausule where I...

Hello community, I am facing an issue. I have this OQL command phrase: SELECT IPv4Address AS IP JOIN VirtualMachine AS VM ON VM.managementip_id = IP.id However I cannot use the second alias behind the JOIN clausule. If i try to filter IP.ip and VM.name, I receive an error, that VM is an unknow alias. That the only known alias is IP. Error: Invalid alias 'VM' for the column 'VM.name'. Availables aliases: 'IP' Funny enough, if I dont filter column VM.name, the phrase is ok, so the clausule where I...

Update: If I change the query to http (unsecure) then the exec.php finishes successfully. But this is far from being an accepted solution. David

Hello team, We have been using the LDAP Collector for some time, but two days ago, it stopped working. If I try to manually use the exec.php I receive the following error: Error - Exception: Problem opening URL: https://docu.alef.com/itop//webservices/rest.php?version=1.0, Network file descriptor is not connected Im running this following version of php: PHP 7.2.22 (cli) (built: Aug 28 2019 09:29:33) ( NTS ) The collector is running on separate VM then the iTop itself. There is no firewall in between....

LDAP Collector - Network file descriptor is not connected