Hi,

I'm trying to get the list of folders and the computers which are within those folders from the database. We are using ZCM 2017 that is backed by a MS-SQL Server Database.

On the database, I stumbled upon a table called zFolder which looked like a good starting point. Even though the table only has the columns ZUID and idcol, the foreign keys seem to look promising. But on the zDevice Table, the column "Managed Folder" (which is a referenced column) is all NULL.

Where do I find those folders, that hold all the computers?

Thanks.