Hi James!
I have now configured the Cisco Access Point as a radius client an enabled
all checkboxes - this would be the log table:
USE [Accounting]
GO
/****** Objekt: Table [dbo].[accounting_data] Skriptdatum: 04/08/2010
14:47:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[accounting_data](
[id] [int] IDENTITY(1,1) NOT NULL,
[timestamp] [datetime] NOT NULL,
[Computer_Name] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL,
[Packet_Type] [int] NOT NULL,
[User_Name] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F_Q_User_Name] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Called_Station_Id] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[Calling_Station_Id] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[Callback_Number] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[Framed_IP_Address] [dbo].[ipaddress] NULL,
[NAS_Identifier] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NAS_IP_Address] [dbo].[ipaddress] NULL,
[NAS_Port] [int] NULL,
[Client_Vendor] [int] NULL,
[Client_IP_Address] [dbo].[ipaddress] NULL,
[Client_Friendly_Name] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[Event_Timestamp] [datetime] NULL,
[Port_Limit] [int] NULL,
[NAS_Port_Type] [int] NULL,
[Connect_Info] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Framed_Protocol] [int] NULL,
[Service_Type] [int] NULL,
[Authentication_Type] [int] NULL,
[NP_Policy_Name] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Reason_Code] [int] NULL,
[Class] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Session_Timeout] [int] NULL,
[Idle_Timeout] [int] NULL,
[Termination_Action] [int] NULL,
[EAP_Friendly_Name] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[Acct_Status_Type] [int] NULL,
[Acct_Delay_Time] [int] NULL,
[Acct_Input_Octets] [int] NULL,
[Acct_Output_Octets] [int] NULL,
[Acct_Session_Id] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[Acct_Authentic] [int] NULL,
[Acct_Session_Time] [int] NULL,
[Acct_Input_Packets] [int] NULL,
[Acct_Output_Packets] [int] NULL,
[Acct_Terminate_Cause] [int] NULL,
[Acct_Multi_Session_Id] [nvarchar](255) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL,
[Acct_Link_Count] [int] NULL,
[Acct_Interim_Interval] [int] NULL,
[Tunnel_Type] [int] NULL,
[Tunnel_Medium_Type] [int] NULL,
[Tunnel_Client_Endpoint] [nvarchar](255) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL,
[Tunnel_Server_Endpoint] [nvarchar](255) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL,
[Acct_Tunnel_Connection] [nvarchar](255) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL,
[Tunnel_Pvt_Group_Id] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[Tunnel_Assignment_Id] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[Tunnel_Preference] [int] NULL,
[MS_Acct_Auth_Type] [int] NULL,
[MS_Acct_EAP_Type] [int] NULL,
[MS_RAS_Version] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MS_RAS_Vendor] [int] NULL,
[MS_CHAP_Error] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MS_CHAP_Domain] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MS_MPPE_Encryption_Types] [int] NULL,
[MS_MPPE_Encryption_Policy] [int] NULL,
[Proxy_Policy_Name] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[Provider_Type] [int] NULL,
[Provider_Name] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Remote_Server_Address] [dbo].[ipaddress] NULL,
[MS_RAS_Client_Name] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[MS_RAS_Client_Version] [nvarchar](255) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL,
[MS_Quarantine_State] [int] NULL
) ON [PRIMARY]
Up to now I do not have any data that represents cumulative upload or
download for billing?
Is this an issue of the radius client or something of the radius clients
(cisco access points)?
kind regards
andy
Post by James McIllece [MS]Post by Andreas WöcklHi Group!
Is it possible to monitor the incoming and outgoing traffic from a
radius client with the NPS Accounting feature?
Up to now I am only able to log the session starts and session ends
from my cisco WLAN Access Point!
kind regards
andy
Hi Andy --
Network Policy Server (NPS) supports Remote Authentication Dial-In User
Service (RADIUS) accounting, which you can use to track network usage for
auditing and billing purposes. Accounting data can also be queried to
assist with network access troubleshooting.
You can find out more about NPS accounting from the NPS Technical
Reference, at http://technet.microsoft.com/en-
us/library/dd197475(WS.10).aspx
--
James McIllece, Microsoft
Please do not send email directly to this alias. This is my online account
name for newsgroup participation only.
This posting is provided "AS IS" with no warranties, and confers no rights.