Macros in SQL Queries

Guest · Post by **Guest** » Tue May 13, 2003 3:28 pm

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

KS-Soft · Post by **KS-Soft** » Thu May 15, 2003 1:13 am

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

Regards
Alex