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

Macros in SQL Queries

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Wish list
View previous topic :: View next topic  
Author Message
Guest






PostPosted: Tue May 13, 2003 3:28 pm    Post subject: Reply with quote

I have a database that records history into seperate tables for each month. The table name contains the 4 digit year and 2 digit month. I'm wanting to be able to have HostMonitor check the monthly history tables without having to update my test each month. Is it possible to use HostMonitor macro variables in the SQL query itself? This way, I could use
select count(*) from History%YYYYMM% where value = X



Back to top
KS-Soft



Joined: 03 Apr 2002
Posts: 12791
Location: USA

PostPosted: Thu May 15, 2003 1:13 am    Post subject: Reply with quote

Its impossible in current version. I have added this task into "to do" list.

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Wish list 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