Query Report Searchable Table Information
The table information available for use in Query Reports, among custom report items, is as follows:
Note
For queries (SQL) to check current status information collected by NAC, please contact the Technical Support Center.
| Searchable Tables |
|---|
| ADMIN, ADMINROLE, ADMINROLE_Bundle_en, ADMINROLE_Bundle_ja, ADMINROLE_Bundle_zh |
| Action_Plugins_Bundle_en, Action_Plugins_Bundle_ja, Action_Plugins_Bundle_zh, AdminAPMgmt, AdminAssign |
| AdminMenuConfig, AdminNodeMatrix, AdminNodeMgmt, AdminPermConfig, AdminPopup, AdminPushToken |
| AgentFailsafe, AppConfirm, AuthSync, AuthSyncConf, CODEMAP, CODEMAP_Bundle_en, CODEMAP_Bundle_ja |
| CODEMAP_Bundle_zh, CONF, CONFUI, CONFUI_Bundle_en, CONFUI_Bundle_ja, CONFUI_Bundle_zh |
| CONF_ADMIN, CONF_APProfile, CONF_Bundle_en, CONF_Bundle_ja, CONF_Bundle_zh, CONF_ClientProfile |
| CONF_LOCAL, CONF_ROLE, CONF_SSID, CONF_SYSTEM, CONF_USER, CONF_VALUE, CenterLBTable |
| CollectorItem, CollectorTarget, CustomLink, DEVINFOALL_THREATPEFILE, DailyReports, DevicePropertyAssign |
| FILTER, FILTEROP, FILTEROP_Bundle_en, FILTEROP_Bundle_ja, FILTEROP_Bundle_zh, FILTERUI |
| FILTERUI_Bundle_en, FILTERUI_Bundle_ja, FILTERUI_Bundle_zh, FixupHistory, GenianModel, GenianSoftware |
| IOP_ControlCustomSetList, IOP_ControlSet, IOP_ControlSetList, IOP_ControlSetProcessList |
| IOP_ControlSetSubj, IOP_CustomSet, IOP_CustomSetList, IOP_SUBJDevice, IOP_SUBJMedia, IOP_UseMediaApp |
| IOP_UseMediaList, IPMNOTICE, InfoColumn, InfoColumn_Bundle_en, InfoColumn_Bundle_ja, InfoColumn_Bundle_zh |
| InfoConf, InfoConfMain, InfoConf_Bundle_en, InfoConf_Bundle_ja, InfoConf_Bundle_zh, Information |
| LOG, LogFilter, LogFilterPropertyAssign, LogIpFilter, MessageTable, MgmtViewColumnMapping |
| NACSETUP, NOTICE, NameResolve, NodeAdmin, Numbers, PEFiles, PERM, PERM_Bundle_en, PERM_Bundle_ja |
| PERM_Bundle_zh, PageExecuteScript, PasswordHistory, PlatformDetect, RMS_Event, RMS_Event_Bundle_en |
| RMS_Event_Bundle_ja, RMS_Event_Bundle_zh, RadAttrInfoColumn, ReportResultData, ResourceBundle |
| SVCMAP, SVCMAP_Bundle_en, SVCMAP_Bundle_ja, SVCMAP_Bundle_zh, SensorDHCPInfo, SensorEvent |
| SensorNetGrp, SoftwareCheckList, SoftwareProduct, SoftwareProductAuthList, SoftwareProductSet |
| SysConst, SysConstResult, SystemInfo, TableVersion, USER, WebUI_SiteMap, WebUI_SiteMap_Bundle_en |
| WebUI_SiteMap_Bundle_ja, WebUI_SiteMap_Bundle_zh, Widget, WidgetLayout, Widget_Bundle_en |
| Widget_Bundle_ja, Widget_Bundle_zh, def_FILTER, Action_PluginCompatVersion |