Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wsilage
Yak Posting Veteran
82 Posts |
 Posted - 2014-01-16 : 10:01:25
|
| I am not sure if I am in the right spot or not, but I have a user that wants me to report on a log file. I have never done that before. How does this work? This is what the sent me. Any help/guidance would be a huge help. Thanks.I will need a new SQL report that will report issues found in a log file created out of Impact. The log file will be created whenever the XRM file is run into Impact and tries to update a claim that has already been updated with XRM data from a prior run. The name of the log file will be xrm_load_clm_ccyymmddhhmmss.logThe path of this file is P\log file. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-01-16 : 12:20:16
|
quote:
Originally posted by wsilage
I am not sure if I am in the right spot or not, but I have a user that wants me to report on a log file. I have never done that before. How does this work? This is what the sent me. Any help/guidance would be a huge help. Thanks.I will need a new SQL report that will report issues found in a log file created out of Impact. The log file will be created whenever the XRM file is run into Impact and tries to update a claim that has already been updated with XRM data from a prior run. The name of the log file will be xrm_load_clm_ccyymmddhhmmss.logThe path of this file is P\log file.
The requirement is vague. You should get from the client the nature of the log file, and how to identify a record in the log file as being an error or not. Once you know that, you can perhaps import the log file into SQL Server and query for the records that match the error indications.Depending on the client requirements, you may not even need to involve SQL Server. Perhaps a tiny C# program that parses the log file is what you need. Hard to tell without getting more details on the requirements and the nature of the log file. |
 |
|
|
|
|
|
Reporting on a log file