This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Clarification on some of the database items

Hi everyone,
Recently we've been working on setting up some connectors to other systems like our CMDB and Splunk, and I've been trying to manually piece together some of the specific meanings of the database items.

For instance, I've managed to figure out most of the "IVT_MA_DRIVE_ASSIGN.IDA_DRIVE_TYPE" and "IVT_MA_DRIVE_ASSIGN.IDA_DRIVE_STATE" value meanings, but then I run into things like IDA_CREATION_DATE and IDA_MODIFY_DATE. Is the creation date when the record was created in the DB, or on the client side? Does it correspond to the record for the whole machine, or just for that drive ID? What causes the modify date to update?

Also, in the VW_SGD_MAS table, what do "SGD_JOIN_STATE" and "SGD_ACCOUNT_STATE" refer to?

I was rather hoping there would be documentation on this somewhere online to make building connectors easier, but I've yet to find anything.
If you have any experience building connectors with SEC, or if there is in fact documentation on this, please let me know where I should start looking for this.

Thank you,
Eric Valenzuela



This thread was automatically locked due to age.