Groupwise ad-hoc reports

[candaced]

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?

[Anonymous_User]

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

[candaced]

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.

[candaced]

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.

[KonecnyA]

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!

[KonecnyA]

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!