Hello,
In VMWare world there is a sql server database backend for it. I am trying to sort out a simple way of capturing folder hierarchy for each virtual machine. You can have a top node folder name and subfolders and so on and so forth.
The final result I would like to see is
vmname folder
Menelik \ንግሥተ፡ሳባእ
Ijigayehu \ንግሥተ፡ሳባእ\Menelik
create table #ancestry(id int not null, name nvarchar(50), parentid int null)
insert into #ancestry
select 1, N'ንግሥተ፡ሳባእ', null union
select 2, 'Menelik', 1 union
select 3, 'Bezabeh', 1 union
select 4, 'Ijigayehu', 2 union
select 5, 'Tewodros', 4
select *
From #ancestry
drop table #ancestry