RE: [EXTERNAL] Re: Reporting on Incidents that have re-opened
Thanks Dustin, I appreciate the input. We did think about that same thing. It will work moving forward but doesn’t help with past Incidents. Right now we are trying to get a percentage of incidents that were re-opened for the past year. Todd From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Fawver, Dustin Sent: Friday, February 09, 2018 11:04 AM To: ARSList Subject: RE: [EXTERNAL] Re: Reporting on Incidents that have re-opened I was also thinking of a filter that could do it on Modify, depending on how you want to be notified. Maybe an email or a message. Have the Run If clause of: (‘DB.Status’ = “Resolved”) AND (‘TR.Status’ < “Resolved”) I’m just using regular ARS 9.1.2, if that plays any part in how things are set up. I hope this helps. Dustin Fawver Sr. Help Desk Technician Information Technology Services P: 423-439-4648 itsh...@etsu.edu<mailto:itsh...@etsu.edu> [itslogo]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.etsu.edu_helpdesk=DwMGaQ=1Bxv1FLhNT7kWd-TXJNAbxBgVXw_rHZTiwmA6CMJ1Y8=J9onmqKuX2jklKZmtUKMUg=9MlKCzkoOIOtjk3FpkfhxMs6Qc3vo1tUQRFPRpDnvhA=o-st8I4u7SXz9K3jW8yV9n5ofVGbLHko7sJfnWL6Q1c=> From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: Friday, February 09, 2018 11:47 AM To: ARSList <arslist@arslist.org<mailto:arslist@arslist.org>> Subject: [EXTERNAL] Re: Reporting on Incidents that have re-opened *** This email does NOT originate from an ETSU person or service. *** Todd, How about something a bit more novel. Look for records that have a Resolved Status history Date/User who's status is < Resolved On Fri, Feb 9, 2018 at 8:55 AM, Arner, Todd <tar...@glhec.org<mailto:tar...@glhec.org>> wrote: Hi Crystal, Thanks for the help. We are still seeing at least one Incident that has been re-opened that does not have a date in the re-opened date field. Have you ran into any issues like that? The re-open date field definitely looks more useful the Kick_Back Count field. Thanks, Todd From: ARSList [mailto:arslist-boun...@arslist.org<mailto:arslist-boun...@arslist.org>] On Behalf Of CRENSHAW, CRYSTAL Sent: Friday, February 09, 2018 8:48 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: RE: Reporting on Incidents that have re-opened Todd, There is a hidden field on HPD:Help Desk called ‘Re-Opened Date’. If that field has a vaule, then it has been reopened at least once. This is a query for active Incidents that have been previously resolved: 'Re-Opened Date' != $NULL$ AND 'Status*' < "Resolved" Hope that helps. Thanks, Crystal Crenshaw Service Management Senior Systems Analyst Project Services – Service Management (919)508-0546<tel:(919)%20508-0546> [cid:image002.gif@01D3A1AF.F60185C0] From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Arner, Todd Sent: Friday, February 09, 2018 9:14 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Reporting on Incidents that have re-opened Wondering if anyone can help us figure out how to query for Incidents that have been re-opened. We thought we could do this by using the Kick_Back Count field but it seems to reset the count after the Incident is closed and we also get strange results were incidents we would expect to match the query do not. Anyway, wondering if anyone has a better way to find incidents that have been re-opened. We are using version 9.1.3. Basically we want to run a query against all incidents that will list any that have been resolved and then moved back to an active status. I appreciate any tips you can provide. ☺ Todd Arner Systems Administrator III Great Lakes Educational Loan Services, Inc. The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org<mailto:no...@glhec.org> immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this
Re: Reporting on Incidents that have re-opened
that's the only problem with status history, you only get the 'last' time something happened, so if it was reopened, then re-closed, you loose that data...so you wouldn't be able to use thatso, workflow is the best way to do that, as was suggested before db.status = resolved and status < resolved, set a flag, increment a value, etcI thought something similar to that already existed, but it might not in the version you are using. On Fri, Feb 9, 2018 at 12:06 PM, Arner, Todd <tar...@glhec.org> wrote: > Hi LJ, > > Thanks for your response but I am not following what you mean. Could you > provide more detail? > > > > Thanks, > > Todd > > > > *From:* ARSList [mailto:arslist-boun...@arslist.org] *On Behalf Of *LJ > LongWing > *Sent:* Friday, February 09, 2018 10:47 AM > *To:* ARSList > *Subject:* Re: Reporting on Incidents that have re-opened > > > > Todd, > > How about something a bit more novel. Look for records that have a > Resolved Status history Date/User who's status is < Resolved > > > > On Fri, Feb 9, 2018 at 8:55 AM, Arner, Todd <tar...@glhec.org> wrote: > > Hi Crystal, > > Thanks for the help. We are still seeing at least one Incident that has > been re-opened that does not have a date in the re-opened date field. > Have you ran into any issues like that? The re-open date field definitely > looks more useful the Kick_Back Count field. > > > > Thanks, > > Todd > > > > *From:* ARSList [mailto:arslist-boun...@arslist.org] *On Behalf Of *CRENSHAW, > CRYSTAL > *Sent:* Friday, February 09, 2018 8:48 AM > *To:* arslist@ARSLIST.ORG > *Subject:* RE: Reporting on Incidents that have re-opened > > > > Todd, > > > > There is a hidden field on HPD:Help Desk called ‘Re-Opened Date’. If that > field has a vaule, then it has been reopened at least once. > > > > > > This is a query for active Incidents that have been previously resolved: > > > > 'Re-Opened Date' != $NULL$ AND 'Status*' < "Resolved" > > > > Hope that helps. > > > > > > Thanks, > > > > Crystal Crenshaw > > Service Management Senior Systems Analyst > > Project Services – Service Management > > (919)508-0546 <(919)%20508-0546> > > > > > > *From:* ARSList [mailto:arslist-boun...@arslist.org > <arslist-boun...@arslist.org>] *On Behalf Of *Arner, Todd > *Sent:* Friday, February 09, 2018 9:14 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Reporting on Incidents that have re-opened > > > > Wondering if anyone can help us figure out how to query for Incidents that > have been re-opened. We thought we could do this by using the Kick_Back > Count field but it seems to reset the count after the Incident is closed > and we also get strange results were incidents we would expect to match the > query do not. Anyway, wondering if anyone has a better way to find > incidents that have been re-opened. We are using version 9.1.3. Basically > we want to run a query against all incidents that will list any that have > been resolved and then moved back to an active status. I appreciate any > tips you can provide. J > > > > Todd Arner > > Systems Administrator III > > Great Lakes Educational Loan Services, Inc. > > > -- > > The information contained in this communication may be confidential, is > intended only for the use of the recipient(s) named above, and may be > protected under state or federal law. If the reader of this message is not > the intended recipient, you are hereby notified that any dissemination, > distribution, or copying of this communication, or any of its contents, is > strictly prohibited. If you have received this communication in error, > please forward the communication to no...@glhec.org immediately and > destroy or delete the original message and any copy of it from your > computer system. If you have any questions concerning this message, please > contact the sender. > > This email may contain confidential and privileged material for the sole > use of the intended recipient. If you are not the intended recipient, > please contact the sender and delete all copies. Any review or distribution > by others is strictly prohibited. Personal emails are restricted by policy > of the State Employees' Credit Union (SECU). Therefore SECU specifically > disclaims any responsibility or liability for any personal information or > opinions of the author expressed in this email. > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist=DwMFaQ=1Bxv1FLhNT7kWd-TXJNAbxBgVXw_rHZTiwmA6CMJ1Y8=J9onmqKuX2jklKZmtUKMUg=JvzU9e9VAeFxxATwU-RPauCho8zEqB9nvokqsfkEp2I=70OBGHgOvW-FdgFHB3hUtOwaVC7MiauEjLR0C7OXpNQ=> > > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: Reporting on Incidents that have re-opened
LJ, I think I understand what you are getting at but that will only solve the query for those incidents that are still open. How can we find out if a Closed incident was re-opened during its life? Thanks, Todd From: Arner, Todd Sent: Friday, February 09, 2018 1:06 PM To: 'ARSList' Subject: RE: Reporting on Incidents that have re-opened Hi LJ, Thanks for your response but I am not following what you mean. Could you provide more detail? Thanks, Todd From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: Friday, February 09, 2018 10:47 AM To: ARSList Subject: Re: Reporting on Incidents that have re-opened Todd, How about something a bit more novel. Look for records that have a Resolved Status history Date/User who's status is < Resolved On Fri, Feb 9, 2018 at 8:55 AM, Arner, Todd <tar...@glhec.org<mailto:tar...@glhec.org>> wrote: Hi Crystal, Thanks for the help. We are still seeing at least one Incident that has been re-opened that does not have a date in the re-opened date field. Have you ran into any issues like that? The re-open date field definitely looks more useful the Kick_Back Count field. Thanks, Todd From: ARSList [mailto:arslist-boun...@arslist.org<mailto:arslist-boun...@arslist.org>] On Behalf Of CRENSHAW, CRYSTAL Sent: Friday, February 09, 2018 8:48 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: RE: Reporting on Incidents that have re-opened Todd, There is a hidden field on HPD:Help Desk called ‘Re-Opened Date’. If that field has a vaule, then it has been reopened at least once. This is a query for active Incidents that have been previously resolved: 'Re-Opened Date' != $NULL$ AND 'Status*' < "Resolved" Hope that helps. Thanks, Crystal Crenshaw Service Management Senior Systems Analyst Project Services – Service Management (919)508-0546<tel:(919)%20508-0546> [cid:image001.gif@01D3A1A7.F1F67E70] From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Arner, Todd Sent: Friday, February 09, 2018 9:14 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Reporting on Incidents that have re-opened Wondering if anyone can help us figure out how to query for Incidents that have been re-opened. We thought we could do this by using the Kick_Back Count field but it seems to reset the count after the Incident is closed and we also get strange results were incidents we would expect to match the query do not. Anyway, wondering if anyone has a better way to find incidents that have been re-opened. We are using version 9.1.3. Basically we want to run a query against all incidents that will list any that have been resolved and then moved back to an active status. I appreciate any tips you can provide. ☺ Todd Arner Systems Administrator III Great Lakes Educational Loan Services, Inc. The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org<mailto:no...@glhec.org> immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email. -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist=DwMFaQ=1Bxv1FLhNT7kWd-TXJNAbxBgVXw_rHZTiwmA6CMJ1Y8=J9onmqKuX2jklKZmtUKMUg=JvzU9e9VAeFxxATwU-RPauCho8zEqB9nvokqsfkEp2I=70OBGHgOvW-FdgFHB3hUtOwaVC7MiauEjLR0C7OXpNQ=> -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: Reporting on Incidents that have re-opened
Hi LJ, Thanks for your response but I am not following what you mean. Could you provide more detail? Thanks, Todd From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: Friday, February 09, 2018 10:47 AM To: ARSList Subject: Re: Reporting on Incidents that have re-opened Todd, How about something a bit more novel. Look for records that have a Resolved Status history Date/User who's status is < Resolved On Fri, Feb 9, 2018 at 8:55 AM, Arner, Todd <tar...@glhec.org<mailto:tar...@glhec.org>> wrote: Hi Crystal, Thanks for the help. We are still seeing at least one Incident that has been re-opened that does not have a date in the re-opened date field. Have you ran into any issues like that? The re-open date field definitely looks more useful the Kick_Back Count field. Thanks, Todd From: ARSList [mailto:arslist-boun...@arslist.org<mailto:arslist-boun...@arslist.org>] On Behalf Of CRENSHAW, CRYSTAL Sent: Friday, February 09, 2018 8:48 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: RE: Reporting on Incidents that have re-opened Todd, There is a hidden field on HPD:Help Desk called ‘Re-Opened Date’. If that field has a vaule, then it has been reopened at least once. This is a query for active Incidents that have been previously resolved: 'Re-Opened Date' != $NULL$ AND 'Status*' < "Resolved" Hope that helps. Thanks, Crystal Crenshaw Service Management Senior Systems Analyst Project Services – Service Management (919)508-0546<tel:(919)%20508-0546> [cid:image001.gif@01D3A1A6.C4BB03F0] From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Arner, Todd Sent: Friday, February 09, 2018 9:14 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Reporting on Incidents that have re-opened Wondering if anyone can help us figure out how to query for Incidents that have been re-opened. We thought we could do this by using the Kick_Back Count field but it seems to reset the count after the Incident is closed and we also get strange results were incidents we would expect to match the query do not. Anyway, wondering if anyone has a better way to find incidents that have been re-opened. We are using version 9.1.3. Basically we want to run a query against all incidents that will list any that have been resolved and then moved back to an active status. I appreciate any tips you can provide. ☺ Todd Arner Systems Administrator III Great Lakes Educational Loan Services, Inc. The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org<mailto:no...@glhec.org> immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email. -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist=DwMFaQ=1Bxv1FLhNT7kWd-TXJNAbxBgVXw_rHZTiwmA6CMJ1Y8=J9onmqKuX2jklKZmtUKMUg=JvzU9e9VAeFxxATwU-RPauCho8zEqB9nvokqsfkEp2I=70OBGHgOvW-FdgFHB3hUtOwaVC7MiauEjLR0C7OXpNQ=> -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: [EXTERNAL] Re: Reporting on Incidents that have re-opened
I was also thinking of a filter that could do it on Modify, depending on how you want to be notified. Maybe an email or a message. Have the Run If clause of: (‘DB.Status’ = “Resolved”) AND (‘TR.Status’ < “Resolved”) I’m just using regular ARS 9.1.2, if that plays any part in how things are set up. I hope this helps. Dustin Fawver Sr. Help Desk Technician Information Technology Services P: 423-439-4648 itsh...@etsu.edu [itslogo]<http://www.etsu.edu/helpdesk> From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: Friday, February 09, 2018 11:47 AM To: ARSList <arslist@arslist.org> Subject: [EXTERNAL] Re: Reporting on Incidents that have re-opened *** This email does NOT originate from an ETSU person or service. *** Todd, How about something a bit more novel. Look for records that have a Resolved Status history Date/User who's status is < Resolved On Fri, Feb 9, 2018 at 8:55 AM, Arner, Todd <tar...@glhec.org<mailto:tar...@glhec.org>> wrote: Hi Crystal, Thanks for the help. We are still seeing at least one Incident that has been re-opened that does not have a date in the re-opened date field. Have you ran into any issues like that? The re-open date field definitely looks more useful the Kick_Back Count field. Thanks, Todd From: ARSList [mailto:arslist-boun...@arslist.org<mailto:arslist-boun...@arslist.org>] On Behalf Of CRENSHAW, CRYSTAL Sent: Friday, February 09, 2018 8:48 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: RE: Reporting on Incidents that have re-opened Todd, There is a hidden field on HPD:Help Desk called ‘Re-Opened Date’. If that field has a vaule, then it has been reopened at least once. This is a query for active Incidents that have been previously resolved: 'Re-Opened Date' != $NULL$ AND 'Status*' < "Resolved" Hope that helps. Thanks, Crystal Crenshaw Service Management Senior Systems Analyst Project Services – Service Management (919)508-0546<tel:(919)%20508-0546> [cid:image003.gif@01D3A19E.13860010] From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Arner, Todd Sent: Friday, February 09, 2018 9:14 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Reporting on Incidents that have re-opened Wondering if anyone can help us figure out how to query for Incidents that have been re-opened. We thought we could do this by using the Kick_Back Count field but it seems to reset the count after the Incident is closed and we also get strange results were incidents we would expect to match the query do not. Anyway, wondering if anyone has a better way to find incidents that have been re-opened. We are using version 9.1.3. Basically we want to run a query against all incidents that will list any that have been resolved and then moved back to an active status. I appreciate any tips you can provide. ☺ Todd Arner Systems Administrator III Great Lakes Educational Loan Services, Inc. The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org<mailto:no...@glhec.org> immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email. -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://linkprotect.cudasvc.com/url?a=https://mailman.rrr.se/cgi/listinfo/arslist=E,1,CjhwCvr2BsiMXuPdbK1gJ5z4a6HzgHiRVzjZEDZogV6vGmqY_VHzizvp7no6_-mve7s3ZCKdJSLfTEXDcpb1_hASbY4ntUzXpuG8tXGRrw,,=1> -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Reporting on Incidents that have re-opened
Todd, How about something a bit more novel. Look for records that have a Resolved Status history Date/User who's status is < Resolved On Fri, Feb 9, 2018 at 8:55 AM, Arner, Todd <tar...@glhec.org> wrote: > Hi Crystal, > > Thanks for the help. We are still seeing at least one Incident that has > been re-opened that does not have a date in the re-opened date field. > Have you ran into any issues like that? The re-open date field definitely > looks more useful the Kick_Back Count field. > > > > Thanks, > > Todd > > > > *From:* ARSList [mailto:arslist-boun...@arslist.org] *On Behalf Of *CRENSHAW, > CRYSTAL > *Sent:* Friday, February 09, 2018 8:48 AM > *To:* arslist@ARSLIST.ORG > *Subject:* RE: Reporting on Incidents that have re-opened > > > > Todd, > > > > There is a hidden field on HPD:Help Desk called ‘Re-Opened Date’. If that > field has a vaule, then it has been reopened at least once. > > > > > > This is a query for active Incidents that have been previously resolved: > > > > 'Re-Opened Date' != $NULL$ AND 'Status*' < "Resolved" > > > > Hope that helps. > > > > > > Thanks, > > > > Crystal Crenshaw > > Service Management Senior Systems Analyst > > Project Services – Service Management > > (919)508-0546 <(919)%20508-0546> > > > > > > *From:* ARSList [mailto:arslist-boun...@arslist.org > <arslist-boun...@arslist.org>] *On Behalf Of *Arner, Todd > *Sent:* Friday, February 09, 2018 9:14 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Reporting on Incidents that have re-opened > > > > Wondering if anyone can help us figure out how to query for Incidents that > have been re-opened. We thought we could do this by using the Kick_Back > Count field but it seems to reset the count after the Incident is closed > and we also get strange results were incidents we would expect to match the > query do not. Anyway, wondering if anyone has a better way to find > incidents that have been re-opened. We are using version 9.1.3. Basically > we want to run a query against all incidents that will list any that have > been resolved and then moved back to an active status. I appreciate any > tips you can provide. J > > > > Todd Arner > > Systems Administrator III > > Great Lakes Educational Loan Services, Inc. > > > -- > > The information contained in this communication may be confidential, is > intended only for the use of the recipient(s) named above, and may be > protected under state or federal law. If the reader of this message is not > the intended recipient, you are hereby notified that any dissemination, > distribution, or copying of this communication, or any of its contents, is > strictly prohibited. If you have received this communication in error, > please forward the communication to no...@glhec.org immediately and > destroy or delete the original message and any copy of it from your > computer system. If you have any questions concerning this message, please > contact the sender. > > This email may contain confidential and privileged material for the sole > use of the intended recipient. If you are not the intended recipient, > please contact the sender and delete all copies. Any review or distribution > by others is strictly prohibited. Personal emails are restricted by policy > of the State Employees' Credit Union (SECU). Therefore SECU specifically > disclaims any responsibility or liability for any personal information or > opinions of the author expressed in this email. > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: Reporting on Incidents that have re-opened
Hi Crystal, Thanks for the help. We are still seeing at least one Incident that has been re-opened that does not have a date in the re-opened date field. Have you ran into any issues like that? The re-open date field definitely looks more useful the Kick_Back Count field. Thanks, Todd From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of CRENSHAW, CRYSTAL Sent: Friday, February 09, 2018 8:48 AM To: arslist@ARSLIST.ORG Subject: RE: Reporting on Incidents that have re-opened Todd, There is a hidden field on HPD:Help Desk called 'Re-Opened Date'. If that field has a vaule, then it has been reopened at least once. This is a query for active Incidents that have been previously resolved: 'Re-Opened Date' != $NULL$ AND 'Status*' < "Resolved" Hope that helps. Thanks, Crystal Crenshaw Service Management Senior Systems Analyst Project Services - Service Management (919)508-0546 [cid:image001.gif@01D3A18B.F21AB900] From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Arner, Todd Sent: Friday, February 09, 2018 9:14 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Reporting on Incidents that have re-opened Wondering if anyone can help us figure out how to query for Incidents that have been re-opened. We thought we could do this by using the Kick_Back Count field but it seems to reset the count after the Incident is closed and we also get strange results were incidents we would expect to match the query do not. Anyway, wondering if anyone has a better way to find incidents that have been re-opened. We are using version 9.1.3. Basically we want to run a query against all incidents that will list any that have been resolved and then moved back to an active status. I appreciate any tips you can provide. :) Todd Arner Systems Administrator III Great Lakes Educational Loan Services, Inc. The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org<mailto:no...@glhec.org> immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email. -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: Reporting on Incidents that have re-opened
Todd, There is a hidden field on HPD:Help Desk called 'Re-Opened Date'. If that field has a vaule, then it has been reopened at least once. This is a query for active Incidents that have been previously resolved: 'Re-Opened Date' != $NULL$ AND 'Status*' < "Resolved" Hope that helps. Thanks, Crystal Crenshaw Service Management Senior Systems Analyst Project Services - Service Management (919)508-0546 [cid:image001.gif@01D3A18A.C18A6E30] From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Arner, Todd Sent: Friday, February 09, 2018 9:14 AM To: arslist@ARSLIST.ORG Subject: Reporting on Incidents that have re-opened Wondering if anyone can help us figure out how to query for Incidents that have been re-opened. We thought we could do this by using the Kick_Back Count field but it seems to reset the count after the Incident is closed and we also get strange results were incidents we would expect to match the query do not. Anyway, wondering if anyone has a better way to find incidents that have been re-opened. We are using version 9.1.3. Basically we want to run a query against all incidents that will list any that have been resolved and then moved back to an active status. I appreciate any tips you can provide. :) Todd Arner Systems Administrator III Great Lakes Educational Loan Services, Inc. The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org<mailto:no...@glhec.org> immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email. -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Reporting on Incidents that have re-opened
Wondering if anyone can help us figure out how to query for Incidents that have been re-opened. We thought we could do this by using the Kick_Back Count field but it seems to reset the count after the Incident is closed and we also get strange results were incidents we would expect to match the query do not. Anyway, wondering if anyone has a better way to find incidents that have been re-opened. We are using version 9.1.3. Basically we want to run a query against all incidents that will list any that have been resolved and then moved back to an active status. I appreciate any tips you can provide. :) Todd Arner Systems Administrator III Great Lakes Educational Loan Services, Inc. -- The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist