Create a join between the SHR:Assignment and the User form and you might be able to pull out what you want... Use the Login Name field to define your join criteria..
Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. ----- Original Message ---- From: Jase Brandon <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Tuesday, December 12, 2006 6:39:35 PM Subject: Remedy License/Group Count ** Hi Listers, Does anyone know of a quick way to create a .csv with the number of licenses used and which groups those user's are in? I tried hitting the user form, but it translates the group name to group id. I tried using SHR:Assignment, but it doesn't have a license field. I know I could create a join form and get the data from there, just wondered if anyone else had done this an easier way with Out of the Box 6.0. Thanks in advance to all, Jase Brandon Remedy Administration/Development Customer Support Systems Group Desk - (615) - 320-4494 Cell - (334) - 318-5426 [EMAIL PROTECTED] DaVita Inc. __20060125_______________________This posting was submitted with HTML in it___ ____________________________________________________________________________________ Want to start your own business? Learn how on Yahoo! Small Business. http://smallbusiness.yahoo.com/r-index _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
