NPS Logging is missing tables
ComputerHabit
781
Reputation points
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.