The IT Assets Database was replaced by the IT Admins CMDB and is EOL / End of Life, no further development will be done on this project.
This is an example of how you could use an external database to view information within the IT Assets database. In this case we talk about Microsoft NPS respective RADIUS logging on a SQL server database.
Please reference the following link on how to create and prepare an independent database for this https://docs.microsoft.com/en-us/windows/desktop/Nps/sql-programmability. I further highly recommend to have a SQL Agent job running a script that deletes records older then a defined amount of days, cause this RADIUS database might grow extremely fast and big.
What you can do is create a view as you can see it below – either directly in the RADIUS database or theoretically in the ITAssetsDB database that references the RADIUS database table.
This view is bound in with independent credentials via SysTablesAttachedSQL to the IT Assets database file in Microsoft Access. The view exists in the ITAssetsDB and the table as well – but it is only there as an example, it is not recommended to use the same database as your RADIUS SQL logging target. Keep it separated.
If you click on RADIUS you would see how the view is interpreted in the application and how you could actually search through it – there is no example data in it – but the principle is the same as for all other search and filter capabilities.
1 2 3 4 5 6 7 8 9 10 | SELECT TOP (200) id, timestamp, Packet_Type, ClientUserName, Called_Station_Id, Calling_Station_Id, Framed_IP_Address, Client_Vendor, Client_IP_Address, Client_Friendly_Name, Event_Timestamp, NAS_Port, NAS_Port_Type, Service_Type, Authentication_Type, NP_Policy_Name, Reason_Code, Session_Timeout, EAP_Friendly_Name, Acct_Status_Type, Acct_Delay_Time, Acct_Session_Id, Acct_Authentic, Acct_Terminate_Cause, Tunnel_Type, Tunnel_Medium_Type, Expr1, Computer_Name, User_Name, F_Q_User_Name, Callback_Number, NAS_Identifier, NAS_IP_Address, Port_Limit, Connect_Info, Framed_Protocol, Class, Idle_Timeout, Termination_Action, Acct_Input_Octets, Acct_Output_Octets, Acct_Session_Time, Acct_Input_Packets, Acct_Output_Packets, Acct_Multi_Session_Id, Acct_Link_Count, Acct_Interim_Interval, Tunnel_Client_Endpoint, Tunnel_Server_Endpoint, Acct_Tunnel_Connection, Tunnel_Pvt_Group_Id, Tunnel_Assignment_Id, Tunnel_Preference, MS_Acct_Auth_Type, MS_RAS_Version, MS_Acct_EAP_Type, MS_RAS_Vendor, MS_CHAP_Error, MS_CHAP_Domain, MS_MPPE_Encryption_Types, MS_MPPE_Encryption_Policy, Proxy_Policy_Name, Provider_Name, Provider_Type, Remote_Server_Address, MS_RAS_Client_Version, MS_Quarantine_State, MS_RAS_Client_Name FROM viewRADIUS |
Additional information about the setup for RADIUS can be found on the blog here.