When was a user enabled?

[porter78]

We have not enabled EV yet to automatically add users to be archived. The only way to add a user is to manually add them.

1 of our users has become enabled and we don't know how or when. Is there any way of finding out when the user was enabled?

Thank you in advance.

[dfwood]

One option would be to use the SQL queries from this Symantec KB article http://seer.entsupport.symantec.com/docs/278548.htm to view the archives creation date.

Dan

[porter78]

Thank you for such a quick response. I will try that now.

[porter78 · Accepted solution]

Unfortunately, ArchivePoint is a table that does not appear to exist in EV 2007. However, after lots of digging around and searching, I came up with the following code which has produced UTC dates which I believe are what I was after. Thank you for steering me in the right direction.

SELECT *
FROM [Archive]
INNER JOIN [Root]
ON [Archive].[RootIdentity] = [Root].[RootIdentity]
INNER JOIN [IndexVolume]
ON [Archive].[RootIdentity] = [IndexVolume].[RootIdentity]
where ArchiveName like '%name%'
GO