You can easily filter out the login/logout events from the active audit log and have only users performing real work in CM.

Hi Sander,

Yes, but I wondered if there was a way to see who is not using it, I guess if I ran a report on all audit events and then export that excel and then also then export all my active users to excel and the run a compare formula so that I can match current users doing things then those with no match would be the ones not using CM.

I had just hoped that there was an easier way within CM.

Cheers

Shell

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...

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

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.

Thanks for that Mike, at least I now know it can be done....