Page 1 of 1
ADmon Database Tables
Posted: Mon Jun 09, 2025 2:51 pm
by GThibeault
I've been using Admon for a long time, and it works great. What I'd like to do is generate a report or search for all clients that show who is in the local admin groups. Being able to see the local admin groups at the customer level is great, but seeing it all the root for all customers would be even better. I'm not looking to manipulate it, just view it. Since you already have the data, I'm guessing it must be in the database somewhere. Can you point me in the right direction? Keep the plugins coming. Thanks!
Re: ADmon Database Tables
Posted: Wed Jun 11, 2025 2:55 pm
by Cubert
Awesome! Glad to see our products making life a bit easier for the IT people out there.
In the LabTech Database there will be the following tables for your ADMON plugin.
plugin_sw_admon_users
plugin_sw_admon_monitor
plugin_sw_admon_config
plugin_sw_admon_alerts
This would be current data, What is on the agent now
Code: Select all
Table: plugin_sw_admon_users
Columns:
ClientID int PK
ComputerID int PK
Username varchar(245) PK
ScanDate datetime
This is the table that holds what should be on the agent. This is only created when the monitor check box is activated. And only captures the the current state once when selected. To refresh watch list you must uncheck and recheck monitor checkbox.
Code: Select all
Table: plugin_sw_admon_monitor
Columns:
ClientID int PK
ComputerID int PK
Username varchar(245) PK
ScanDate datetime
Holds configuration data for each client in plugin
Code: Select all
Table: plugin_sw_admon_config
Columns:
ClientID int PK
MasterSwitch int
MonitorAdd int
MonitorRemove int
AutoRestore int
CreateTicket int
MonitorEnabled int
Interval int
Opt1 varchar(245)
Opt2 varchar(245)
Opt3 int
Opt4 int
Hold alert data per agent
Code: Select all
Table: plugin_sw_admon_alerts
Columns:
ComputerID int PK
ClientID int
Username varchar(245)
Alert int
Ticket int
AlertDate datetime