Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Finding accounts with no activity last 3 weeks?

(0) ShareShare
ReportReport
Posted on by

Hello!

I am trying to make a advanced find to use in my dashboard but not really getting it to work. What I want to do is get a list with all accounts that havent had a case/phone call registered created last 3 weeks? Is this possible? I have tried to made an advanced search with Accounts > Cases (customer) Older than 3 weeks but that didnt really work :)

Anyone know how to do this?

Cheers,

*This post is locked for comments

  • Aiden Kaskela Profile Picture
    Aiden Kaskela 19,694 on at
    RE: Finding accounts with no activity last 3 weeks?

    Ryan,

    You're correct that there are a few issues with the add-on. The tool runs on the RetrieveMultiple event in CRM, and there are cases where that isn't used, such as in reports. Depending on your needs it might be perfect, might not do the job.

    Thanks,

     Aiden

  • Suggested answer
    Aiden Kaskela Profile Picture
    Aiden Kaskela 19,694 on at
    RE: Finding accounts with no activity last 3 weeks?

    Hi,

    It looks like you need to change your query to Case "Does Not Contain Data". Otherwise I think you're good to go.

    Compared to the screenshot here: www.cobalt.net/.../new-crm-intelligent-query-features-true-not-in-queries

    Thanks,

     Aiden

  • RE: Finding accounts with no activity last 3 weeks?

    Hi,

    I have tried this but not really got it to work. My advanced search looks like this:

    i.imgur.com/nsAGttZ.png

    But I want contacts / accounts that has not have gotten a case last 3 weeks. Now in my result I get many customers that has a case created after this as well. Ideas?

  • RE: Finding accounts with no activity last 3 weeks?

    Hi,

    I have tried this but not really got it to work. My advanced search looks like this:

    i.imgur.com/nsAGttZ.png

    But I want contacts / accounts that has not have gotten a case last 3 weeks. Now in my result I get many customers that has a case created after this as well. Ideas?

  • Ryan Maclean Profile Picture
    Ryan Maclean 3,070 on at
    RE: Finding accounts with no activity last 3 weeks?

    Intelligent Query is great, however I had issues with users being unable to log in to the mobile/tablet apps when we had it installed, so it's worth pointing that out - www.cobalt.net/crm-iq-known-issues-fixes-workarounds

  • RE: Finding accounts with no activity last 3 weeks?

    Think I got it now, thanks!

  • RE: Finding accounts with no activity last 3 weeks?

    Thanks for fast reply. I have downloaded the plugin but not really sure how to add the timeframe. For example, if I create a advanced search where case does not contain data. Cases does not contain data and not have a created case the last 3 weeks?

    Thanks!

  • Verified answer
    Aiden Kaskela Profile Picture
    Aiden Kaskela 19,694 on at
    RE: Finding accounts with no activity last 3 weeks?

    Hi,

    You can't do it out of the box, but there's a free add-on called Intelligent Query that will let you do it. Using the advanced find, you can look for things like accounts without an open case, etc.

    It's available from the App Source at appsource.microsoft.com/.../cobalt.369337d7-2c59-4a6c-bcd5-529cf74d93e1

    or if you can't install from App Source, directly from Cobalt at www.cobalt.net/.../cobaltintelligentquery

    Hope this helps! I'd appreciate if you'd mark this as Answering your question.

    Thanks,

     Aiden

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans