NPS Logging is missing tables

ComputerHabit 781 Reputation points
2024-04-17T21:24:38.6533333+00:00

I've setup NPS. I've had it running on other servers. I'm setting up SQL for accounting.

The table created is NOT what I am used to seeing.

The table created is:

SELECT TOP (1000) [id]
      ,[timestamp]
      ,[Computer_Name]
      ,[Packet_Type]
      ,[User_Name]
      ,[Client_IP_Address]
      ,[Fully_Qualified_Machine_Name]
      ,[NP_Policy_Name]
      ,[MS_Quarantine_State]
      ,[MS_Extended_Quarantine_State]
      ,[System_Health_Result]
      ,[System_Health_ResultEx]
      ,[MS_Network_Access_Server_Type]
      ,[Called_Station_Id]
      ,[MS_Quarantine_Grace_Time]
      ,[MS_Quarantine_User_Class]
      ,[Client_IPv6_Address]
      ,[Not_Quarantine_Capable]
      ,[AFW_Zone]
      ,[AFW_Protection_Level]
      ,[Quarantine_Update_Non_Compliant]
      ,[MS_Machine_Name]
      ,[OS_Version]
      ,[MS_Quarantine_Session_Id]
  FROM [NPSODBC].[dbo].[accounting_data]

But in my old database it is

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [id]
      ,[timestamp]
      ,[Computer_Name]
      ,[Packet_Type]
      ,[User_Name]
      ,[F_Q_User_Name]
      ,[Called_Station_Id]
      ,[Calling_Station_Id]
      ,[Callback_Number]
      ,[Framed_IP_Address]
      ,[NAS_Identifier]
      ,[NAS_IP_Address]
      ,[NAS_Port]
      ,[Client_Vendor]
      ,[Client_IP_Address]
      ,[Client_Friendly_Name]
      ,[Event_Timestamp]
      ,[Port_Limit]
      ,[NAS_Port_Type]
      ,[Connect_Info]
      ,[Framed_Protocol]
      ,[Service_Type]
      ,[Authentication_Type]
      ,[NP_Policy_Name]
      ,[Reason_Code]
      ,[Class]
      ,[Session_Timeout]
      ,[Idle_Timeout]
      ,[Termination_Action]
      ,[EAP_Friendly_Name]
      ,[Acct_Status_Type]
      ,[Acct_Delay_Time]
      ,[Acct_Input_Octets]
      ,[Acct_Output_Octets]
      ,[Acct_Session_Id]
      ,[Acct_Authentic]
      ,[Acct_Session_Time]
      ,[Acct_Input_Packets]
      ,[Acct_Output_Packets]
      ,[Acct_Terminate_Cause]
      ,[Acct_Multi_Session_Id]
      ,[Acct_Link_Count]
      ,[Acct_Interim_Interval]
      ,[Tunnel_Type]
      ,[Tunnel_Medium_Type]
      ,[Tunnel_Client_Endpoint]
      ,[Tunnel_Server_Endpoint]
      ,[Acct_Tunnel_Connection]
      ,[Tunnel_Pvt_Group_Id]
      ,[Tunnel_Assignment_Id]
      ,[Tunnel_Preference]
      ,[MS_Acct_Auth_Type]
      ,[MS_Acct_EAP_Type]
      ,[MS_RAS_Version]
      ,[MS_RAS_Vendor]
      ,[MS_CHAP_Error]
      ,[MS_CHAP_Domain]
      ,[MS_MPPE_Encryption_Types]
      ,[MS_MPPE_Encryption_Policy]
      ,[Proxy_Policy_Name]
      ,[Provider_Type]
      ,[Provider_Name]
      ,[Remote_Server_Address]
      ,[MS_RAS_Client_Name]
      ,[MS_RAS_Client_Version]
      ,[MS_Quarantine_State]
  FROM [NPSODBC].[dbo].[accounting_data]

Everything else looks the same. Is it my format? I have it as DTS Compliant.

Should it be ODBC Legacy or IAS? It isn't on my old server so I'm confused why.

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,151 questions
{count} votes