Cool Solutions

ZENworks Asset Management Web Software Usage Report


March 24, 2008 11:37 am





By Mark Puttick

Problem: Limiting reports by department and approved or unapproved software.

Solution: Create a report that uses csv files with all users from each department, along with another csv file for your approved software vendors, or unapproved software vendors. This is useful when your departments don’t match your domains.

You will need to see all of the software installed vendors, and delete your approved list to be able to get an unapproved list, since I found doing a NOT in CSV, will just time out.

*Note: There are limits to the number of elements that can be in a CSV file for reporting. I have noticed that more than about 200 will cause the report to fail. To resolve this, it is necessary to break up the number of users into multiple CSV’s, and use OR statements between them.

Environment Factors: ZENworks AM version 7 sp14 on windows 2003 server, and Oracle 10g database, but the report should work with SQL database.

Example: XML file attached with sample users, and a few software vendors.

If you have any questions you may contact Mark at

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this post.

Categories: Uncategorized


Disclaimer: This content is not supported by Micro Focus. It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test it thoroughly before using it in a production environment.