Hi all, Long time no see since v1.12.8, I'm starting a new project related to systems architecture and we are in need of a discovery tool and figured OA would do great, however I have an issue that I need to reconcile so I figured to ask here since I've missed a lot of changes since.
Our tool uses UUID to identify elements in a node like software or user accounts. OA would do great on the discovery piece and I could export the data from OA and substitute IDs with UUIDs but I think there's a benefit to actually be able to keep both systems in sync if we had UUID in OA beyond the Systems table. I can imagine two ways to accomplish this, 1. Replace the sequential/incremental ID field for UUIDs, although this approach would be a lot more work that would require upgrading to MySQL 8, which I don't know if OA supports it yet. or 2. add a new UUID column to the tables in the database which we can populate on a need to need basis. So I'm going with the obvious second option.
Questions 1. Would it be OK to add a new UUID column for those tables (I'm thinking Software, User, User Groups initially) that we would like to keep in sync. Would customizing the database schema that way break anything? 2. Could we call those custom fields out via OA API
_________________ Old OA Setup: 500 Windows 7 workstations & 200 Apple OSX with OA v1.5.2 on Windows Server 2003 and WAMP 2 New OA Setup: 100 Windows servers with OA 2.2 on Windows Server 2016 and WAMP 3
|