Report Fortianalyzer Local user

[Christian_89]

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,

[Anthony_E]

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_E]

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, 

[Christian_89]

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

[Anthony_E]

Hello Christian,

Thank you, it will help to find the solution.

Regards,

[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,

[Christian_89]

Have you already found someone or even a solution?

[forcemani]

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