Hi,
I want to setup ADFS between two domain Active Directory domain.
Client A enviroment:
Exchange server (SMTP Journal Archive), AD (user object and exchange object), Sharepoint farms, DA clients
Client B enviroment (hosting EV services):
Diff...
Hi All,
I having issue on doing query on the non-indexed Audit table as the number of records growth. The growht cause my SQL server run out of space and hang. Is there any chance i have alternative to query the audit?
Regards
BT
Yes i also think about putting the Audit DB to others server but the same problem will happen to the non-production server. As when my IT security run the query i will need a tempDB size > than AuditDB as the SQL server will load all the audit data a...
Hi Simon,
I do have SOP to rollover the audit database but my IT security need 6 mths data in the audit table, 7 years records in offsite and he will query the audit table on and off.
I really hope Symantec can help on this. As i understand from o...
Hi Andy,
Here is the SQL query.
select at.AuditID,at.AuditDate,at.info,u.UserName,c.CategoryName,sc.SubCategoryName,m.MachineName,s.Status,v.Vault
From dbo.AuditTrail at
Inner join dbo.Users u on at.UserID = u.UserID
Inner join dbo.Categories c on...