Several times we need to read/export Logs from the NAMSYSLOG table in the Track-It! 20xx Database, how do I do this?

We are seeing lots of inconsistency with our ticket generation. Where can I get detailed logs ?

We have some users who, when sending an email to create a ticket, the ticket does not get created even though it is processed. How can I identify the root cause for it ?


 

The following steps shall assist you with reading and exporting the Logs out of the NAMSYSLOG table:

• Log into SQL Server Management Studio (SSMS) on the SQL Server where the Track-It! 20xx Database resides with a SysAdmin (SA) or equivalent account.
• Once logged in, Right-Click on the Track-It! 20xx Database from the "Databases" under "Object Explorer" on the Left. By default the Database is named "Trackit".
• This should open a New Query window in the middle of the Screen. Copy and Paste the following Query into this window:

select * from NAMSYSLOG order by 2 DESC

This query can be modified as per the requirement, example: If entries only related to the 'MAGICMAILPROCESS' EntityName are required, then the Query would look like:

select * from NAMSYSLOG where ENTITYNAME = 'MAGICMAILPROCESS'
order by 2 DESC

• Now either hit the F5 button on your keyboard, or use the "Execute" button to Run this Query.
• Once the query completes execution, might take some time depending upon the amount of Data in here, you should see the contents in the "Results" window.
• These results are sorted by Most Recent based on the "LASTMODIFIED" Date, using the SHIFT key you can multi select the No. of Rows as per the desired Date or as requested by the support team, the default selection being everything. Once selected, Right-Click and select "Save Results As".

• This will open a "Save Grid Results" window. Make sure to use the "Save as Type: CSV (*.csv)" option while saving the results.

This saved CSV file can be provided to support now, containing the exported results of the NAMSYSLOG table from the Track-It! 20xx Database.