TIA
Clancy
Here is a copy of
select * from RadAttributes
select * from Radatconfigs
I am using the TEST profile for this function
RadAttributeID,RadVendorID,RadVendorType,Name,Type
1,0,0,User-Name,0
2,0,0,Password,0
3,0,0,Challenge-Response,0
4,0,0,NAS-Identifier,2
5,0,0,NAS-Port,1
6,0,0,User-Service,1
7,0,0,Framed-Protocol,1
8,0,0,Framed-Address,2
9,0,0,Framed-Netmask,2
10,0,0,Framed-Routing,1
11,0,0,Framed-Filter,0
12,0,0,Framed-MTU,1
13,0,0,Framed-Compression,1
14,0,0,Login-Host,2
15,0,0,Login-Service,1
16,0,0,Login-TCP-Port,1
17,0,0,Change-Password,0
18,0,0,Reply-Message,0
19,0,0,Callback-Number,0
20,0,0,Callback-Name,0
21,0,0,Expiration,3
22,0,0,Framed-Route,0
23,0,0,Framed-IPX-Network,1
24,0,0,State,0
25,0,0,Class,0
26,0,0,Vendor-Specific,0
26,9,1,Cisco-AVPair,0
26,9,187,Multilink-ID,1
26,9,188,Num-In-Multilink,1
26,9,190,Pre-Input-Octets,1
26,9,191,Pre-Output-Octets,1
26,9,192,Pre-Input-Packets,1
26,9,193,Pre-Output-Packets,1
26,9,195,Disconnect-Cause,1
26,9,197,Data-Rate,1
26,9,198,PreSession-Time,1
26,429,36864,IP-Input-Filter,0
26,429,36867,IP-Output-Filter,0
26,429,36872,IES_NEXT_HOP_GATEWAY,2
26,429,36879,Primary-DNS-Server,2
26,429,36880,Secondary-DNS-Server,2
26,429,36881,Primary-NBNS-Server,2
26,429,36882,Secondary-NBNS-Server,2
26,429,36889,Chasis-Call-Slot,1
26,429,36890,Chasis-Call-Span,1
26,429,36891,Chasis-Call-Channel,1
26,429,36899,Connect-Speed,1
26,429,36900,Framed-IP-Address-Pool-Name,0
26,429,36901,MP-EDO,0
26,429,36902,Local-Framed-IP-Addr,1
26,429,38913,Speed-Of-Connection,1
26,429,38914,Max-Channels,1
26,429,38918,Compression-Algorithm,1
26,429,38931,Send-Name,0
26,429,38932,Send-Password,0
26,429,38933,Start-Time,1
26,429,38934,End-Time,1
26,429,38949,Local-IP-Address,0
26,429,38950,Routing-Protocol,1
26,429,38951,Modem-Group,1
26,429,48733,Channel-Connected-To,1
26,429,48734,Slot-Connected-To,1
26,429,48735,Device-Connected-To,1
27,0,0,Session-Timeout,1
28,0,0,Idle-Timeout,1
29,0,0,Termination-Action,1
30,0,0,NAS-Port-DNIS,0
31,0,0,Caller-Id,0
32,0,0,NAS-Identifier,0
33,0,0,Proxy-State,0
34,0,0,Login-LAT-Service,0
35,0,0,Login-LAT-Node,0
36,0,0,Login-LAT-Group,0
37,0,0,Framed-AppleTalk-Link,1
38,0,0,Framed-AppleTalk-Network,1
39,0,0,Framed-AppleTalk-Zone,0
40,0,0,Acct-Status-Type,1
41,0,0,Acct-Delay-Time,1
42,0,0,Acct-Input-Octets,1
43,0,0,Acct-Output-Octets,1
44,0,0,Acct-Session-Id,0
45,0,0,Acct-Authentic,1
46,0,0,Acct-Session-Time,1
47,0,0,Acct-Input-Packets,1
48,0,0,Acct-Output-Packets,1
49,0,0,Acct-Terminate-Cause,1
50,0,0,Acct-Multi-Session-ID,0
51,0,0,Acct-Link-Count,1
52,0,0,Acct-Input-Gigawords,1
53,0,0,Acct-Output-Gigawords,1
55,0,0,Event-Time,3
60,0,0,CHAP-Challenge,0
61,0,0,NAS-Port-Type,1
62,0,0,Port-Limit,1
63,0,0,Login-LAT-Port,0
64,0,0,Tunnel-Type,1
65,0,0,Tunnel-Medium-Type,1
66,0,0,Tunnel-Client-Endpoint,0
67,0,0,Tunnel-Server-Endpoirt,0
68,0,0,Tunnel-Connection,0
69,0,0,Tunnel-Password,0
70,0,0,ARAP-Password,0
71,0,0,ARAP-Features,0
72,0,0,ARAP-Zone-Access,1
73,0,0,ARAP-Security,1
74,0,0,ARAP-Security-Data,0
75,0,0,Password-Retry,1
76,0,0,Prompt,1
77,0,0,Connect-Info,0
78,0,0,Configuration-Token,0
79,0,0,EAP-Message,0
80,0,0,Signature,0
81,0,0,Tunnel-Private-Group-ID,0
82,0,0,Tunnel-Assignment-ID,0
83,0,0,Tunnel-Preference,0
84,0,0,ARAP-Challenge-Response,0
85,0,0,Acct-Interim-Interval,0
90,0,0,Ascend-Filter,0
91,0,0,Ascend-Telnet-Profile,0
120,0,0,Ascend-Modem-PortNo,1
121,0,0,Ascend-Modem-SlotNo,1
122,0,0,Ascend-Modem-ShelfNo,1
128,0,0,Ascend-Shared-Profile-Enable,1
133,0,0,Ascend-BACP-Enable,1
187,0,0,Ascend-Multilink-ID,1
188,0,0,Ascend-Num-In-Multilink,1
189,0,0,Ascend-First-Dest,2
190,0,0,Ascend-Pre-Input-Octets,1
191,0,0,Ascend-Pre-Output-Octets,1
192,0,0,Ascend-Pre-Input-Packets,1
193,0,0,Ascend-Pre-Output-Packets,1
194,0,0,Ascend-Maximum-Time,1
195,0,0,Ascend-Disconnect-Cause,1
196,0,0,Ascend-Connect-Progress,1
197,0,0,Ascend-Data-Rate,1
198,0,0,Ascend-PreSession-Time,1
199,0,0,Ascend-Token-Idle,1
200,0,0,Ascend-Token-Immediate,1
201,0,0,Ascend-Require-Auth,1
202,0,0,Ascend-Number-Sessions,0
203,0,0,Ascend-Authen-Alias,0
204,0,0,Ascend-Token-Expiry,1
205,0,0,Ascend-Menu-Selector,0
206,0,0,Ascend-Menu-Item,0
207,0,0,Ascend-PW-Warntime,1
208,0,0,Ascend-PW-Lifetime,1
209,0,0,Ascend-IP-Direct,2
210,0,0,Ascend-PPP-VJ-Slot-Comp,1
211,0,0,Ascend-PPP-VJ-1172,1
212,0,0,Ascend-PPP-Async-Map,1
213,0,0,Ascend-Third-Prompt,0
214,0,0,Ascend-Send-Secret,0
215,0,0,Ascend-Receive-Secret,0
216,0,0,Ascend-IPX-Peer-Mode,1
217,0,0,Ascend-IP-Pool-Definition,0
218,0,0,Ascend-Assign-IP-Pool,1
219,0,0,Ascend-FR-Direct,1
220,0,0,Ascend-FR-Direct-Profile,0
221,0,0,Ascend-FR-Direct-DLCI,1
222,0,0,Ascend-Handle-IPX,1
223,0,0,Ascend-Netware-timeout,1
224,0,0,Ascend-IPX-Alias,1
225,0,0,Ascend-Metric,1
226,0,0,Ascend-PRI-Number-Type,1
227,0,0,Ascend-Dial-Number,0
228,0,0,Ascend-Route-IP,1
229,0,0,Ascend-Route-IPX,1
230,0,0,Ascend-Bridge,1
231,0,0,Ascend-Send-Auth,1
232,0,0,Ascend-Send-Passwd,0
233,0,0,Ascend-Link-Compression,1
234,0,0,Ascend-Target-Util,1
235,0,0,Ascend-Maximum-Channels,1
236,0,0,Ascend-Inc-Channel-Count,1
237,0,0,Ascend-Dec-Channel-Count,1
238,0,0,Ascend-Seconds-Of-History,1
239,0,0,Ascend-History-Weigh-Type,1
240,0,0,Ascend-Add-Seconds,1
241,0,0,Ascend-Remove-Seconds,1
242,0,0,Ascend-Data-Filter,4
243,0,0,Ascend-Call-Filter,4
244,0,0,Ascend-Idle-Limit,1
245,0,0,Ascend-Preempt-Limit,1
246,0,0,Ascend-Callback,1
247,0,0,Ascend-Data-Svc,1
248,0,0,Ascend-Force-56,1
249,0,0,Ascend-Billing-Number,0
250,0,0,Ascend-Call-By-Call,1
251,0,0,Ascend-Transit-Number,0
252,0,0,Ascend-Host-Info,0
253,0,0,Ascend-PPP-Address,2
254,0,0,Ascend-MPP-Idle-Percent,1
255,0,0,Ascend-Xmit-Rate,1
RadATConfigID,AccountType,RadAttributeID,Data,Value,RadVendorID,RadVendorTyp
e,RadCheck
1,PPP,6,2,2,0,0,
2,PPP,7,1,1,0,0,
3,EMail,6,2,2,0,0,
4,EMail,7,1,1,0,0,
5,EMail,11,mailonly,0,0,0,
6,SLIP,6,2,2,0,0,
7,SLIP,7,2,2,0,0,
8,ISDN,6,2,2,0,0,
9,ISDN,7,1,1,0,0,
10,Shell,6,1,1,0,0,
11,Shell,14,1.2.3.4,0,0,0,
12,Shell,15,1,1,0,0,
14,PPP,27,21600,21600,0,0,0
15,PPP,28,3600,3600,0,0,0
17,TEST,6,2,2,0,0,0
18,TEST,7,1,1,0,0,0
25,TEST,26,207.250.152.4,2,429,36872,0