Global report for local admins
Global report for local admins
Is it possible to one, turn on the local admin group monitor for all clients in mass and then be able to export a report for all of them without opening each client and using the export to excel option?
Re: Global report for local admins
It is if you have SQL access to the Automate Database. Basically the plugin queries database for rows and columns based on clientID, Then exports it out to CSV.
You could make the same queries but without the "Where as ClientID" to get all entries and then copy them out to csv directly.
Here are the SQL tables for the LAGM tables.
You want the plugin_p4a_habitat_lagm_users table and it will return items like so. ClientID, ComputerID, (Username in admin group) and scan date.
You could make the same queries but without the "Where as ClientID" to get all entries and then copy them out to csv directly.
Here are the SQL tables for the LAGM tables.
You want the plugin_p4a_habitat_lagm_users table and it will return items like so. ClientID, ComputerID, (Username in admin group) and scan date.
Re: Global report for local admins
Since your using Habitat, You have a SQL query tool in Habitat that should draw the data out of table for you.
Re: Global report for local admins
Here try this SQL Query, it will pull down Computer Name and Client Name as well as user data.
Code: Select all
SELECT A.ClientID, A.ComputerID, A.Username, A.ScanDate, C.Name as computer, B.Name as Client FROM plugin_p4a_habitat_lagm_users A LEFT JOIN computers C on A.computerID = C.ComputerID LEFT JOIN clients B on A.clientID = B.clientID;
Re: Global report for local admins
As for enabling a lot of clients at once,
Set Master Switch to 1 for every client ID you add using the insert command.
Set Master Switch to 1 for every client ID you add using the insert command.
Code: Select all
INSERT INTO `plugin_p4a_habitat_lagm_config`
(`ClientID`,
`MasterSwitch`)
VALUES
(<{ClientID: }>,
<{MasterSwitch: 0}>);