Hi Berthold,

This could be done from the CLI:

Find Usernames where Country = Canada.
 $seek attr=0x101f4,val=Canada | awk '{print $2}'
 MName
 JoeBlow


To get all of the fields, you could do something like this:

country=Canada
echo
"UserID,User_Full_Name,User_Phone,User_Location,User_Organization,User_S
tart,User_Shortcuts,User_Community_String,User_Picture_File,User_ID,User
_Country,User_Street,User_City,User_State,User_Site,User_Department,User
_s_phone_ID,User_s_phone_passwd,User_s_phone_notif_type,User_s_phone_tel
_nr,User_s_phone_pager_nr,User_s_phone_pager_string,User_s_phone_notif_i
nterval,User_s_phone_notif_retry_cnt,User_s_phone_notif_retry_max,User_s
_phone_last_notif,User_Email"

seek attr=0x101f4,val=$country |  grep -v MHandle | \
while read mh name mth mtn ; do 
        printf $name
        show attributes mh=$mh | grep User_ | cut -c68-300 | \
                 while read line ; do printf ",$line" ; done ; echo 
done

This would give a output in a CSV format with all of the User_ fields.

UserID,User_Full_Name,User_Phone,User_Location,User_Organization,User_St
art,User_Shortcuts,User_Community_String,User_Picture_File,User_ID,User_
Country,User_Street,User_City,User_State,User_Site,User_Department,User_
s_phone_ID,User_s_phone_passwd,User_s_phone_notif_type,User_s_phone_tel_
nr,User_s_phone_pager_nr,User_s_phone_pager_string,User_s_phone_notif_in
terval,User_s_phone_notif_retry_cnt,User_s_phone_notif_retry_max,User_s_
phone_last_notif,User_Email
JoeBlow,Joseph L Blow,416-555-5555,,RBC,,0.0.0.0,ADMIN,0,,,Canada,1 Nice
Street,Toronto,Ontario,,Telecom ,,,0,,,,10,0,6,,[email protected]
    

Hope that helps,
....rod


-----Original Message-----
From: Hofmann, Berthold [mailto:[email protected]] 
Sent: 2010, April, 21 9:36 AM
To: spectrum
Subject: [spectrum] Find all spectrum users in a specific country

Hi all,

I need a list of all spectrum users in a specific country.
I can see it in the gui, but I need it as a file. What command
can generate such a list. If possible, I need all information
which are visible in the user manager.

Regards
Berthold
---
To unsubscribe from spectrum, send email to [email protected] with the
body: unsubscribe spectrum [email protected]
_______________________________________________________________________

This e-mail may be privileged and/or confidential, and the sender does not waive
any related rights and obligations. Any distribution, use or copying of this 
e-mail or the information
it contains by other than an intended recipient is unauthorized.
If you received this e-mail in error, please advise me (by return e-mail or 
otherwise) immediately.

Ce courriel peut contenir des renseignements protégés et confidentiels.
L’expéditeur ne renonce pas aux droits et obligations qui s’y rapportent.
Toute diffusion, utilisation ou copie de ce courriel ou des renseignements 
qu’il contient
par une personne autre que le destinataire désigné est interdite.
Si vous recevez ce courriel par erreur, veuillez m’en aviser immédiatement, 
par retour de courriel ou par un autre moyen.

---
To unsubscribe from spectrum, send email to [email protected] with the body: 
unsubscribe spectrum [email protected]

Reply via email to