2/25/2023 9:45 AM | |
Joined: 10/29/2018 Last visit: 4/25/2024 Posts: 11 Rating: (1) |
Dear All, Please help me to build custom report of Audit Trail and also custom view of Audit trail View. I am confused about how to call DB in user query. My Audit Taril Db name is "AuditTrail" but in SSMC shows lots of DB with different suffix like "AuditTrail_WINCC_Audit_20230225063936". I want to see audit trail as per given time range like "DateTimeStart" and "DateTimeEnd" between this range. And I want to print this as well. Please suggest me with if there is any way. In dynamic table I write this following query for reading data from SQL DB. "Use [AuditTrai]l SELECT TOP 5000 ID,DateTime,ModificationID,TargetID, TargetName,WindowsUser,ApplicationUser,Reason,Legacy_DatabaseName,Legacy_TableName,Legacy_FieldName,Legacy_EventType,Legacy_EventItem FROM CL_TRAILDATA WHERE AuditType = 'AU' " but show some error like " [Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near ')' ." Can any one tell why this error coming and what is the problem in my code. Any suggestion will be appreciated. Thanks in advance. AttachmentPictures.zip (310 Downloads) |
Last edited by: H.Ahsan at: 02/26/2023 06:06:59 |
|
Follow us on