Finder Users not using CM

Hi All,

I am trying to run a report that will show me users that have not used CM for the last 12 months.  This will allow me to take back licences.  I have tried searching utilising the Active Audit Events, but as we have the integration with MS Office, even if a user does not open CM it will register them as having logged in if they open a MS Office Application.

Just wondering if anyone can provide some info on how to search for this information.

Thanks

Shell

Parents
  • Actually doing this right now...

    I'm running a search for locations that have an active login - pasting that data in to CM.

    I'm very running a search by locations with a latest login date (i'm using 'this year') and pasting that information in to Excel.

    I'm then using excel to look for duplicate data in my two columns - what isn't a duplicate is most likely an inactive user.

  • Hi Strider,

    The issue with doing it that for me is that, if a user has CM but do not use it but are using integrated MS Office applications then an login audit event will be created against them.

    Cheers

    Shell

  • Hmm, we don't have that issue - if they have a CM login then they should be using it... Slight smile

  • Yes they should be using it, but are they?  That is what I want to find out.

  • Suggested Answer

    We have a customer that requested a similar requirement. I developed a simple utility (using the .NET SDK) which would generate a report based on certain criteria:

    Generally, they just use the 'Any Activity' option which covers the other 3 options as well as any other events such as login/logout. It uses the online Audit Logs as the source data. It searches based on the currently active users.

    At the end, a report is generated, and they can verify the output to see that it is correct if they want to. They can edit the report to remove any users they don't want to deactivate.

    When they are happy to process the deactivations, they use the report as an input to a second custom tool that will then deactivate the users.

    They run this process every so often. Yes, occasionally there may be a case where a user is mistakenly deactivated (e.g. someone is on long term leave), but then a quick call to their internal service desk will get them reactivated.

    They also have tools that will act on reports generated daily by their HR system that indicates when users join or leave their organisation, and that goes into another custom tool that will also create/activate/deactivate users accordingly.

    Cheers,

    Mike.

Reply
  • Suggested Answer

    We have a customer that requested a similar requirement. I developed a simple utility (using the .NET SDK) which would generate a report based on certain criteria:

    Generally, they just use the 'Any Activity' option which covers the other 3 options as well as any other events such as login/logout. It uses the online Audit Logs as the source data. It searches based on the currently active users.

    At the end, a report is generated, and they can verify the output to see that it is correct if they want to. They can edit the report to remove any users they don't want to deactivate.

    When they are happy to process the deactivations, they use the report as an input to a second custom tool that will then deactivate the users.

    They run this process every so often. Yes, occasionally there may be a case where a user is mistakenly deactivated (e.g. someone is on long term leave), but then a quick call to their internal service desk will get them reactivated.

    They also have tools that will act on reports generated daily by their HR system that indicates when users join or leave their organisation, and that goes into another custom tool that will also create/activate/deactivate users accordingly.

    Cheers,

    Mike.

Children