<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: how to calculate duration for completed and interview and incomplete interview ? in Splunk Search</title>
    <link>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151439#M42439</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;

&lt;P&gt;Did you receive my sample log file, &lt;/P&gt;

&lt;P&gt;Thanks &amp;amp; Regards&lt;/P&gt;</description>
    <pubDate>Tue, 16 Dec 2014 14:08:49 GMT</pubDate>
    <dc:creator>Laya123</dc:creator>
    <dc:date>2014-12-16T14:08:49Z</dc:date>
    <item>
      <title>how to calculate duration for completed and interview and incomplete interview ?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151433#M42433</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;

&lt;P&gt;First I will give brief introduction about my company and my role&lt;/P&gt;

&lt;P&gt;I am working in a market research company, in my company we will design a survey and we will take the interview from different respondents from online. For designing survey we are using IBM application i.e Dimensions, using dimensions application we will design application and put in live for interview. here my role is to do the analysis of logs using splunk. we have different log files IIS logs and IBM logs, in IBM logs we have different types of logs are there IVW logs, ISE logs, ACT logs etc., based on these logs I have to develop the reports using splunk.&lt;/P&gt;

&lt;P&gt;here is my query; &lt;/P&gt;

&lt;P&gt;My query is, after putting the survey in live the respondents starts to take the interview, in that some respondents wont complete all the interview due to some reasons, some respondents will complete all the interview. Now i have to generate a report what is time duration they have take for interview by completed interviews Vs Incomplete interviews, &lt;/P&gt;

&lt;P&gt;Please help me in this&lt;/P&gt;

&lt;P&gt;Thanks &amp;amp; Regards&lt;BR /&gt;
Laya&lt;/P&gt;</description>
      <pubDate>Tue, 16 Dec 2014 03:07:56 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151433#M42433</guid>
      <dc:creator>Laya123</dc:creator>
      <dc:date>2014-12-16T03:07:56Z</dc:date>
    </item>
    <item>
      <title>Re: how to calculate duration for completed and interview and incomplete interview ?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151434#M42434</link>
      <description>&lt;P&gt;Since most of us in the Splunk community do not normally work with all of these logs, we need more information. Can you give a sample of the &lt;EM&gt;relevant&lt;/EM&gt; logs that you would use to determine how long a person took for the interviews. And tell us how you determine that an interview is complete or incomplete...&lt;/P&gt;</description>
      <pubDate>Tue, 16 Dec 2014 05:07:17 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151434#M42434</guid>
      <dc:creator>lguinn2</dc:creator>
      <dc:date>2014-12-16T05:07:17Z</dc:date>
    </item>
    <item>
      <title>Re: how to calculate duration for completed and interview and incomplete interview ?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151435#M42435</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;

&lt;P&gt;Thank you for your immediate response,&lt;/P&gt;

&lt;P&gt;Herewith, I am attaching sample log file.&lt;/P&gt;

&lt;P&gt;'Complete' means respondent who finished his survey completely in the log we have status = 'completed'&lt;/P&gt;

&lt;P&gt;'Incomplete' means respondent who not completed his survey (middle drop)&lt;/P&gt;

&lt;P&gt;Please help me to do this query&lt;/P&gt;

&lt;P&gt;Thanks &amp;amp; Regards&lt;/P&gt;</description>
      <pubDate>Tue, 16 Dec 2014 08:40:36 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151435#M42435</guid>
      <dc:creator>Laya123</dc:creator>
      <dc:date>2014-12-16T08:40:36Z</dc:date>
    </item>
    <item>
      <title>Re: how to calculate duration for completed and interview and incomplete interview ?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151436#M42436</link>
      <description>&lt;P&gt;Sorry I am unable to attach the file&lt;/P&gt;</description>
      <pubDate>Tue, 16 Dec 2014 08:47:47 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151436#M42436</guid>
      <dc:creator>Laya123</dc:creator>
      <dc:date>2014-12-16T08:47:47Z</dc:date>
    </item>
    <item>
      <title>Re: how to calculate duration for completed and interview and incomplete interview ?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151437#M42437</link>
      <description>&lt;P&gt;simply copy / paste some log lines here which are relevant to solve this question&lt;/P&gt;</description>
      <pubDate>Tue, 16 Dec 2014 09:38:26 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151437#M42437</guid>
      <dc:creator>MuS</dc:creator>
      <dc:date>2014-12-16T09:38:26Z</dc:date>
    </item>
    <item>
      <title>Re: how to calculate duration for completed and interview and incomplete interview ?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151438#M42438</link>
      <description>&lt;P&gt;Than you, &lt;/P&gt;

&lt;P&gt;Please find enclosed log file&lt;BR /&gt;
0,VER,3.0&lt;BR /&gt;
0,HISTORY,Previous LogFile: E:\Program Files\IBM\SPSS\DataCollection\6\Interviewer Server Administration\Logs\IVWA52E.tmp&lt;BR /&gt;
0,FORMAT,',',RecordSize:long,DateTime:Date,Log Id:long,Log Levels:long,Log group:string,Log scope:string,Log Entry:string&lt;BR /&gt;
0,CONFIG,300,4096,-1,1&lt;BR /&gt;
191,20141216 02:18:24.098,4,16,IVW,555737 - 0x1e60,-P -R -Imlatvq3zok6exedrlytfdpkxs1vqgaaa DEBUG - CSessionEngine::PostInterviewEventImpl, .\SessionEngine.cpp, 3095, Getting running interview&lt;BR /&gt;
233,20141216 02:18:24.098,4,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_c24ad8f4825b477981ef3118433af914 -Imlatvq3zok6exedrlytfdpkxs1vqgaaa DEBUG - CSessionEngine::PostInterviewEventImpl, .\SessionEngine.cpp, 3135, Posting interview page&lt;BR /&gt;
232,20141216 02:18:24.098,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_c24ad8f4825b477981ef3118433af914 -Imlatvq3zok6exedrlytfdpkxs1vqgaaa DEBUG - CRunningInterview::LoadPostInput, .\RunningInterview.cpp, 2222, Parsing XML player input&lt;BR /&gt;
234,20141216 02:18:24.098,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_c24ad8f4825b477981ef3118433af914 -Imlatvq3zok6exedrlytfdpkxs1vqgaaa DEBUG - CRunningInterview::ExecuteScript, .\RunningInterview.cpp, 2740, Executing interview script&lt;BR /&gt;
161,20141216 02:18:24.098,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_c24ad8f4825b477981ef3118433af914 -Imlatvq3zok6exedrlytfdpkxs1vqgaaa Question 'SCR1' was asked&lt;BR /&gt;
160,20141216 02:18:24.114,1,16,IVW,560727 - 0x418,-PSDUSSTL -R1_10014763243 -I5vowcb1obpletm136x3sfy6c3ptqaaaa Missing label. Unable to get label text for 'None'&lt;BR /&gt;
186,20141216 02:18:24.114,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_c24ad8f4825b477981ef3118433af914 -Imlatvq3zok6exedrlytfdpkxs1vqgaaa Missing label. Unable to get label text for 'none'&lt;BR /&gt;
186,20141216 02:18:24.114,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_c24ad8f4825b477981ef3118433af914 -Imlatvq3zok6exedrlytfdpkxs1vqgaaa Missing label. Unable to get label text for 'none'&lt;BR /&gt;
165,20141216 02:18:24.129,1,16,IVW,560727 - 0x418,-PSDUSSTL -R1_10014763243 -I5vowcb1obpletm136x3sfy6c3ptqaaaa Missing label. Unable to get label text for '_qchagenA'&lt;BR /&gt;
81,20141216 02:18:24.129,4,16,IVW,560727 - 0x418,Committing case database updates&lt;BR /&gt;
240,20141216 02:18:24.160,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_c24ad8f4825b477981ef3118433af914 -Imlatvq3zok6exedrlytfdpkxs1vqgaaa DEBUG - CRunningInterview::GeneratePlayerXml, .\RunningInterview.cpp, 2924, Generating XML player output&lt;BR /&gt;
186,20141216 02:18:24.192,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_c24ad8f4825b477981ef3118433af914 -Imlatvq3zok6exedrlytfdpkxs1vqgaaa Missing label. Unable to get label text for 'None'&lt;BR /&gt;
186,20141216 02:18:24.192,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_c24ad8f4825b477981ef3118433af914 -Imlatvq3zok6exedrlytfdpkxs1vqgaaa Missing label. Unable to get label text for 'none'&lt;BR /&gt;
186,20141216 02:18:24.207,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_c24ad8f4825b477981ef3118433af914 -Imlatvq3zok6exedrlytfdpkxs1vqgaaa Missing label. Unable to get label text for 'none'&lt;BR /&gt;
82,20141216 02:18:24.207,4,16,IVW,555737 - 0x1e60,Committing case database updates&lt;BR /&gt;
191,20141216 02:18:24.285,4,16,IVW,555737 - 0x1e60,-P -R -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CSessionEngine::PostInterviewEventImpl, .\SessionEngine.cpp, 3095, Getting running interview&lt;BR /&gt;
233,20141216 02:18:24.285,4,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CSessionEngine::PostInterviewEventImpl, .\SessionEngine.cpp, 3135, Posting interview page&lt;BR /&gt;
232,20141216 02:18:24.285,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CRunningInterview::LoadPostInput, .\RunningInterview.cpp, 2222, Parsing XML player input&lt;BR /&gt;
133,20141216 02:18:24.285,4,16,IVW,555737 - 0x1e60,Requesting a concurrent license for interview ID 'lsqjw25jktre6pb4zlyctr3lh1zagaaa'&lt;BR /&gt;
186,20141216 02:18:24.301,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa Missing label. Unable to get label text for 'none'&lt;BR /&gt;
186,20141216 02:18:24.301,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa Missing label. Unable to get label text for 'none'&lt;BR /&gt;
190,20141216 02:18:24.317,4,16,IVW,560727 - 0x418,-P -R -I1axilu642gqehkp3iltvybrv3trqaaaa DEBUG - CSessionEngine::PostInterviewEventImpl, .\SessionEngine.cpp, 3095, Getting running interview&lt;BR /&gt;
208,20141216 02:18:24.317,4,16,IVW,560727 - 0x418,-PTSIDE103316 -RGEN24_0039 -I1axilu642gqehkp3iltvybrv3trqaaaa DEBUG - CSessionEngine::PostInterviewEventImpl, .\SessionEngine.cpp, 3135, Posting interview page&lt;BR /&gt;
207,20141216 02:18:24.317,1,16,IVW,560727 - 0x418,-PTSIDE103316 -RGEN24_0039 -I1axilu642gqehkp3iltvybrv3trqaaaa DEBUG - CRunningInterview::LoadPostInput, .\RunningInterview.cpp, 2222, Parsing XML player input&lt;BR /&gt;
209,20141216 02:18:24.317,1,16,IVW,560727 - 0x418,-PTSIDE103316 -RGEN24_0039 -I1axilu642gqehkp3iltvybrv3trqaaaa DEBUG - CRunningInterview::ExecuteScript, .\RunningInterview.cpp, 2740, Executing interview script&lt;BR /&gt;
137,20141216 02:18:24.317,1,16,IVW,560727 - 0x418,-PTSIDE103316 -RGEN24_0039 -I1axilu642gqehkp3iltvybrv3trqaaaa Question 'S3d_2' was asked&lt;BR /&gt;
215,20141216 02:18:24.332,1,16,IVW,560727 - 0x418,-PTSIDE103316 -RGEN24_0039 -I1axilu642gqehkp3iltvybrv3trqaaaa DEBUG - CRunningInterview::GeneratePlayerXml, .\RunningInterview.cpp, 2924, Generating XML player output&lt;BR /&gt;
159,20141216 02:18:24.348,1,16,IVW,560727 - 0x418,-PTSIDE103316 -RGEN24_0039 -I1axilu642gqehkp3iltvybrv3trqaaaa Missing label. Unable to get label text for 'C9'&lt;BR /&gt;
81,20141216 02:18:24.348,4,16,IVW,560727 - 0x418,Committing case database updates&lt;BR /&gt;
80,20141216 02:18:24.395,4,16,IVW,555737 - 0x1e60,Removing timed out interviews.&lt;BR /&gt;
234,20141216 02:18:24.395,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CRunningInterview::ExecuteScript, .\RunningInterview.cpp, 2740, Executing interview script&lt;BR /&gt;
183,20141216 02:18:24.426,1,32,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa Interview terminated (Status = 'ScriptStopped')&lt;BR /&gt;
82,20141216 02:18:24.426,4,16,IVW,555737 - 0x1e60,Committing case database updates&lt;BR /&gt;
241,20141216 02:18:24.457,4,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CSessionEngine::CompleteInterview, .\SessionEngine.cpp, 3790, Getting project properties from DPM&lt;BR /&gt;
254,20141216 02:18:24.582,4,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CSessionEngine::GetSampleManagementProvider, .\SessionEngine.cpp, 4374, Getting the sample management provider&lt;BR /&gt;
267,20141216 02:18:24.582,4,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CSessionEngine::CreateSampleManagementPropertiesXML, .\SessionEngine.cpp, 4514, Populating sample management properties XML&lt;BR /&gt;
243,20141216 02:18:24.598,4,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CSessionEngine::SampleManagementReturn, .\SessionEngine.cpp, 4220, Calling sample management Return&lt;BR /&gt;
242,20141216 02:18:24.614,1,1,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaaISMS.MRS: (ver-1-44 DIMENSIONS) ReturnSampleRec: Entered.  Record ID: GEN24_f234c570f39041ec8623337612cd55ad&lt;BR /&gt;
239,20141216 02:18:24.629,1,1,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaaISMS.MRS: (ver-1-44 DIMENSIONS) ReturnSampleRec: SampleRecReturnCode.Code = 5. Exiting, Queue = SCREENOUT&lt;BR /&gt;
246,20141216 02:18:24.629,4,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CSessionEngine::SampleManagementReturn, .\SessionEngine.cpp, 4246, Processing sample management result&lt;BR /&gt;
216,20141216 02:18:24.629,4,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CSessionEngine::CommitQuota, .\SessionEngine.cpp, 5105, Committing Quota&lt;BR /&gt;
130,20141216 02:18:24.645,4,16,IVW,555737 - 0x1e60,Releasing concurrent license for interview ID 'kqy2mejgqtrudb12qef5ybpapwuqgaaa'&lt;BR /&gt;
238,20141216 02:18:24.645,4,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CSessionEngine::CompleteInterview, .\SessionEngine.cpp, 3928, Generating end of interview page&lt;BR /&gt;
253,20141216 02:18:24.645,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CRunningInterview::GenerateEndOfInterviewText, .\RunningInterview.cpp, 3304, Generating end of interview text&lt;BR /&gt;
186,20141216 02:18:24.660,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa Missing label. Unable to get label text for 'None'&lt;BR /&gt;
186,20141216 02:18:24.660,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa Missing label. Unable to get label text for 'none'&lt;BR /&gt;
186,20141216 02:18:24.676,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa Missing label. Unable to get label text for 'none'&lt;BR /&gt;
216,20141216 02:18:24.676,1,16,IVW,555737 - 0x1e60,-PBTSWSBU -RGEN24_f234c570f39041ec8623337612cd55ad -Ikqy2mejgqtrudb12qef5ybpapwuqgaaa DEBUG - CRunningInterview::Close, .\RunningInterview.cpp, 739, Closing interview&lt;BR /&gt;
191,20141216 02:18:24.723,4,16,IVW,555737 - 0x1e60,-P -R -Ikwfyjne4mb6etiveno1it6el6ikacaaa DEBUG - CSessionEngine::PostInterviewEventImpl, .\SessionEngine.cpp, 3095, Getting running interview&lt;BR /&gt;
203,20141216 02:18:24.723,4,16,IVW,555737 - 0x1e60,-PD5GEE -R1_22796523 -Ikwfyjne4mb6etiveno1it6el6ikacaaa DEBUG - CSessionEngine::PostInterviewEventImpl, .\SessionEngine.cpp, 3135, Posting interview page&lt;BR /&gt;
202,20141216 02:18:24.723,1,16,IVW,555737 - 0x1e60,-PD5GEE -R1_22796523 -Ikwfyjne4mb6etiveno1it6el6ikacaaa DEBUG - CRunningInterview::LoadPostInput, .\RunningInterview.cpp, 2222, Parsing XML player input&lt;BR /&gt;
204,20141216 02:18:24.723,1,16,IVW,555737 - 0x1e60,-PD5GEE -R1_22796523 -Ikwfyjne4mb6etiveno1it6el6ikacaaa DEBUG - CRunningInterview::ExecuteScript, .\RunningInterview.cpp, 2740, Executing interview script&lt;BR /&gt;
129,20141216 02:18:24.739,1,16,IVW,555737 - 0x1e60,-PD5GEE -R1_22796523 -Ikwfyjne4mb6etiveno1it6el6ikacaaa Question 'C2' was asked&lt;BR /&gt;
210,20141216 02:18:24.754,1,16,IVW,555737 - 0x1e60,-PD5GEE -R1_22796523 -Ikwfyjne4mb6etiveno1it6el6ikacaaa DEBUG - CRunningInterview::GeneratePlayerXml, .\RunningInterview.cpp, 2924, Generating XML player output&lt;BR /&gt;
156,20141216 02:18:24.770,1,16,IVW,555737 - 0x1e60,-PD5GEE -R1_22796523 -Ikwfyjne4mb6etiveno1it6el6ikacaaa Missing label. Unable to get label text for 'None'&lt;BR /&gt;
82,20141216 02:18:24.785,4,16,IVW,555737 - 0x1e60,Committing case database updates&lt;/P&gt;</description>
      <pubDate>Mon, 28 Sep 2020 18:22:51 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151438#M42438</guid>
      <dc:creator>Laya123</dc:creator>
      <dc:date>2020-09-28T18:22:51Z</dc:date>
    </item>
    <item>
      <title>Re: how to calculate duration for completed and interview and incomplete interview ?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151439#M42439</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;

&lt;P&gt;Did you receive my sample log file, &lt;/P&gt;

&lt;P&gt;Thanks &amp;amp; Regards&lt;/P&gt;</description>
      <pubDate>Tue, 16 Dec 2014 14:08:49 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151439#M42439</guid>
      <dc:creator>Laya123</dc:creator>
      <dc:date>2014-12-16T14:08:49Z</dc:date>
    </item>
    <item>
      <title>Re: how to calculate duration for completed and interview and incomplete interview ?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151440#M42440</link>
      <description>&lt;P&gt;I do not see anything in this log that is equivalent to status='complete'&lt;BR /&gt;
I do see&lt;/P&gt;

&lt;P&gt;CRunningInterview::Close, .RunningInterview.cpp, 739, Closing interview&lt;/P&gt;

&lt;P&gt;in some places...&lt;/P&gt;

&lt;P&gt;In order to answer your question, you need to tell us&lt;/P&gt;

&lt;UL&gt;
&lt;LI&gt;Using this information, how do you identify a single survery&lt;/LI&gt;
&lt;LI&gt;How do you define that the survey completed&lt;/LI&gt;
&lt;/UL&gt;</description>
      <pubDate>Wed, 17 Dec 2014 21:54:34 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151440#M42440</guid>
      <dc:creator>lguinn2</dc:creator>
      <dc:date>2014-12-17T21:54:34Z</dc:date>
    </item>
    <item>
      <title>Re: how to calculate duration for completed and interview and incomplete interview ?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151441#M42441</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;

&lt;P&gt;Thank  you for your response&lt;/P&gt;

&lt;P&gt;Sorry for taxing your time&lt;/P&gt;

&lt;P&gt;Based on the respondent ID we can identify single survey - In the log I highlighted with 'Bold' which is respondentID&lt;/P&gt;

&lt;P&gt;Instead of status We have to see the 'Queue' to get the survey status (Completed or not); this Queue is giving the status of the interview means is it completed or screened out or Quota fail etc., - In the log I highlighted with 'italic' which is the interview status.&lt;/P&gt;

&lt;P&gt;we  have total 5 status for survey here are the definitions &lt;BR /&gt;
Completed - Means Interview (survey) completed&lt;BR /&gt;
Screenout - Means the respondent is not eligible for interview (survey)&lt;BR /&gt;
Time out - Means the respondent open survey webpage more than a minute but he  didnt start interview or after answering some questions he didnt press next button for more than a minute ( this respondent have a chance to take the survey again if the quota (sample) is not over) this status will come. this timeout status can categorised to any of the other status if the respondent want restart his survey&lt;BR /&gt;
Quota fail - quota fail means if we want to do the interview (survey) with 100 respondents and we finished 100 interviews but  if any 101 respondent trying to open this survey page he will get this status&lt;BR /&gt;
Stopped - i dont have much idea about this status. I think  if the owner dont want to continue that survey scripters can stop the survey if any one try to open the survey may  be they will get this status&lt;/P&gt;

&lt;P&gt;Please find enclosed sample log and I have highlighted some respondentIDs (Bold) and some of the Interview status (Italic)&lt;/P&gt;

&lt;P&gt;0,VER,3.0&lt;BR /&gt;
0,HISTORY,Previous LogFile: E:\Program Files\IBM\SPSS\DataCollection\6\Interviewer Server Administration\Logs\IVWE11.tmp&lt;BR /&gt;
0,FORMAT,',',RecordSize:long,DateTime:Date,Log Id:long,Log Levels:long,Log group:string,Log scope:string,Log Entry:string&lt;BR /&gt;
0,CONFIG,300,4096,-1,1&lt;BR /&gt;
171,20141218 03:29:54.688,1,64,IVW,570749 - 0x189c,-PD45A3 -RGEN51_863668068987819-380899 -Imlpagkn6ykeehk6k4pkxaurrl1raoaaa FnRequire3DGridRowsExclusive: Validation passed&lt;BR /&gt;
165,20141218 03:29:55.438,1,32,IVW,570749 - 0x189c,-PTW277104840 -R*&lt;EM&gt;GEN24_6799312409&lt;/EM&gt;* -Ipktn2ekketpuhlrsgmqkfiu5obvasaaa Interview terminated (Status = 'ScriptStopped')&lt;BR /&gt;
202,20141218 03:29:55.579,1,1,IVW,570749 - 0x189c,-PTW277104840 -&lt;STRONG&gt;RGEN24_6799312409&lt;/STRONG&gt; -Ipktn2ekketpuhlrsgmqkfiu5obvasaaaISMS.MRS: (ver-1-44 DIMENSIONS) ReturnSampleRec: Entered.  Record ID: &lt;STRONG&gt;GEN24_6799312409&lt;/STRONG&gt;&lt;BR /&gt;
221,20141218 03:29:55.610,1,1,IVW,570749 - 0x189c,-PTW277104840 -&lt;STRONG&gt;RGEN24_6799312409&lt;/STRONG&gt; -Ipktn2ekketpuhlrsgmqkfiu5obvasaaaISMS.MRS: (ver-1-44 DIMENSIONS) ReturnSampleRec: SampleRecReturnCode.Code = 5. Exiting, &lt;EM&gt;Queue = SCREENOUT&lt;/EM&gt;&lt;BR /&gt;
125,20141218 03:30:04.548,1,1,IVW,570749 - 0x189c,-PDQVQP -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Entered&lt;BR /&gt;
191,20141218 03:30:04.563,1,1,IVW,570749 - 0x189c,-PDQVQP -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: This is not an existing record.  Pid=10038101685, S=LMS50, Id=1, Serial=0&lt;BR /&gt;
371,20141218 03:30:04.767,1,2,IVW,570749 - 0x189c,-PC5BAB -RGMI29_956cbaf5e3ce660b -Iz361jtwvdlmebfqebunp2rzdg45asaaa WARNING: Called from FnGetSmVar. WARNING: type will NOT be saved on timeouts/restarts, current value is: Online. Please save the value to the case data by passing a QUESTION metadata object into the first parameter of FnGetSmVar function instead of NULL.&lt;BR /&gt;
191,20141218 03:30:04.782,1,1,IVW,570749 - 0x189c,-PDQVQP -R1_10038101685 -IISMS.MRS: (ver-1-44 DIMENSIONS) AddRecordWithGivenId: Created new record with Id 1_10038101685 into queue ACTIVE_NEW&lt;BR /&gt;
111,20141218 03:30:04.782,1,1,IVW,570749 - 0x189c,-PDQVQP -R -IISMS.MRS: (ver-1-44 DIMENSIONS) TestUser set to 0&lt;BR /&gt;
144,20141218 03:30:04.782,1,1,IVW,570749 - 0x189c,-PDQVQP -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Quota project. Attaching SampleRec to QuotaEngine.&lt;BR /&gt;
103,20141218 03:30:04.782,1,1,IVW,570749 - 0x189c,-PDQVQP -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Succeeded&lt;BR /&gt;
202,20141218 03:30:04.829,1,2,IVW,570749 - 0x189c,-PDQVQP -R*&lt;EM&gt;1_10038101685&lt;/EM&gt;* -Ijghgegd611xujgxaywsxoypc4z5qsaaa Invalid value for interview property 'Test'.  The default value for this property will be used&lt;BR /&gt;
202,20141218 03:30:04.845,1,2,IVW,570749 - 0x189c,-PDQVQP -R*&lt;EM&gt;1_10038101685&lt;/EM&gt;* -Ijghgegd611xujgxaywsxoypc4z5qsaaa Invalid value for interview property 'Test'.  The default value for this property will be used&lt;BR /&gt;
124,20141218 03:30:04.845,1,32,IVW,570749 - 0x189c,-PDQVQP -R1_&lt;STRONG&gt;10038101685&lt;/STRONG&gt; -Ijghgegd611xujgxaywsxoypc4z5qsaaa Interview start&lt;BR /&gt;
364,20141218 03:30:04.923,1,2,IVW,570749 - 0x189c,-PDQVQP -R*&lt;EM&gt;1_10038101685&lt;/EM&gt;* -Ijghgegd611xujgxaywsxoypc4z5qsaaa WARNING: Called from FnGetSmVar. WARNING: _usedemovars will NOT be saved on timeouts/restarts, current value is: . Please save the value to the case data by passing a QUESTION metadata object into the first parameter of FnGetSmVar function instead of NULL.&lt;BR /&gt;
542,20141218 03:30:04.954,1,2,IVW,570749 - 0x189c,-PDNNKM -R1004095_10006525458 -Iiplxxyiqbutebbymcpmy1wmfbujaqaaa The label '&lt;I&gt;Place mouse over to zoom image&lt;/I&gt;&lt;BR /&gt;&lt;BR /&gt;
' contains a syntax error at column 226&lt;BR /&gt;
158,20141218 03:30:07.329,1,32,IVW,570749 - 0x189c,-PD45A3 -R*&lt;EM&gt;225_10014523011&lt;/EM&gt;* -Ighcmd6yr4uwu2cpkq5iitwbkjvzasaaa Interview terminated (Status = 'ScriptStopped')&lt;BR /&gt;
202,20141218 03:30:07.407,1,1,IVW,570749 - 0x189c,-PD45A3 -R*&lt;EM&gt;225_10014523011&lt;/EM&gt;* -Ighcmd6yr4uwu2cpkq5iitwbkjvzasaaaISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) ReturnSampleRec: Entered.  Record ID: 225_10014523011&lt;BR /&gt;
222,20141218 03:30:07.407,1,1,IVW,570749 - 0x189c,-PD45A3 -R*&lt;EM&gt;225_10014523011&lt;/EM&gt;* -Ighcmd6yr4uwu2cpkq5iitwbkjvzasaaaISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) ReturnSampleRec: SampleRecReturnCode.Code = 5. Exiting, &lt;EM&gt;Queue = SCREENOUT&lt;/EM&gt;&lt;BR /&gt;
125,20141218 03:30:08.251,1,1,IVW,570749 - 0x189c,-PC5BAB -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Entered&lt;BR /&gt;
196,20141218 03:30:08.282,1,1,IVW,570749 - 0x189c,-PC5BAB -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: This is not an existing record.  Pid=3BD44448ABDDCD87, S=GMI29, Id=1, Serial=0&lt;BR /&gt;
209,20141218 03:30:08.314,1,1,IVW,570749 - 0x189c,-PC5BAB -RGMI29_3BD44448ABDDCD87 -IISMS.MRS: (ver-1-44 DIMENSIONS) AddRecordWithGivenId: Created new record with Id GMI29_3BD44448ABDDCD87 into queue ACTIVE_NEW&lt;BR /&gt;
111,20141218 03:30:08.314,1,1,IVW,570749 - 0x189c,-PC5BAB -R -IISMS.MRS: (ver-1-44 DIMENSIONS) TestUser set to 0&lt;BR /&gt;
144,20141218 03:30:08.314,1,1,IVW,570749 - 0x189c,-PC5BAB -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Quota project. Attaching SampleRec to QuotaEngine.&lt;BR /&gt;
103,20141218 03:30:08.314,1,1,IVW,570749 - 0x189c,-PC5BAB -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Succeeded&lt;BR /&gt;
133,20141218 03:30:08.423,1,32,IVW,570749 - 0x189c,-PC5BAB -RGMI29_3BD44448ABDDCD87 -Imwf3v1i2th2e2bmkpnzjlasynj6asaaa Interview start&lt;BR /&gt;
373,20141218 03:30:08.485,1,2,IVW,570749 - 0x189c,-PC5BAB -RGMI29_3BD44448ABDDCD87 -Imwf3v1i2th2e2bmkpnzjlasynj6asaaa WARNING: Called from FnGetSmVar. WARNING: _usedemovars will NOT be saved on timeouts/restarts, current value is: . Please save the value to the case data by passing a QUESTION metadata object into the first parameter of FnGetSmVar function instead of NULL.&lt;BR /&gt;
134,20141218 03:30:10.189,1,1,IVW,570749 - 0x189c,-PR106000141987A -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Entered&lt;BR /&gt;
197,20141218 03:30:10.189,1,1,IVW,570749 - 0x189c,-PR106000141987A -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: This is not an existing record.  Pid=R1000135, S=GEN24, Id=1, Serial=0&lt;BR /&gt;
202,20141218 03:30:10.220,1,1,IVW,570749 - 0x189c,-PR106000141987A -RGEN24_R1000135 -IISMS.MRS: (ver-1-44 DIMENSIONS) AddRecordWithGivenId: Created new record with Id GEN24_R1000135 into queue ACTIVE_NEW&lt;BR /&gt;
120,20141218 03:30:10.220,1,1,IVW,570749 - 0x189c,-PR106000141987A -R -IISMS.MRS: (ver-1-44 DIMENSIONS) TestUser set to 0&lt;BR /&gt;
153,20141218 03:30:10.220,1,1,IVW,570749 - 0x189c,-PR106000141987A -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Quota project. Attaching SampleRec to QuotaEngine.&lt;BR /&gt;
112,20141218 03:30:10.220,1,1,IVW,570749 - 0x189c,-PR106000141987A -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Succeeded&lt;BR /&gt;
134,20141218 03:30:10.267,1,32,IVW,570749 - 0x189c,-PR106000141987A -RGEN24_R1000135 -Ish3aximtqpgerfvbwcld2rgvbv6qsaaa Interview start&lt;BR /&gt;
374,20141218 03:30:10.314,1,2,IVW,570749 - 0x189c,-PR106000141987A -RGEN24_R1000135 -Ish3aximtqpgerfvbwcld2rgvbv6qsaaa WARNING: Called from FnGetSmVar. WARNING: _usedemovars will NOT be saved on timeouts/restarts, current value is: . Please save the value to the case data by passing a QUESTION metadata object into the first parameter of FnGetSmVar function instead of NULL.&lt;BR /&gt;
542,20141218 03:30:11.251,1,2,IVW,570749 - 0x189c,-PDNNKM -R1004095_10006525458 -Iiplxxyiqbutebbymcpmy1wmfbujaqaaa The label '&lt;I&gt;Place mouse over to zoom image&lt;/I&gt;&lt;BR /&gt;&lt;BR /&gt;
' contains a syntax error at column 226&lt;BR /&gt;
371,20141218 03:30:11.673,1,2,IVW,570749 - 0x189c,-PC5BAB -RGMI29_3BD44448ABDDCD87 -Imwf3v1i2th2e2bmkpnzjlasynj6asaaa WARNING: Called from FnGetSmVar. WARNING: type will NOT be saved on timeouts/restarts, current value is: Online. Please save the value to the case data by passing a QUESTION metadata object into the first parameter of FnGetSmVar function instead of NULL.&lt;BR /&gt;
133,20141218 03:30:11.861,1,1,IVW,570749 - 0x189c,-PD64HF -R1 -IISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) AuthenticateSampleRec: Entered&lt;BR /&gt;
197,20141218 03:30:11.876,1,1,IVW,570749 - 0x189c,-PD64HF -R1 -IISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) AuthenticateSampleRec: This is not an existing record.  Pid=400021657, S=CFB01, Id=1, Serial=0&lt;BR /&gt;
181,20141218 03:30:11.876,1,1,IVW,570749 - 0x189c,-PD64HF -RCFB01_400021657 -IISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) AddRecordWithGivenId: Created new record with Id CFB01_400021657&lt;BR /&gt;
119,20141218 03:30:11.876,1,1,IVW,570749 - 0x189c,-PD64HF -R -IISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) TestUser set to 0&lt;BR /&gt;
154,20141218 03:30:11.876,1,1,IVW,570749 - 0x189c,-PD64HF -R -IISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) Sample is in an ok queue so authentication succeeded&lt;BR /&gt;
152,20141218 03:30:11.892,1,1,IVW,570749 - 0x189c,-PD64HF -R -IISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) Quota project. Attaching SampleRec to QuotaEngine.&lt;BR /&gt;
111,20141218 03:30:11.892,1,1,IVW,570749 - 0x189c,-PD64HF -R -IISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) Succeeded&lt;BR /&gt;
126,20141218 03:30:11.939,1,32,IVW,570749 - 0x189c,-PD64HF -RCFB01_400021657 -I56zjynoxbkiuvp1pzvnquh1v1waasaaa Interview start&lt;BR /&gt;
158,20141218 03:30:12.329,1,32,IVW,570749 - 0x189c,-PD64HF -RCFB01_400021657 -I56zjynoxbkiuvp1pzvnquh1v1waasaaa Interview terminated (Status = 'ScriptStopped')&lt;BR /&gt;
202,20141218 03:30:12.392,1,1,IVW,570749 - 0x189c,-PD64HF -RCFB01_400021657 -I56zjynoxbkiuvp1pzvnquh1v1waasaaaISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) ReturnSampleRec: Entered.  Record ID: CFB01_400021657&lt;BR /&gt;
223,20141218 03:30:12.392,1,1,IVW,570749 - 0x189c,-PD64HF -RCFB01_400021657 -I56zjynoxbkiuvp1pzvnquh1v1waasaaaISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) ReturnSampleRec: SampleRecReturnCode.Code = 3. Exiting, Queue = QUOTA_FAIL&lt;BR /&gt;
1270,20141218 03:30:13.892,1,2,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888810763373 -I2qotefhorh2efa6w2aihfvhjb13aqaaa The label 'Thank you for your participation in our survey. As a valued Michael Kors consumer, you will be entered into a sweepstakes to win a $500 Michael Kors gift card.   &lt;/P&gt;

&lt;P&gt;There is no purchase necessary. Must be 18 or older, US resident, to enter to win. Starts: December 4, 2014. Ends: December 18, 2014. One entry per person per email address. 6 prizes total, each a $500 Michael Kors Gift Card, subject to additional terms and conditions as set forth on the card. Additional restrictions may apply.&lt;A href="#" target="_blank"&gt;&lt;B&gt;&lt;U&gt;For additional details, see Official Rules&lt;/U&gt;&lt;/B&gt;&lt;/A&gt;.    &lt;/P&gt;

&lt;P&gt;In order for us to contact you should you win the sweepstakes, please supply the following information. We would like to stress that this information will only be used to send you notification about the sweepstakes, and will not be used for any other purpose.' contains a syntax error at column 1047&lt;BR /&gt;
125,20141218 03:30:15.033,1,1,IVW,570749 - 0x189c,-PD63G4 -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Entered&lt;BR /&gt;
199,20141218 03:30:15.048,1,1,IVW,570749 - 0x189c,-PD63G4 -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: This is not an existing record.  Pid=MB17C951A46146E73DE, S=GEN24, Id=1, Serial=0&lt;BR /&gt;
215,20141218 03:30:15.064,1,1,IVW,570749 - 0x189c,-PD63G4 -RGEN24_MB17C951A46146E73DE -IISMS.MRS: (ver-1-44 DIMENSIONS) AddRecordWithGivenId: Created new record with Id GEN24_MB17C951A46146E73DE into queue ACTIVE_NEW&lt;BR /&gt;
111,20141218 03:30:15.080,1,1,IVW,570749 - 0x189c,-PD63G4 -R -IISMS.MRS: (ver-1-44 DIMENSIONS) TestUser set to 0&lt;BR /&gt;
144,20141218 03:30:15.080,1,1,IVW,570749 - 0x189c,-PD63G4 -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Quota project. Attaching SampleRec to QuotaEngine.&lt;BR /&gt;
103,20141218 03:30:15.080,1,1,IVW,570749 - 0x189c,-PD63G4 -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Succeeded&lt;BR /&gt;
136,20141218 03:30:15.126,1,32,IVW,570749 - 0x189c,-PD63G4 -RGEN24_MB17C951A46146E73DE -Ienbpb4xbkwnute34fz2kamrzscaqsaaa Interview start&lt;BR /&gt;
376,20141218 03:30:15.158,1,2,IVW,570749 - 0x189c,-PD63G4 -RGEN24_MB17C951A46146E73DE -Ienbpb4xbkwnute34fz2kamrzscaqsaaa WARNING: Called from FnGetSmVar. WARNING: _usedemovars will NOT be saved on timeouts/restarts, current value is: . Please save the value to the case data by passing a QUESTION metadata object into the first parameter of FnGetSmVar function instead of NULL.&lt;BR /&gt;
542,20141218 03:30:16.189,1,2,IVW,570749 - 0x189c,-PDNNKM -R1004095_10006525458 -Iiplxxyiqbutebbymcpmy1wmfbujaqaaa The label '&lt;I&gt;Place mouse over to zoom image&lt;/I&gt;&lt;BR /&gt;&lt;BR /&gt;
' contains a syntax error at column 226&lt;BR /&gt;
584,20141218 03:30:16.220,1,2,IVW,570749 - 0x189c,-PC5BAB -RGMI29_3BD44448ABDDCD87 -Imwf3v1i2th2e2bmkpnzjlasynj6asaaa The label '' contains a syntax error at column 61&lt;BR /&gt;
584,20141218 03:30:16.267,1,2,IVW,570749 - 0x189c,-PC5BAB -RGMI29_3BD44448ABDDCD87 -Imwf3v1i2th2e2bmkpnzjlasynj6asaaa The label '' contains a syntax error at column 61&lt;BR /&gt;
144,20141218 03:30:16.423,1,64,IVW,570749 - 0x189c,-PD45A3 -RGEN51_163678058916899-380899 -Inomfnlaoenkengmhlqqzqithtruasaaa in loops categorical&lt;BR /&gt;
160,20141218 03:30:16.439,1,64,IVW,570749 - 0x189c,-PD45A3 -RGEN51_163678058916899-380899 -Inomfnlaoenkengmhlqqzqithtruasaaa FnRequireSeqInput: Validation passed&lt;BR /&gt;
155,20141218 03:30:16.439,1,64,IVW,570749 - 0x189c,-PD45A3 -RGEN51_163678058916899-380899 -Inomfnlaoenkengmhlqqzqithtruasaaa CheckUnaided: Validation passed&lt;BR /&gt;
584,20141218 03:30:17.548,1,2,IVW,570749 - 0x189c,-PC5BAB -RGMI29_956cbaf5e3ce660b -Iz361jtwvdlmebfqebunp2rzdg45asaaa The label '' contains a syntax error at column 61&lt;BR /&gt;
584,20141218 03:30:17.595,1,2,IVW,570749 - 0x189c,-PC5BAB -RGMI29_956cbaf5e3ce660b -Iz361jtwvdlmebfqebunp2rzdg45asaaa The label '' contains a syntax error at column 61&lt;BR /&gt;
297,20141218 03:30:18.955,1,2,IVW,570749 - 0x189c,-PDQVQP -R1_10038101685 -Ijghgegd611xujgxaywsxoypc4z5qsaaa The label 'Please enter your 5 digit zip code.' contains a syntax error at column 96&lt;BR /&gt;
132,20141218 03:30:19.486,1,32,IVW,570749 - 0x189c,-PDNNKM -R1004095_10005878395 -Ibsbujipgrxaevfsembqu4kolarlaqaaa Interview restart&lt;BR /&gt;
143,20141218 03:30:19.502,1,1,IVW,570749 - 0x189c,-PDNNKM -R1004095_10005878395 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Entered&lt;BR /&gt;
199,20141218 03:30:19.517,1,1,IVW,570749 - 0x189c,-PDNNKM -R1004095_10005878395 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Record exists: S=LMS50, Id=1004095_10005878395, Queue=TIMED_OUT&lt;BR /&gt;
111,20141218 03:30:19.548,1,1,IVW,570749 - 0x189c,-PDNNKM -R -IISMS.MRS: (ver-1-44 DIMENSIONS) TestUser set to 0&lt;BR /&gt;
116,20141218 03:30:19.548,1,1,IVW,570749 - 0x189c,-PDNNKM -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Setting Serial to 6724&lt;BR /&gt;
144,20141218 03:30:19.548,1,1,IVW,570749 - 0x189c,-PDNNKM -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Quota project. Attaching SampleRec to QuotaEngine.&lt;BR /&gt;
103,20141218 03:30:19.548,1,1,IVW,570749 - 0x189c,-PDNNKM -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Succeeded&lt;BR /&gt;
139,20141218 03:30:20.939,1,1,IVW,570749 - 0x189c,-PR106000141987A -&lt;STRONG&gt;RGEN24_R1000134&lt;/STRONG&gt; -Ir2eixovuakyejessvhbsaixmcq2asaaa INFO: Building params&lt;BR /&gt;
134,20141218 03:30:20.939,1,1,IVW,570749 - 0x189c,-PR106000141987A -&lt;STRONG&gt;RGEN24_R1000134&lt;/STRONG&gt; -Ir2eixovuakyejessvhbsaixmcq2asaaa INFO: Excecuting&lt;BR /&gt;
138,20141218 03:30:20.939,1,1,IVW,570749 - 0x189c,-PR106000141987A -&lt;STRONG&gt;RGEN24_R1000134&lt;/STRONG&gt; -Ir2eixovuakyejessvhbsaixmcq2asaaa INFO: Done executing&lt;BR /&gt;
158,20141218 03:30:20.939,1,1,IVW,570749 - 0x189c,-PR106000141987A -&lt;STRONG&gt;RGEN24_R1000134&lt;/STRONG&gt; -Ir2eixovuakyejessvhbsaixmcq2asaaa INFO: Got value returned: NOTRUN, NOTRUN&lt;BR /&gt;
162,20141218 03:30:20.970,1,32,IVW,570749 - 0x189c,-PR106000141987A -&lt;STRONG&gt;RGEN24_R1000134&lt;/STRONG&gt; -Ir2eixovuakyejessvhbsaixmcq2asaaa Interview terminated (Status = 'Completed')&lt;BR /&gt;
137,20141218 03:30:20.970,1,32,IVW,570749 - 0x189c,-PR106000141987A -&lt;STRONG&gt;RGEN24_R1000134&lt;/STRONG&gt; -Ir2eixovuakyejessvhbsaixmcq2asaaa Interview complete&lt;BR /&gt;
201,20141218 03:30:21.033,1,1,IVW,570749 - 0x189c,-PR106000141987A -&lt;STRONG&gt;RGEN24_R1000134&lt;/STRONG&gt; -Ir2eixovuakyejessvhbsaixmcq2asaaaISMS.MRS: (ver-1-44 DIMENSIONS) ReturnSampleRec: Entered.  Record ID: GEN24_R1000134&lt;BR /&gt;
222,20141218 03:30:21.033,1,1,IVW,570749 - 0x189c,-PR106000141987A -&lt;STRONG&gt;RGEN24_R1000134&lt;/STRONG&gt; -Ir2eixovuakyejessvhbsaixmcq2asaaaISMS.MRS: (ver-1-44 DIMENSIONS) ReturnSampleRec: SampleRecReturnCode.Code = 1. Exiting, &lt;EM&gt;Queue = COMPLETED&lt;/EM&gt;&lt;BR /&gt;
126,20141218 03:30:21.252,1,32,IVW,570749 - 0x189c,-PCH224 -RGEN27_1782470 -Iuwm5oy23vtyerh6swcbmg3eowl5qmaaa Interview restart&lt;BR /&gt;
137,20141218 03:30:21.267,1,1,IVW,570749 - 0x189c,-PCH224 -RGEN27_1782470 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Entered&lt;BR /&gt;
187,20141218 03:30:21.283,1,1,IVW,570749 - 0x189c,-PCH224 -RGEN27_1782470 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Record exists: S=GEN27, Id=GEN27_1782470, Queue=TIMED_OUT&lt;BR /&gt;
111,20141218 03:30:21.299,1,1,IVW,570749 - 0x189c,-PCH224 -R -IISMS.MRS: (ver-1-44 DIMENSIONS) TestUser set to 0&lt;BR /&gt;
116,20141218 03:30:21.299,1,1,IVW,570749 - 0x189c,-PCH224 -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Setting Serial to 5845&lt;BR /&gt;
144,20141218 03:30:21.314,1,1,IVW,570749 - 0x189c,-PCH224 -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Quota project. Attaching SampleRec to QuotaEngine.&lt;BR /&gt;
103,20141218 03:30:21.314,1,1,IVW,570749 - 0x189c,-PCH224 -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Succeeded&lt;BR /&gt;
158,20141218 03:30:21.830,1,32,IVW,570749 - 0x189c,-PD64HF -RCFB01_400093601 -Iykpg14vp6jwenfw3au2bznkszj3asaaa Interview terminated (Status = 'ScriptStopped')&lt;BR /&gt;
202,20141218 03:30:21.955,1,1,IVW,570749 - 0x189c,-PD64HF -RCFB01_400093601 -Iykpg14vp6jwenfw3au2bznkszj3asaaaISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) ReturnSampleRec: Entered.  Record ID: CFB01_400093601&lt;BR /&gt;
222,20141218 03:30:21.955,1,1,IVW,570749 - 0x189c,-PD64HF -RCFB01_400093601 -Iykpg14vp6jwenfw3au2bznkszj3asaaaISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) ReturnSampleRec: SampleRecReturnCode.Code = 5. Exiting, Queue = SCREENOUT&lt;BR /&gt;
153,20141218 03:30:25.611,1,32,IVW,570749 - 0x189c,-PD45A3 -RGMI29_26829776 -Ibuov6xmhd5judgi5uzhoix53o46qqaaa Interview terminated (Status = 'Completed')&lt;BR /&gt;
128,20141218 03:30:25.611,1,32,IVW,570749 - 0x189c,-PD45A3 -RGMI29_26829776 -Ibuov6xmhd5judgi5uzhoix53o46qqaaa Interview complete&lt;BR /&gt;
542,20141218 03:30:25.767,1,2,IVW,570749 - 0x189c,-PDNNKM -R1004095_10006525458 -Iiplxxyiqbutebbymcpmy1wmfbujaqaaa The label '&lt;I&gt;Place mouse over to zoom image&lt;/I&gt;&lt;BR /&gt;&lt;BR /&gt;
' contains a syntax error at column 226&lt;BR /&gt;
200,20141218 03:30:25.783,1,1,IVW,570749 - 0x189c,-PD45A3 -RGMI29_26829776 -Ibuov6xmhd5judgi5uzhoix53o46qqaaaISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) ReturnSampleRec: Entered.  Record ID: GMI29_26829776&lt;BR /&gt;
221,20141218 03:30:25.783,1,1,IVW,570749 - 0x189c,-PD45A3 -RGMI29_26829776 -Ibuov6xmhd5judgi5uzhoix53o46qqaaaISMSHERMES.MRS: (ver-2.2 SHELL REWRITE) ReturnSampleRec: SampleRecReturnCode.Code = 1. Exiting, Queue = COMPLETED&lt;BR /&gt;
134,20141218 03:30:26.643,1,1,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888810763373 -I2qotefhorh2efa6w2aihfvhjb13aqaaa INFO: Building params&lt;BR /&gt;
129,20141218 03:30:26.643,1,1,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888810763373 -I2qotefhorh2efa6w2aihfvhjb13aqaaa INFO: Excecuting&lt;BR /&gt;
133,20141218 03:30:26.658,1,1,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888810763373 -I2qotefhorh2efa6w2aihfvhjb13aqaaa INFO: Done executing&lt;BR /&gt;
149,20141218 03:30:26.658,1,1,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888810763373 -I2qotefhorh2efa6w2aihfvhjb13aqaaa INFO: Got value returned: PASS, PASS&lt;BR /&gt;
205,20141218 03:30:26.674,1,4,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888810763373 -I2qotefhorh2efa6w2aihfvhjb13aqaaa ERROR: Error in SbEndTime. Error Desc: The value 534737 is greater than the maximum of 99999&lt;BR /&gt;
723,20141218 03:30:29.065,1,2,IVW,570749 - 0x189c,-PD64X3 -RGEN24_494076 -I61ijk4j2kzeernz55nknfcddgulqsaaa The label '&lt;/P&gt;&lt;DIV id="wrapper"&gt;&lt;AUDIO preload="auto" controls="controls"&gt;&lt;SOURCE src="/SPSSMR/ImageCache/ImageCache.aspx?Project=d64x3&amp;amp;File={#RadioAd_MP3}}"&gt;&lt;/SOURCE&gt;&lt;SOURCE src="/SPSSMR/ImageCache/ImageCache.aspx?Project=d64x3&amp;amp;File={#RadioAd_ogg}"&gt;&lt;/SOURCE&gt;&lt;SOURCE src="/SPSSMR/ImageCache/ImageCache.aspx?Project=d64x3&amp;amp;File={#RadioAd_SWF}"&gt;&lt;/SOURCE&gt;&lt;SOURCE src="/SPSSMR/ImageCache/ImageCache.aspx?Project=d64x3&amp;amp;File={#RadioAd_aac}"&gt;&lt;/SOURCE&gt;&lt;/AUDIO&gt;&lt;SCRIPT type="text/javascript"&gt;$( function()    {   $( &amp;amp;amp;amp;amp;amp;quot;audio&amp;amp;amp;amp;amp;amp;quot; ).audioPlayer({autosbmt:true});  }); &lt;/SCRIPT&gt;&lt;/DIV&gt;' contains a syntax error at column 504&lt;BR /&gt;
1290,20141218 03:30:29.065,1,2,IVW,570749 - 0x189c,-PD64X3 -RGEN24_494076 -I61ijk4j2kzeernz55nknfcddgulqsaaa The label '' contains a syntax error at column 845&lt;BR /&gt;
125,20141218 03:30:29.752,1,1,IVW,570749 - 0x189c,-PDNNKM -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Entered&lt;BR /&gt;
191,20141218 03:30:29.768,1,1,IVW,570749 - 0x189c,-PDNNKM -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: This is not an existing record.  Pid=10006478119, S=LMS50, Id=1, Serial=0&lt;BR /&gt;
203,20141218 03:30:29.940,1,1,IVW,570749 - 0x189c,-PDNNKM -R1004095_10006478119 -IISMS.MRS: (ver-1-44 DIMENSIONS) AddRecordWithGivenId: Created new record with Id 1004095_10006478119 into queue ACTIVE_NEW&lt;BR /&gt;
111,20141218 03:30:29.940,1,1,IVW,570749 - 0x189c,-PDNNKM -R -IISMS.MRS: (ver-1-44 DIMENSIONS) TestUser set to 0&lt;BR /&gt;
144,20141218 03:30:29.940,1,1,IVW,570749 - 0x189c,-PDNNKM -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Quota project. Attaching SampleRec to QuotaEngine.&lt;BR /&gt;
103,20141218 03:30:29.940,1,1,IVW,570749 - 0x189c,-PDNNKM -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Succeeded&lt;BR /&gt;
130,20141218 03:30:30.002,1,32,IVW,570749 - 0x189c,-PDNNKM -R1004095_10006478119 -Ipqdgd3zdltteji2t1jnvo5ebtobasaaa Interview start&lt;BR /&gt;
370,20141218 03:30:30.111,1,2,IVW,570749 - 0x189c,-PDNNKM -R1004095_10006478119 -Ipqdgd3zdltteji2t1jnvo5ebtobasaaa WARNING: Called from FnGetSmVar. WARNING: _usedemovars will NOT be saved on timeouts/restarts, current value is: . Please save the value to the case data by passing a QUESTION metadata object into the first parameter of FnGetSmVar function instead of NULL.&lt;BR /&gt;
144,20141218 03:30:30.611,1,32,IVW,570749 - 0x189c,-PD63G4 -RGEN24_MB7D_4545_118277_1QTN0AHI -I2pffpxkeljputchgmqk4xk1hxsaaqaaa Interview timeout&lt;BR /&gt;
226,20141218 03:30:30.627,1,1,IVW,570749 - 0x189c,-PD63G4 -RGEN24_MB7D_4545_118277_1QTN0AHI -I2pffpxkeljputchgmqk4xk1hxsaaqaaaISMS.MRS: (ver-1-44 DIMENSIONS) ReturnSampleRec: Entered.  Record ID: GEN24_MB7D_4545_118277_1QTN0AHI&lt;BR /&gt;
230,20141218 03:30:30.643,1,1,IVW,570749 - 0x189c,-PD63G4 -RGEN24_MB7D_4545_118277_1QTN0AHI -I2pffpxkeljputchgmqk4xk1hxsaaqaaaISMS.MRS: (ver-1-44 DIMENSIONS) ReturnSampleRec: SampleRecReturnCode.Code = 2. Exiting, Queue = TIMED_OUT&lt;BR /&gt;
125,20141218 03:30:32.018,1,1,IVW,570749 - 0x189c,-PDNNKM -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Entered&lt;BR /&gt;
191,20141218 03:30:32.033,1,1,IVW,570749 - 0x189c,-PDNNKM -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: This is not an existing record.  Pid=10002849577, S=LMS50, Id=1, Serial=0&lt;BR /&gt;
203,20141218 03:30:32.080,1,1,IVW,570749 - 0x189c,-PDNNKM -R1004095_10002849577 -IISMS.MRS: (ver-1-44 DIMENSIONS) AddRecordWithGivenId: Created new record with Id 1004095_10002849577 into queue ACTIVE_NEW&lt;BR /&gt;
111,20141218 03:30:32.080,1,1,IVW,570749 - 0x189c,-PDNNKM -R -IISMS.MRS: (ver-1-44 DIMENSIONS) TestUser set to 0&lt;BR /&gt;
144,20141218 03:30:32.080,1,1,IVW,570749 - 0x189c,-PDNNKM -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Quota project. Attaching SampleRec to QuotaEngine.&lt;BR /&gt;
103,20141218 03:30:32.080,1,1,IVW,570749 - 0x189c,-PDNNKM -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Succeeded&lt;BR /&gt;
130,20141218 03:30:32.143,1,32,IVW,570749 - 0x189c,-PDNNKM -R1004095_10002849577 -Ijqbfiuuib2me2grolsjpsiyq3kbqsaaa Interview start&lt;BR /&gt;
370,20141218 03:30:32.252,1,2,IVW,570749 - 0x189c,-PDNNKM -R1004095_10002849577 -Ijqbfiuuib2me2grolsjpsiyq3kbqsaaa WARNING: Called from FnGetSmVar. WARNING: _usedemovars will NOT be saved on timeouts/restarts, current value is: . Please save the value to the case data by passing a QUESTION metadata object into the first parameter of FnGetSmVar function instead of NULL.&lt;BR /&gt;
205,20141218 03:30:33.830,1,4,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888810763373 -I2qotefhorh2efa6w2aihfvhjb13aqaaa ERROR: Error in SbEndTime. Error Desc: The value 534744 is greater than the maximum of 99999&lt;BR /&gt;
157,20141218 03:30:33.846,1,32,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888810763373 -I2qotefhorh2efa6w2aihfvhjb13aqaaa Interview terminated (Status = 'Completed')&lt;BR /&gt;
132,20141218 03:30:33.846,1,32,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888810763373 -I2qotefhorh2efa6w2aihfvhjb13aqaaa Interview complete&lt;BR /&gt;
200,20141218 03:30:33.971,1,1,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888810763373 -I2qotefhorh2efa6w2aihfvhjb13aqaaaISMS.MRS: (ver-1-44 DIMENSIONS) ReturnSampleRec: Entered.  Record ID: GEN24_888810763373&lt;BR /&gt;
217,20141218 03:30:33.971,1,1,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888810763373 -I2qotefhorh2efa6w2aihfvhjb13aqaaaISMS.MRS: (ver-1-44 DIMENSIONS) ReturnSampleRec: SampleRecReturnCode.Code = 1. Exiting, Queue = COMPLETED&lt;BR /&gt;
125,20141218 03:30:35.549,1,1,IVW,570749 - 0x189c,-PDQVQP -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Entered&lt;BR /&gt;
192,20141218 03:30:35.549,1,1,IVW,570749 - 0x189c,-PDQVQP -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: This is not an existing record.  Pid=888806472905, S=GEN24, Id=1, Serial=0&lt;BR /&gt;
201,20141218 03:30:35.627,1,1,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888806472905 -IISMS.MRS: (ver-1-44 DIMENSIONS) AddRecordWithGivenId: Created new record with Id GEN24_888806472905 into queue ACTIVE_NEW&lt;BR /&gt;
111,20141218 03:30:35.627,1,1,IVW,570749 - 0x189c,-PDQVQP -R -IISMS.MRS: (ver-1-44 DIMENSIONS) TestUser set to 0&lt;BR /&gt;
144,20141218 03:30:35.627,1,1,IVW,570749 - 0x189c,-PDQVQP -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Quota project. Attaching SampleRec to QuotaEngine.&lt;BR /&gt;
103,20141218 03:30:35.627,1,1,IVW,570749 - 0x189c,-PDQVQP -R -IISMS.MRS: (ver-1-44 DIMENSIONS) Succeeded&lt;BR /&gt;
129,20141218 03:30:35.690,1,32,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888806472905 -Ib4mh6fzfgkgezlrsdmliujijf5casaaa Interview start&lt;BR /&gt;
369,20141218 03:30:35.737,1,2,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888806472905 -Ib4mh6fzfgkgezlrsdmliujijf5casaaa WARNING: Called from FnGetSmVar. WARNING: _usedemovars will NOT be saved on timeouts/restarts, current value is: . Please save the value to the case data by passing a QUESTION metadata object into the first parameter of FnGetSmVar function instead of NULL.&lt;BR /&gt;
161,20141218 03:30:37.174,1,32,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888806472905 -Ib4mh6fzfgkgezlrsdmliujijf5casaaa Interview terminated (Status = 'ScriptStopped')&lt;BR /&gt;
200,20141218 03:30:37.299,1,1,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888806472905 -Ib4mh6fzfgkgezlrsdmliujijf5casaaaISMS.MRS: (ver-1-44 DIMENSIONS) ReturnSampleRec: Entered.  Record ID: GEN24_888806472905&lt;BR /&gt;
215,20141218 03:30:37.315,1,1,IVW,570749 - 0x189c,-PDQVQP -RGEN24_888806472905 -Ib4mh6fzfgkgezlrsdmliujijf5casaaaISMS.MRS: (ver-1-44 DIMENSIONS) ReturnSampleRec: SampleRecReturnCode.Code = 2. Exiting, Queue = STOPPED&lt;BR /&gt;
125,20141218 03:30:41.018,1,1,IVW,570749 - 0x189c,-PD63G4 -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Entered&lt;BR /&gt;
187,20141218 03:30:41.034,1,1,IVW,570749 - 0x189c,-PD63G4 -R1 -IISMS.MRS: (ver-1-44 DIMENSIONS) AuthenticateSampleRec: Record exists: S=GEN24, Id=GEN24_MB21954_6134142yZiW, Queue=SCREENOUT&lt;BR /&gt;
111,20141218 03:30:41.065,1,1,IVW,570749 - 0x189c,-PD63G4 -R -IISMS.MRS: (ver-1-44 DIMENSIONS) TestUser set to 0&lt;P&gt;&lt;/P&gt;

&lt;P&gt;Please help me&lt;/P&gt;

&lt;P&gt;Thanks &amp;amp; regards&lt;/P&gt;</description>
      <pubDate>Mon, 28 Sep 2020 18:23:57 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151441#M42441</guid>
      <dc:creator>Laya123</dc:creator>
      <dc:date>2020-09-28T18:23:57Z</dc:date>
    </item>
    <item>
      <title>Re: how to calculate duration for completed and interview and incomplete interview ?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151442#M42442</link>
      <description>&lt;P&gt;This &lt;EM&gt;might&lt;/EM&gt; work&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;yoursearchhere
| rex (?&amp;lt;surveyID&amp;gt;-R.*?GEN.*)\s)
| stats count by surveyID Queue
&lt;/CODE&gt;&lt;/PRE&gt;

&lt;P&gt;The big issue: if you really want to analyze this data in any depth, you need to define the fields in each log type. Here is some more information about creating/defining fields: &lt;A href="http://docs.splunk.com/Documentation/Splunk/latest/Knowledge/Aboutfields"&gt;About fields&lt;/A&gt;&lt;/P&gt;

&lt;P&gt;My example above created a temporary field called surveyID and used the Queue field that is defined within the log file itself. But this is unlikely to be all that you need...&lt;/P&gt;</description>
      <pubDate>Thu, 18 Dec 2014 23:06:05 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151442#M42442</guid>
      <dc:creator>lguinn2</dc:creator>
      <dc:date>2014-12-18T23:06:05Z</dc:date>
    </item>
    <item>
      <title>Re: how to calculate duration for completed and interview and incomplete interview ?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151443#M42443</link>
      <description>&lt;P&gt;Thank you so much for your response&lt;/P&gt;

&lt;P&gt;Regards&lt;/P&gt;</description>
      <pubDate>Fri, 19 Dec 2014 11:07:38 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-calculate-duration-for-completed-and-interview-and/m-p/151443#M42443</guid>
      <dc:creator>Laya123</dc:creator>
      <dc:date>2014-12-19T11:07:38Z</dc:date>
    </item>
  </channel>
</rss>

