CA Service Management

 View Only
  • 1.  Find Contacts Recently Updated

    Posted Aug 01, 2024 11:17 AM

    Is there a way to search for Contacts recently updated (within past week or month) by a specific user?

    I would like to do this by going to Search > Contacts and then entering a specific user and date into the Additional Search Arguments field since the fields (last modified by and last modified date) do not exist on the search page.

    I have tried several queries but neither work.

    last_mod_by = 'itpamuser' AND last_mod_dt > StartAtTime(\'LAST_MONTH\')

    last_mod_by = 'itpamuser' AND last_mod_dt > '07/01/2024'

    last_mod_by = 'itpamuser' AND last_mod_dt > '07/01/2024 00:05:00'

    thank you

    TheKatherine



  • 2.  RE: Find Contacts Recently Updated

    Broadcom Employee
    Posted Aug 02, 2024 01:07 AM

    Hi Katherine,

     

    Try the query as: 

    last_mod_by ='ServiceDesk' AND last_mod_dt  > StartAtTime (  'TODAY' )

    last_mod_by ='ServiceDesk' AND last_mod_dt  > StartAtTime (  'LAST_MONTH' )       --> change the username as per your requirement. 

    Below is the sample screeenshot with result. 

    Thanks & Regards,

    Hema.




  • 3.  RE: Find Contacts Recently Updated

    Broadcom Employee
    Posted Aug 02, 2024 01:11 AM

    You can as well try with timestamp in the unix timestamp.

    Example: ((  last_mod_by ='ServiceDesk' AND )  && ( last_mod_dt  > 1722537000 ))  

    Note: 1722537000 is 1st August 2024.




  • 4.  RE: Find Contacts Recently Updated

    Posted Aug 02, 2024 07:17 AM

    Thank you so much, I was able to use your suggestion successfully.

    TheKatherine