Vice Admiral
Vice Admiral
587 views

Leveraging admin console user info for reports.

Is there a way to leverage the user information available from the admin console to generate reports?

Specifically, I'd like to be able to generate a report that lists the last login times for users.
The information is there, but requires you to look at each user profile individually.
It'd be real convenient to be able to export that type of info for all users accounts to a CSV file.

We've just set up Mobility service and, unfortunately, have a lot of accounts for former employees.
I'd like to avoid adding those users to mobility without having to check each-and-every account in the system.
Labels (1)
0 Likes
4 Replies
Absent Member.
Absent Member.


curl -k --user gwadmin:password https://10.10.10.10:9710/gwadmin-service/list/user.csv?attrs=givenName,surname,lastClientLoginTime > login-report.csv



You could add additional attributes after the attrs=



Or if you want all attributes:



curl -k --user gwadmin:password https://10.10.10.10:9710/gwadmin-service/list/user.csv > user-details.csv



--Morris




>>> gathagan<gathagan@no-mx.forums.novell.com> 3/12/2015 3:16 PM >>>




Is there a way to leverage the user information available from the admin
console to generate reports?

Specifically, I'd like to be able to generate a report that lists the
last login times for users.
The information is there, but requires you to look at each user profile
individually.
It'd be real convenient to be able to export that type of info for all
users accounts to a CSV file.

We've just set up Mobility service and, unfortunately, have a lot of
accounts for former employees.
I'd like to avoid adding those users to mobility without having to check
each-and-every account in the system.


--
gathagan
------------------------------------------------------------------------
gathagan's Profile: https://forums.novell.com/member.php?userid=11060
View this thread: https://forums.novell.com/showthread.php?t=482367
0 Likes
Vice Admiral
Vice Admiral

Thanks, Morris!
That worked great.
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

In article <gathagan.6tntgo@no-mx.forums.novell.com>, Gathagan wrote:
> Is there a way to leverage the user information available from the admin
> console to generate reports?


In addition to what Morris posted there is a report that can be run
regularly that does this. It is the Audit report that can be done
manually or better yet have run weekly as it updates user mailbox sizes
seen elsewhere.


In the admin console, select the PO in question

For manual report; Maintenance, Mailbox/Library Maintenance, Maintenance
on PostOffice.
- select "Audit Report" - Logging Tab I, set to Audit.log, Results to the
most appropriate admin

For scheduled reporting; select the Post Office Agent, Scheduled Events,
Create(New) "Weekly Audit and size update", type Mailbox/Library
Maintenance
- Trigger of Weekday, Monday early AM, after your backup and the previous
job are finished and before the users come in.
- Create... event "Audit size updates"
- select "Audit Report" - Logging Tab I, set to Audit.log, Results to the
most appropriate admin



Andy of
http://KonecnyConsulting.ca in Toronto
Knowledge Partner
http://forums.novell.com/member.php/75037-konecnya
If you find a post helpful and are logged in the Web interface, please
show your appreciation by clicking on the star below. Thanks!

___
“i’ve sworn an oath of solitude til the blight is purged from these lands”
Andy of Konecny Consulting in Toronto
Knowledge Partner Profile
If you find a post helpful, click the Like button below. Thanks!
0 Likes
Absent Member.
Absent Member.


Good point Andy, in fact the audit report needs to be run to update the last login time attribute that he is looking for.



--Morris



>>> Andy Konecny<konecnya@no-mx.forums.novell.com> 3/14/2015 8:42 PM >>>



In article <gathagan.6tntgo@no-mx.forums.novell.com>, Gathagan wrote:

> Is there a way to leverage the user information available from the admin
> console to generate reports?


In addition to what Morris posted there is a report that can be run
regularly that does this. It is the Audit report that can be done
manually or better yet have run weekly as it updates user mailbox sizes
seen elsewhere.


In the admin console, select the PO in question

For manual report; Maintenance, Mailbox/Library Maintenance, Maintenance
on PostOffice.
- select "Audit Report" - Logging Tab I, set to Audit.log, Results to the
most appropriate admin

For scheduled reporting; select the Post Office Agent, Scheduled Events,
Create(New) "Weekly Audit and size update", type Mailbox/Library
Maintenance
- Trigger of Weekday, Monday early AM, after your backup and the previous
job are finished and before the users come in.
- Create... event "Audit size updates"
- select "Audit Report" - Logging Tab I, set to Audit.log, Results to the
most appropriate admin



Andy of
http://KonecnyConsulting.ca in Toronto
Knowledge Partner
http://forums.novell.com/member.php/75037-konecnya
If you find a post helpful and are logged in the Web interface, please
show your appreciation by clicking on the star below. Thanks!
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.