KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

retrieving folder names from hostmonitor

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting
View previous topic :: View next topic  
Author Message
spetterpoep



Joined: 30 Apr 2012
Posts: 9
PostPosted: Thu May 03, 2012 8:22 am    Post subject: retrieving folder names from hostmonitor Reply with quote
Hi

I've made a stored procedure to insert all the folder names from hostmonitor into our database.
Here's a part of the script:
Code:
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?
Back to top
View user's profile Send private message
KS-Soft Europe



Joined: 16 May 2006
Posts: 2832
PostPosted: Thu May 03, 2012 9:06 am    Post subject: Reply with quote
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.

Please check the manual or visit our web site for more information at:
Custom HTML Report: http://www.ks-soft.net/hostmon.eng/mframe.htm#profiles.htm#CustomHTML
HMS script commands: http://www.ks-soft.net/hostmon.eng/mframe.htm#actions.htm#actScript
Back to top
View user's profile Send private message Send e-mail Visit poster's website
spetterpoep



Joined: 30 Apr 2012
Posts: 9
PostPosted: Fri May 04, 2012 12:55 am    Post subject: Reply with quote
Never thought to do it that way.
I'll try it out immediately
Thanks for help
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group
KS-Soft Forum Index