All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
set @dummy = 1
-- Insert statements for procedure here
OPEN @cur_names
FETCH NEXT
FROM @cur_names INTO @isv_nme
WHILE @@FETCH_STATUS = 0
BEGIN
IF @isv_nme = @p_name
BEGIN
set @dummy = 0
END
ELSE
PRINT 'EXISTSSSSSS'
FETCH NEXT
FROM @cur_names INTO @isv_nme
END
CLOSE @cur_names
DEALLOCATE @cur_names
if @dummy = 1
BEGIN
INSERT INTO tbl_ISV (isv_name) values(@p_name)
END
END
I want to get all the foldernames of the folders in hostmonitor so I can set it as a parameter for my stored procedure (I will use powershell to call the stored procedure). This part is done with maybe a few minor mistakes but my question is... Is there a possibility to get all the folder names?
You may use HostMonitor reports to retrieve Folder names.
E.g. you may create Custom HTML report, and fill only "Folder title" section with %Folder% or %FullPath% macro variable.
Such Report profile will create txt file with list of folders.
Also, this report can be generated using HMS script command CreateReport.
