Lars Scheibling

Management ip vs Management IP

Hi, Sorry, OQL, that's what I meant. HID is a custom attribute for our switches/ap's, hardware ID, to uniquely identify them.. The only thing I need from the database is a select statement, I will not be inserting directly with the function, I only need to get the highest HID from the database to generate the next one. Thanks for your help guys, I have more of an idea of where to look now! Regards, Lars

Hi guys, Thanks for the answers, I'll look into CMDBSource/Query. As far as I've seen, the query method uses the OMDB-format, which doesn't support eg. ORDER BY statements. Basically what I want to do is to auto-generate a new HID by looking at the list of current HID, taking the largest number and adding one. I'll look closer at the code in CMDBSource today to see if I can find that. The insertion of the HID into newly created items I've got covered, it's only the reading out of the database that's...

Hi guys, I'm working on modifying one of our extensions, and I'm kind of stuck again. I'd need to run a query like SELECT TOP 1 FROM hid WHERE type = switch ORDER BY hid ASC to automatically assign a HID (supposed to be assigned from ex. 2000 - 2500 sequentially) to a network device. Since the ORDER BY is not implemented in the ODB-system, is there a way to run a standard MYSQL-query from the code for this? Or does anyone have any good ideas about how to do this instead? Regards, Lars S

I agree with your code! I found the issue, the path for Lists.xml needed to be absolute, changed that to: 'spWsdl' => APPROOT.'env-production/lsc-sharepointapi/Lists.xml', That worked perfectly. Now just for adding the link prefixes so the links to the sharepoint files work and I'm ready for my vacation =) Maybe I'll throw in a german translation as well

Edit: Just saw your post above, disregard what I posted below, I'm checking to make sure that all of that's named accordingly Edit 2: Okay, now it loads the file but gives me a 500-error if I provide an ID, strangely no error if I don't provide one. I'll look into this a bit in the coming days, but happy news is the code works with below modification for now! I'll be back after my vacation in a couple of weeks to pour it over again to look for the bug :-) That is wonderful, thank you very much! It...

Edit: Just saw your post above, disregard what I posted below, I'm checking to make sure that all of that's named accordingly Edit 2: Okay, now it loads the file but gives me a 500-error if I provide an ID, strangely no error if I don't provide one. I'll look into this a bit in the coming days, but happy news is the code works with below modification for now! That is wonderful, thank you very much! It all works brilliantly, except for this line $sEndpoint = utils::GetAbsoluteUrlAppRoot() . 'pages/exec.php?exec_module='...

Edit: Just saw your post above, disregard what I posted below, I'm checking to make sure that all of that's named accordingly That is wonderful, thank you very much! It all works brilliantly, except for this line $sEndpoint = utils::GetAbsoluteUrlAppRoot() . 'pages/exec.php?exec_module=' . self::MODULE_CODE . '&exec_page=main.lsc-sharepointapi.php&id=' . $oObject->GetKey(); It doesn't seem like that's working properly, if I put the direct link to the file directly like this: $oPage->AddAjaxTab(Dict::S('Class:SharepointAPI/Attribute:SharepointTab'),...