Hi Team, Does the User table have a 'type' column ...
# general
l
Hi Team, Does the User table have a 'type' column on Linux VMs? I failed to see this column after the latest version (5.10.2) was installed.
s
What do you mean that you fail to see the column? How are you seeing results? what's the query? That being said though, the
type
column is a Windows only column, that on other platforms is hidden, which means that it can still be queried, directly, but it won't appear if you select it with
*
.
This hasn't changed in a while.
l
Hi Stefano, Thanks for your reply! I got no
type
column when I used
select * from users;
. I got a
type
column but no value when I used
select type from users;
. It shew
type = .
My purpose is to filter AD users. I only want to audit local users.
s
I see, unfortunately as I was mentioning above, the
type
column is filled only for Windows. On other platforms it will be empty.
l
Thanks for your confirmation Stefano! Have a nice day!