Quarantined Device location in R1 Database?
Trying to find the DB location of quarantined devices for some report/notifications I want to setup.
I'm connected with mySQL and digging around, they don't show in the MACHINE table. I've checked several other table I thought they may live with no luck.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
KevinG
2 weeks ago
R1 is the DB user accessing ORG1.* database tables.
I believe that the information you are looking for is in KBSYS.AGENT_QUARANTINE.*
From the System UI create a SQL report with the following SQL statement. This will get you started.
select KBSYS.AGENT_QUARANTINE.*, ORG1.MACHINE.NAME
from KBSYS.AGENT_QUARANTINE
join ORG1.MACHINE on KBSYS.AGENT_QUARANTINE.KUID = ORG1.MACHINE.KUID
Comments:
-
I gave that a shot in MySQL and in KACE creating and got the same result:
SELECT command denied to user 'R1'@'localhost' for table `KBSYS`.`AGENT_QUARANTINE` - mstevens3 3 days ago
