Console Users, account activity, and Actions

Reporting
1

(imported topic written by SystemAdmin)

I’m trying to get a report created that will pull all of the console users, the last time they accessed their account, and also the number of actions they’ve done as a CO.

I’ve not been able to find anything that already exists like this, can someone give me a push in the right direction?

thanks,

Baraq

2

(imported comment written by SystemAdmin)

(names of it, last login times of it, actions of it) of bes users

This is what I have so far and is bringing me back part of what I need. I’d like to be able to bring back actions in a period of time, say 6 months. Also I need to be able to find console users that have never logged in before.

any ideas?

I know these are probably newbie questions so thanks in advance for the help.

B

3

(imported comment written by jeremylam)

You can use a whose clause to further narrow down the number of actions:

(names of it, last login times of it, number of issued actions whose (time issued of it > (now - (30 * day))) of it) of bes users

Note that “month” is not a valid time interval because it’s not consistent; you’ll have to select a specific number of days (either 29, 30, or 31) to approximate 6 months.

4

(imported comment written by SystemAdmin)

Thanks Jeremy that’s the push I needed!!

-Baraq

5

(imported comment written by NoahSalzman)

I personally think that 182 is a better number to approximate six months… but that’s just me. :slight_smile: