Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
Christian_89
Contributor III

Report Fortianalyzer Local user

hello together

Is it not possible via Fortianalyzer to create a report for a local user on a Fortigate?

If so, does anyone have a general template?

I have created my own database

SELECT
`user local`.`name` AS `user`,
`user local`.`type` AS `User Type`,
`user local`.`expiration` AS `Expiration Date`,
`user local`.`two_factor` AS `FortiToken`,
`devices`.`hostname` AS `Device Hostname`,
`devices`.`serial` AS `Device Serial Number`
FROM
`user local`
LEFT JOIN `devices` ON `user local`.`devname` = `devices`.`name`
WHERE
`user local`.`type` = 'local'
ORDER BY
`user`

Which doesn`t work. and I don`t know why,

8 REPLIES 8
Anthony_E
Community Manager
Community Manager

Hello Christian,


Thank you for using the Community Forum. I will seek to get you an answer or help. We will reply to this thread with an update as soon as possible.


Thanks,

Anthony-Fortinet Community Team.
Anthony_E
Community Manager
Community Manager

Hello Christian,

 

Could we please know which FortiOS version you are using in the FGT and the FAZ?

It will help us to find the solution.

 

Regards, 

Anthony-Fortinet Community Team.
Christian_89

Hello
On the Fortigate is 7.2.3 in use and on the FAZ is 7.2.2 present.

Anthony_E
Community Manager
Community Manager

Hello Christian,

 

Thank you, it will help to find the solution.

 

Regards,

Anthony-Fortinet Community Team.
Christian_89

have you found a solution yet?

Anthony_E

Hello Christian,

 

I am still looking for someone who can help to find it.

 

Regards,

Anthony-Fortinet Community Team.
Christian_89

Have you already found someone or even a solution?

forcemani
New Contributor

Hello Guys /,

Is it possible to have local logs of the policies next to fortianalyzer? As soon as I enable fortianalyzer i dont have any logs locally anymore

Can I adjust this somewhere ? I was not able to find such a command or GUI Option

Regards

10.0.0.0.1 192.168.1.254
Labels
Top Kudoed Authors