t_attribute - no ModifiedDate

[Svend Erik Nygaard]

The t_attribute table has no ModifiedDate.

Is there no way to see when an attribute was last updated?

I tried to see if I could find something in the audit log - but I only found the t_snapshot table and did not find any thing helping me there - and even if the audit log could help me, that would only work when the audit log is active.

I also checked to see if the object to which the attribute belongs gets its ModifiedDate updated when the attribute changes, but this seems not to be the case

[qwerty]

Connectors also have no update date. The database is not really consistent. The only thing you can do is to turn on auditing.

q.

[Svend Erik Nygaard]

The only thing you can do is to turn on auditing.

Can I find it in som audit table(s) in the DB (and where )?

[qwerty]

As you already mentioned, it's in t_snapshot. Probably you will need to foster the entries programmatically. Eg. renaming an attribute creates an entry with SnapshotName=t_attribute, Style=UPDATE and Notes being something like

{F4CB932F-F52E-45c6-AFB4-F8310ABE2624},b,Attribute,{031A0F62-A282-41c6-B2F2-C31763DB79C8},Class1,Class,

Where the first guid is that of the attribute and the 2nd that of the element.

q.

[Uffe]

Connectors also have no update date. The database is not really consistent. The only thing you can do is to turn on auditing.

It's not quite the only thing you can do.

You can also implement an attribute modified time as a tagged value. It won't be foolproof, but it is doable.

/Uffe

[Svend Erik Nygaard]

You can also implement an attribute modified time as a tagged value. It won't be foolproof, but it is doable.
/Uffe

Thanks, I also thought about adding an extra column with timestamp default='NOW' to the table(s) in the db schema.

But maybe the tag-solution would be better. Do you know of anyway to setup a default (='now') for a tag - or would I have to use an addin to set it to default (apart from a db-trigger)?

[Uffe]

AFAIK you can't default a date/time tag to 'now'. But you'd need an Add-In anyway to update the time OnNotifyContextItemModified.

As I say, this won't be a foolproof solution, and any changes that go through the API (like a script) won't be caught. For a more complete solution, a DB trigger must be the way to go. Or perhaps use an Add-In to create the tag to make sure that's done right, and then a trigger to update it.

Another weakness with the tag solution is of course that the tag itself can be modified or deleted by any user. So if you've got infosec requirements riding on this, it won't be good enough.


/Uffe