Trying to pull specific fields out of the database tables "LastContact" and listing the output with a timestamp (LastContact), ManagerName (hostname), OSType etc. This is the query I'm using:
SELECT [Hostname], [ManagerName],[OSType],[LastContact]FROM [SCSPDB].[dbo].[ASSET_VW] WHERE LastContact < dateadd(day,-1,getdate());
Works fine in SQL Explorer but not in DBX (errors out with the "index 1 out of range" message). Do I need to change my query from using a Rising Column (LastContact) to something else?
I answered my own question.....DBX is very finicky about its queries. This particular query is too static and DBX requires a "?" in order for the Rising Column to assign a value. This works:
SELECT [Hostname], [ManagerName],[OSType],[LastContact]FROM [SCSPDB].[dbo].[ASSET_VW] WHERE LastContact > ? ORDER BY LastContact ASC
I answered my own question.....DBX is very finicky about its queries. This particular query is too static and DBX requires a "?" in order for the Rising Column to assign a value. This works:
SELECT [Hostname], [ManagerName],[OSType],[LastContact]FROM [SCSPDB].[dbo].[ASSET_VW] WHERE LastContact > ? ORDER BY LastContact ASC