ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins. Read more for important details.
ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins.Read more for important details.
Absent Member.
Absent Member.
790 views

Groupwise ad-hoc reports

In previous versions of GW I was able to use the eDir ODBC connectors to create adhoc reports.
For example I routinely delete unused accounts, I send a notice to the users and give them 2 weeks to login to the account or else it is expired and eventually deleted.

I have created a spreadsheet that queries the database and lists expired users and their last login date.
this way I can monitor the accounts I have expired and re-enable them if they have signed into their accounts.

Is there a way to create this type of reporting direct against GroupWise 2014?
Labels (1)
0 Likes
5 Replies
Absent Member.
Absent Member.


Pretty simple using the GW2014 REST API. To get what you are looking for in your example, you can run this command:




curl -k --user admin:novell "https://151.155.136.215:9710/gwadmin-service/list/user.csv?filter=expirationDate%20ne%20null&attrs=name,domain,postoffice,expirationDate,lastClientLoginTime"




it's out put would be like:



name,domain,postoffice,expirationDate,lastClientLoginTime
acquelineJoseph,Montana,Butte,2016-08-08T00:00:00,
AdrianHancock,Idaho,Boise,2016-08-12T00:00:00,2016-07-29T14:12:23
BaigorriaR-C,Arizona,Mesa,2016-05-05T09:17:44,




if .../list/user.csv?filter= were changed to /list/user?filter=... the output would be in XML format



To get more info on the REST API:



https://www.novell.com/documentation/groupwise2014r2/pdfdoc/gwsdk_gwadminweb/gwsdk_gwadminweb.pdf



--Morris




>>> candaced<candaced@no-mx.forums.microfocus.com> 8/17/2016 8:06 AM >>>







In previous versions of GW I was able to use the eDir ODBC connectors to

create adhoc reports.

For example I routinely delete unused accounts, I send a notice to the

users and give them 2 weeks to login to the account or else it is

expired and eventually deleted.




I have created a spreadsheet that queries the database and lists expired

users and their last login date.

this way I can monitor the accounts I have expired and re-enable them if

they have signed into their accounts.




Is there a way to create this type of reporting direct against GroupWise

2014?







--

candaced

------------------------------------------------------------------------
candaced's Profile: https://forums.novell.com/member.php?userid=285


View this thread: https://forums.novell.com/showthread.php?t=499919
0 Likes
Absent Member.
Absent Member.

Thanks for the amazingly quick response.
That works, with great samples in the sdk doc.

but your reply was better because it showed me how to get the results comma delimited instead of xml.
0 Likes
Absent Member.
Absent Member.

This morning I need to create a list of users who are above the 80% threshold of their mailboxes. Most of my users are set with a limit at the post_office level, but some are ste

From the SDK manual I found that the boxSizeLimit is in clientoptions not user where the rest of the info I wanted before is.

I extrapolated from the example, with this

curl -k admin:novell "https://localhost:9999/gwadmin-service/domains/testDom1/postoffices/testPO1/users/testUser1/clientoptions?attrs=boxSize.csvLimit,boxSizeWarningThreshold"

But I would really like to have csv, and this does not work

curl -k admin:novell "https://localhost:9999/gwadmin-service/domains/testDom1/postoffices/testPO1/users/testUser1/clientoptions.csv?attrs=boxSize.csvLimit,boxSizeWarningThreshold"

How do you go about doing the join? I understand that this curl commands and not strictly GW, can you point me to a good resource to be using.
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

In article <candaced.7knoyn@no-mx.forums.microfocus.com>, Candaced wrote:
> But I would really like to have csv, and this does not work
>
> curl -k admin:novell
> "https://localhost:9999/gwadmin-

service/domains/testDom1/postoffices/testPO1/users/testUser1/clientoptions.csv?
attrs=boxSize.csvLimit,boxSizeWarningThreshold"

so far in my investigations, it looks like we can only go straight to csv that way
for lists of Domains, User, Groups, Resource, & Nicknames.

What I think we need to do to extract any of those clientoptions in any list is to
do some programming to check each user and extract the boxSizeLimit from the
resulting xml/JASON output.
I think the logic flow would be along the lines of a first pull of
https://10.0.0.36:9710/gwadmin-service/list/user.csv?attrs=domain,postoffice,name
then process each line to get it's clientoptions and output it all to a new csv.

For some great examples of this sort of thing, see
https://www.novell.com/communities/coolsolutions/groupwise-administration-rest-
curl-webinar-posted/

if anyone does write such a script, do share for those of us who haven't had the
time to do it yet and would be very grateful for it.


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
Knowledge Partner Knowledge Partner
Knowledge Partner

In article <candaced.7knoyn@no-mx.forums.microfocus.com>, Candaced
wrote:
> "https://localhost:9999/gwadmin-service...


Note that port 9999 was in the beta, most production systems will be
using port 9710 such as
https://localhost:9710/gwadmin-service...

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